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@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
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)
