Re: multiple postmasters - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: multiple postmasters
Date
Msg-id Pine.LNX.4.30.0101101954390.22819-100000@peter.localdomain
Whole thread Raw
In response to multiple postmasters  (David Mehringer <dmehring@astro.uiuc.edu>)
Responses Re: multiple postmasters
List pgsql-admin
David Mehringer writes:

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

> However, our "master" postmaster
> process (PID=560 below) appears to have spawned off a couple of other
> postmaster processes:
>
>      UID   PID  PPID  C    STIME TTY      TIME CMD
>  bimaadm   560     1  0   Nov 27 ?        1:24 /appl/bima/pgsql/bin/postmaster -S -i
>  bimaadm 10237   560  0 17:16:53 ?        0:04 /appl/bima/pgsql/bin/postmaster -S -i
>  bimaadm 10240   560  0 17:17:00 ?        0:06 /appl/bima/pgsql/bin/postmaster -S -i
>
> Is this normal?  If not, what could be the cause of this?

Notice how the PPID (parent pid) of the second and third process refers to
the first one.  The first process is the "postmaster" you started (by init
apparently), the second and third ones got forked to handle connections.
(one process per connection)

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


pgsql-admin by date:

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