Re: Creating Multiple Instance - Mailing list pgsql-admin

From Tom Lane
Subject Re: Creating Multiple Instance
Date
Msg-id 27890.1323790334@sss.pgh.pa.us
Whole thread Raw
In response to Re: Creating Multiple Instance  (Thomas Markus <t.markus@proventis.net>)
List pgsql-admin
Thomas Markus <t.markus@proventis.net> writes:
> thats possible. Dont forget so set another port in your postgresql.conf

I think actually the reason pg_ctl is complaining is that it doesn't
know how to read postgresql.conf, so it's unaware that the second server
is supposed to be on 5433.  (IIRC, this is fixed in 9.1, but not 9.0.)
It is starting the postmaster correctly, but the -w switch likely
doesn't work as expected.

What I'd suggest is setting the nondefault port number both in
postgresql.conf and on the server command line --- ie, if you're using
pg_ctl, include -o '-p 6433' in its arguments.  That tells pg_ctl what's
going on, and it has another benefit that you'll soon recognize: you'll
be able to tell which postmaster is which in ps listings.  The
postgresql.conf entry is then redundant, but a good thing to have as a
backstop in case you forget the command line switch one day.

            regards, tom lane

pgsql-admin by date:

Previous
From: Thomas Markus
Date:
Subject: Re: Creating Multiple Instance
Next
From: Scott Marlowe
Date:
Subject: Re: Creating Multiple Instance