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