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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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