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 200001041537.KAA23091@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
>   Karl DeBisschop wrote:
>   >
>   > >   Yes you can.  Use a postmaster parameter to specify a different port
>   > >   number, and use that port number in your connections.
>   >
>   > What I was missing was that:
>   >
>   >                rm -f /tmp/.s.PGSQL.* > /dev/null
>   >
>   > must be removed from thr redhat init script in order for the sockcts
>   > to work correctly.  The 6.5.1/6.5.3 workarond now seems viable.
>
>   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.

snip snip...

>   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?

For anyone following this topic, testing shows that postmaster invokes
the postgres binary in the expected directory, even without explicitly
setting the path.  I'm not sure if this is always the case, or is an
artifact of the fact that the init script specifies the full path.
I see it as just another illustration of how much thought and effort
has gone into making this a good product.

Karl DeBisschop


pgsql-admin by date:

Previous
From: "Bogdan BALAJ"
Date:
Subject: 6.5.3. installation problems
Next
From: neko@kredit.sth.szif.hu
Date:
Subject: missing headers