Re: How many postmasters should be running? - Mailing list pgsql-general

From Tom Lane
Subject Re: How many postmasters should be running?
Date
Msg-id 10653.1141106965@sss.pgh.pa.us
Whole thread Raw
In response to Re: How many postmasters should be running?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Michael Fuhr <mike@fuhr.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

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: triggers, performance Was: Re: rotate records
Next
From: denis@edistar.com
Date:
Subject: Size comparison between a Composite type and an equivalent Text field