Re: multiple postmasters - Mailing list pgsql-admin

From Ross J. Reedstrom
Subject Re: multiple postmasters
Date
Msg-id 20010110140629.B14587@rice.edu
Whole thread Raw
In response to Re: multiple postmasters  (David Mehringer <dmehring@astro.uiuc.edu>)
Responses Re: multiple postmasters  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
On Wed, Jan 10, 2001 at 01:34:34PM -0600, David Mehringer wrote:
> On Wed, 10 Jan 2001, Peter Eisentraut wrote:
> >
> > > We're running postgresql 7.0.2 on solaris 5.7.  The admin docs say that only
> > > one postmaster process should be running.
> >
> > The docs are wrong in that case.  Can you name chapter and section so we
> > can fix it?
> >
> Hi,
> Thanks for the quick response.  I was looking around the postgresql website
> for info regarding this and came across a sentence about it.  Unfortunately,
> I can not find it again.  Will let you know if I come across it in the
> future.  The sentence I read may actually have meant that *the
> administrator* should not start more than one postmaster process, in which
> case I misinterpreted it.
>

Dave,
Another aspect of this problem is that, on most platforms, the children
of postmaster that are forked for each connection rename themselves
to 'postgres'. The code for this was changed, recently, due to some
potential speed, security, or portability problems (I'm not sure off
the top of my head). You may be on a platform that no longer renames,
so you'll end up with multiple processes names 'postmaster', and have
to track down which is which they way Peter pointed out.

Ross


pgsql-admin by date:

Previous
From: David Mehringer
Date:
Subject: Re: multiple postmasters
Next
From: Peter Eisentraut
Date:
Subject: Re: multiple postmasters