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

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 = 1600kB".

I've also tried grep'ing for port 5432, but it all looks clear. eg:

tiento:~ root# lsof -Pni | grep :5432 --> yields nothing

tiento[yfilm]% ps uxwa | grep postgres
postgres 46547 0.0 0.1 604328 1204 s006 S+ 11:09PM 0:00.10 -tcsh
root 46546 0.0 0.1 75536 1064 s006 S 11:09PM 0:00.02 su - postgres
frankel 46720 0.0 0.0 599780 392 s003 R+ 8:58AM 0:00.00 grep postgres

Here's the full text from the log file:

FATAL: syntax error in file "/Library/PostgreSQL8/data/
postgresql.conf" line 107, near token "kB"
FATAL: syntax error in file "/Library/PostgreSQL8/data/
postgresql.conf" line 107, near token "kB"
LOG: could not bind IPv6 socket: Address already in use
HINT: Is another postmaster already running on port 5432? If not,
wait a few seconds and retry.
FATAL: incorrect checksum in control file
LOG: could not bind IPv6 socket: Address already in use
HINT: Is another postmaster already running on port 5432? If not,
wait a few seconds and retry.
FATAL: incorrect checksum in control file
LOG: could not bind IPv6 socket: Address already in use
HINT: Is another postmaster already running on port 5432? If not,
wait a few seconds and retry.
FATAL: incorrect checksum in control file
LOG: could not bind IPv6 socket: Address already in use
HINT: Is another postmaster already running on port 5432? If not,
wait a few seconds and retry.

Thanks again!
Scott

On Jul 5, 2008, at 10:43 PM, Tom Lane wrote:

> Scott Frankel <frankel(at)circlesfx(dot)com> 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.
>> Problem is, now I can't seem to start the server using either
>> version.
>
> It looks like you're trying to use the same data directory for both
> versions, which won't work. They're not compatible on-disk.
>
>> When I launch 8.1 with pg_ctl, it yields a "postmaster starting"
>> message; but then a status check shows that the server is not
>> running. Issuing the same commands for 8.3, I get similar results.
>
> Looking into the postmaster log file (your -l specification) might
> yield some insight. pg_ctl itself doesn't really know why the
> postmaster failed to start.
>
> regards, tom lane
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Scott Frankel
President/VFX Supervisor
Circle-S Studios
510-339-7477 (o)
510-332-2990 (c)