Re: [GENERAL] roll back to 8.1 for PyQt driver work-around

2008-07-16 Thread Guillaume Lelarge
Scott Frankel a écrit : [...] Here's the full text from the log file: FATAL: syntax error in file "/Library/PostgreSQL8/data/postgresql.conf" line 107, near token "kB" You can't use units in a pre-8.2 config file. FATAL: syntax error in file "/Library/PostgreSQL8/data/postgresql.conf"

Re: [GENERAL] roll back to 8.1 for PyQt driver work-around

2008-07-07 Thread Lennin Caro
sound like you have a postmaster.pid in your PGDATA directory. Rename file postmaster.pid and launch the postgresql again --- On Sat, 7/5/08, Scott Frankel <[EMAIL PROTECTED]> wrote: > From: Scott Frankel <[EMAIL PROTECTED]> > Subject: [GENERAL] roll back to 8.1 for PyQt drive

Re: [GENERAL] roll back to 8.1 for PyQt driver work-around

2008-07-07 Thread Alvaro Herrera
Scott Frankel wrote: > Is there an example postgresql.conf file for pg 8.1 I can review? Mine > appears to be valid only for pg8.3. Sure, it comes with the distribution as postgresql.conf.sample and is installed by initdb. > Adding quotes to the shared_buffers value allows pg8.3 to start > s

Re: [GENERAL] roll back to 8.1 for PyQt driver work-around

2008-07-06 Thread Scott Frankel
Sorry to drag this on further. Though I'm now able to start pg8.3 again (thanks!), I still can't launch pg8.1. Rolling back to 8.1 is my goal in order to work around a driver issue in Qt. Is there an example postgresql.conf file for pg 8.1 I can review? Mine appears to be valid only fo

Re: [GENERAL] roll back to 8.1 for PyQt driver work-around

2008-07-06 Thread Tom Lane
Scott Frankel <[EMAIL PROTECTED]> writes: > When I try to start 8.3, the log file lists a fatal error in the > postgresql.conf file. But there are no obvious errors in that file. > Line 107 reads: "shared_buffers = 1600kB". You need quotes, like shared_buffers = '1600kB' > FATAL: i

Re: [GENERAL] roll back to 8.1 for PyQt driver work-around

2008-07-06 Thread Scott Frankel
Thanks for the tips. I've created separate log files for the two versions of pg, but postmaster still won't start. When I try to start 8.3, the log file lists a fatal error in the postgresql.conf file. But there are no obvious errors in that file. Line 107 reads: "shared_buffers = 1600

Re: [GENERAL] roll back to 8.1 for PyQt driver work-around

2008-07-05 Thread Tom Lane
Scott Frankel <[EMAIL PROTECTED]> writes: > Any suggestions for how best to launch one of two different versions > of pg installed on the same machine? > I have both 8.3 and 8.1 installed on a MacBookPro (OS X 10.5.2). I > stopped the 8.3 postmaster using pg_ctl in order to roll back to 8.1.

[GENERAL] roll back to 8.1 for PyQt driver work-around

2008-07-05 Thread Scott Frankel
Hello, I just signed on the list. Any suggestions for how best to launch one of two different versions of pg installed on the same machine? I have both 8.3 and 8.1 installed on a MacBookPro (OS X 10.5.2). I stopped the 8.3 postmaster using pg_ctl in order to roll back to 8.1. Problem i