Re: multiple postmasters

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(at)gmx(dot)net http://yi.org/peter-e/