Re: [ADMIN] Is it possible to run multiple postmasters?h

Поиск
Список
Период
Сортировка
От Karl DeBisschop
Тема Re: [ADMIN] Is it possible to run multiple postmasters?h
Дата
Msg-id 200001032108.QAA28365@skillet.infoplease.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Is it possible to run multiple postmasters?h  (Lamar Owen <lamar.owen@wgcr.org>)
Список pgsql-admin
> As a note, the RedHat init scripts shipped with the RPM's are not
> intended for 'special' applications such as this one -- however, I am
> working on a more generalized setup in the RPM's where multiple
> postmasters, etc, could be started.

Yup.  I had to do slightly more than trivial mods to get the init
script to work for the second postmaster.

> That rm -f is for cleanup purposes -- assuming a single postmaster, it
> works correctly.  For multiple postmasters, it would need to be changed
> (assuming PGPORT= postmaster listen port):
> rm -f /tmp/.s.PGSQL.$(PGPORT) > /dev/null

Once I saw it, it's purpose was relatively clear - One big plus about the
redhat scripts is that their logic is pretty understandable.

> This way, the init script allows a postmaster to startup even if the
> restart is due to a system crash that would leave the .s.PGSQL.* files
> laying around.

Yup.

> I'm assuming that you have all the paths set correctly for each copy of
> the postmaster, so that the 6.5.1 postmaster isn't trying to start a
> 6.5.3 backend, right?

Hmmm.  Very good point.  Thanks.

Karl DeBisschop

В списке pgsql-admin по дате отправления:

Предыдущее
От: Lamar Owen
Дата:
Сообщение: Re: [ADMIN] Is it possible to run multiple postmasters?h
Следующее
От: Bohdan KRAVCHUK
Дата:
Сообщение: postgresql on win32