Skip site navigation (1) Skip section navigation (2)

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

From: Karl DeBisschop <kdebisschop(at)range(dot)infoplease(dot)com>
To: lamar(dot)owen(at)wgcr(dot)org
Cc: pgsql-admin(at)postgreSQL(dot)org
Subject: Re: [ADMIN] Is it possible to run multiple postmasters?h
Date: 2000-01-03 21:08:00
Message-ID: 200001032108.QAA28365@skillet.infoplease.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-admin by date

Next:From: Bohdan KRAVCHUKDate: 2000-01-03 21:59:31
Subject: postgresql on win32
Previous:From: Lamar OwenDate: 2000-01-03 20:58:36
Subject: Re: [ADMIN] Is it possible to run multiple postmasters?h

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group