Re: [ADMIN] Is it possible to run multiple postmasters?h - Mailing list pgsql-admin

From Karl DeBisschop
Subject Re: [ADMIN] Is it possible to run multiple postmasters?h
Date
Msg-id 200001032108.QAA28365@skillet.infoplease.com
Whole thread Raw
In response to Re: [ADMIN] Is it possible to run multiple postmasters?h  (Lamar Owen <lamar.owen@wgcr.org>)
List 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 by date:

Previous
From: Lamar Owen
Date:
Subject: Re: [ADMIN] Is it possible to run multiple postmasters?h
Next
From: Bohdan KRAVCHUK
Date:
Subject: postgresql on win32