Re: [HACKERS] Bumping block size to 16K on FreeBSD...

2003-08-28 Thread Jim Mercer
h? > > I think we forced an initdb for beta2 for other reasons, but I'm hoping > to avoid any more in the 7.4 branch. if it does in fact give performance for FreeBSD (and possibly others), at least make it a build time option. -- [ Jim Mercer[EMAIL PROTECTE

Re: [HACKERS] Possible bug in update?

2003-08-28 Thread Jim Mercer
857008 > update pom_c2996804 set p3=3268837857008 where p3=34804837857008 > commit not overly clear from the debug statements, but are all the above lines also ended with a semi-colon? -- [ Jim Mercer[EMAIL PROTECTED] +1 416 410-5633 ] [ I want to live f

Re: [HACKERS] hacker help: PHP-4.2.3 patch to allow restriction of database access

2002-09-28 Thread Jim Mercer
On Sat, Sep 28, 2002 at 03:57:27PM +0200, Michael Paesold wrote: > Jim Mercer <[EMAIL PROTECTED]> wrote: > > as it currently stands, virtual hosts can trample all over other > databases, > > and with the nature of a single uid for all apache/php/libpq proceses, > &g

Re: [HACKERS] hacker help: PHP-4.2.3 patch to allow restriction of database access

2002-09-28 Thread Jim Mercer
On Sat, Sep 28, 2002 at 01:08:36PM +0200, Peter Eisentraut wrote: > Jim Mercer writes: > > ideally, i'd like to have users-per-database, as opposed to the global > > model we have now. > > That's in the works. Some form of this will be in 7.3. cool! > >

Re: [HACKERS] hacker help: PHP-4.2.3 patch to allow restriction of database access

2002-09-26 Thread Jim Mercer
On Thu, Sep 26, 2002 at 11:42:44PM -0400, Tom Lane wrote: > Jim Mercer <[EMAIL PROTECTED]> writes: > > as best i can understand, there is no way to get apach/php/pgsql configured > > (using "PostgreSQL's native access mappings") that would disallow php code >

Re: [HACKERS] hacker help: PHP-4.2.3 patch to allow restriction of database access

2002-09-26 Thread Jim Mercer
On Fri, Sep 27, 2002 at 12:06:43PM +1000, Gavin Sherry wrote: > On Thu, 26 Sep 2002, Jim Mercer wrote: > > maybe not _totally_ secure, but much moreso than nothing. > > I was basically just suggesting that its effect needs to be > documented. "This needs to be used in

Re: [HACKERS] hacker help: PHP-4.2.3 patch to allow restriction of database access

2002-09-26 Thread Jim Mercer
On Fri, Sep 27, 2002 at 11:15:35AM +1000, Gavin Sherry wrote: > On Thu, 26 Sep 2002, Jim Mercer wrote: > > > I would think so, and IMHO, that's where pgsql access control > > > belongs, with pgsql. > > I totally disagree. It is a language level restriction, no

[HACKERS] hacker help: PHP-4.2.3 patch to allow restriction of database access

2002-09-26 Thread Jim Mercer
t from connecting to any database on the system. i understand that on a user level, we can control which tables they have access to (disregarding that almost all access will be by the "web" user). can anyone make some valid arguments for/against the patch in php? or any suggestions on

Re: [HACKERS] PostgreSQL mission statement?

2002-05-02 Thread Jim Mercer
On Thu, May 02, 2002 at 09:45:45PM -0400, mlw wrote: > Jim Mercer wrote: > > On Thu, May 02, 2002 at 09:14:03PM -0400, mlw wrote: > > > Jim Mercer wrote: > > > > On Thu, May 02, 2002 at 08:41:30PM -0400, mlw wrote: > > > > > A mission statement is l

Re: [HACKERS] PostgreSQL mission statement?

2002-05-02 Thread Jim Mercer
On Thu, May 02, 2002 at 09:14:03PM -0400, mlw wrote: > Jim Mercer wrote: > > > > On Thu, May 02, 2002 at 08:41:30PM -0400, mlw wrote: > > > A mission statement is like a tie. > > > > straw vote! > > > > who on the list wears ties? > > How

Re: [HACKERS] PostgreSQL mission statement?

2002-05-02 Thread Jim Mercer
On Thu, May 02, 2002 at 08:41:30PM -0400, mlw wrote: > A mission statement is like a tie. straw vote! who on the list wears ties? -- [ Jim Mercer[EMAIL PROTECTED] +1 416 410-5633 ] [ I want to live forever, or die trying.] ---(

Re: [HACKERS] PostgreSQL mission statement?

2002-05-02 Thread Jim Mercer
e'd all laugh. none of them are THE BEST, but all of them strive to be as good as they can make them, and all of them borrow from each other in order to make their version better in the eyes of their audience. -- [ Jim Mercer[EMAIL PROTECTED] +1 416 4

Re: [HACKERS] PostgreSQL mission statement?

2002-05-02 Thread Jim Mercer
On Thu, May 02, 2002 at 01:43:39PM +0100, Nigel J. Andrews wrote: > I like: > > We'll store your data; if we think it'll be an interesting enough > diversion for us. gets my vote. 8^) -- [ Jim Mercer[EMAIL PROTECTED] +1 416 410-5633 ] [ I want t

Re: [HACKERS] PostgreSQL mission statement?

2002-05-02 Thread Jim Mercer
On Thu, May 02, 2002 at 08:43:04AM -0400, mlw wrote: > Jim Mercer wrote: > > why does it have to be THE BEST ? that is insulting to the other projects > > like MySQL which while "competitors" are also a valid and useful benchmark > > for features, performance and k

Re: [HACKERS] PostgreSQL mission statement?

2002-05-02 Thread Jim Mercer
ts collective toes. postgresql is not THE BEST in all applications, so calling it that is inviting derision and pointless arguments. i'd go with: The PostgreSQL community is committed to creating and maintaining a very reliable, open-source, multi-purpose, standards-based database, and encou

Re: [HACKERS] Re: OpenOffice compile

2001-05-28 Thread Jim Mercer
e if the database engine behind it was a full fledge SQL system like postgres. -- [ Jim Mercer[EMAIL PROTECTED] +1 416 410-5633 ] [ Now with more and longer words for your reading enjoyment. ] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] pg_hba.conf "password" authentication broken?

2001-03-30 Thread Jim Mercer
of not storing clear text passwords in pg_shadow. i implemented this in such a way that it will not impact existing installations. -- [ Jim Mercer [EMAIL PROTECTED] ] [ Reptilian Research -- Longer Life through Colder Blood ] [ aka[EMAIL PROTEC

Re: [HACKERS] Re: Week number

2001-03-14 Thread Jim Mercer
On Wed, Mar 14, 2001 at 07:02:41PM +0100, Peter Eisentraut wrote: > Jim Mercer writes: > > most western calendars that i have seen show "Sun Mon Tue Wed Thu Fri Sat". > > Most *English* calendars you have seen, I suppose. In Germany there is no > such possible

Re: [HACKERS] Re: Week number

2001-03-14 Thread Jim Mercer
t use that index. since almost all cultures have now adapted to a 7 day week and a 365 day year, there shouldn't bee too much confusion. -- [ Jim Mercer [EMAIL PROTECTED] ] [ Reptilian Research -- Longer Life through Colder Blood ] [ aka

Re: [HACKERS] PostgreSQL on multi-CPU systems

2001-03-12 Thread Jim Mercer
e previous single CPU) and things have been quite manageable since. another factor is to get your data on fast/striped disk. -- [ Jim Mercer [EMAIL PROTECTED] ] [ Reptilian Research -- Longer Life through Colder Blood ] [ aka[EMAIL PROTEC

Re: [HACKERS] psql: anyone ever notice?

2000-11-19 Thread Jim Mercer
On Mon, Nov 20, 2000 at 10:47:32AM +0800, xuyifeng wrote: > "?" shouldn't be used as a help screen argument. generally, code doesn't explicitly look for a '?'. rather, the code notes that the character is not mapped to any argument, and prints out a u

Re: [HACKERS] FreeBSD, OpenBSD, NetBSD templates

2000-10-10 Thread Jim Mercer
kages" into /usr/local and netbsd likes to install them in /usr/pkg. the postgresql bundling might be different, but i thought i'd comment. -- [ Jim Mercer [EMAIL PROTECTED] +1 416 410-5633 ] [ Reptilian Research -- Longer Life through Colder Blood

[HACKERS] off-topic: (sorta) freebsd -> oracle, lightweight

2000-10-02 Thread Jim Mercer
i need to query some oracle tables from a freebsd system. is there a lightweight method to do this, or do i have no choice but to put in the Oracle Linux stuff and use their API's? -- [ Jim Mercer [EMAIL PROTECTED] +1 416 410-5633 ] [ Reptilian Res

Re: [HACKERS] Installation layout is still hazardous for shared prefixes

2000-09-27 Thread Jim Mercer
/local/include/pgsql /usr/local/lib /usr/local/libexec /usr/local/pgsql/data or /usr/local/pgsql the last one could also be /home/pgsql or whatever. -- [ Jim Mercer [EMAIL PROTECTED] +1 416 410-5633 ] [ Reptilian Research -- Longer Life through Colder Blood