Re: Creating Multiple Instance

Thomas Markus <t(dot)markus(at)proventis(dot)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