Re: multiple postmasters

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