Re: How many postmasters should be running?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: "Stock, Stuart" <Stuart(dot)Stock(at)DrKW(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How many postmasters should be running?
Date: 2006-02-28 06:09:25
Message-ID: 10653.1141106965@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Fuhr <mike(at)fuhr(dot)org> writes:
> On Mon, Feb 27, 2006 at 09:05:51PM -0500, Stock, Stuart wrote:
>> A few minutes ago, we were surprised to find a second postmaster process
>> running on our database machine as a child of the original postmaster.

> Each connection causes the postmaster to fork a new process to
> handle that connection.

Also, all postmaster child processes will properly identify themselves
as long as you are using the appropriate ps options. (Depending on your
OS, the default ps output format might just list them all as "postmaster".)
Try something like "ps auxww | grep postgres" if using Linux.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message denis 2006-02-28 10:52:44 Size comparison between a Composite type and an equivalent Text field
Previous Message Bruno Wolff III 2006-02-28 05:08:31 Re: rotate records