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@circlesfx.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@postgresql.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)





--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general