Re: Creating Multiple Instance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Creating Multiple Instance
Дата
Msg-id 27890.1323790334@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Creating Multiple Instance  (Thomas Markus <t.markus@proventis.net>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Markus
Дата:
Сообщение: Re: Creating Multiple Instance
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Creating Multiple Instance