Postgres Pro
Downloads
Home   >   mailing lists

Thread: Multiple Postmasters (Linux)

Multiple Postmasters (Linux)

From
Date:
hi all, i'm looking at ksysguard and i notice that 4
instances of postmaster are up and running.

is this normal?  i believe the system is automatically
starting them up - b/c i sure did nothing to start
them up.  ;-)

tia...

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Re: Multiple Postmasters (Linux)

From
Tom Lane
Date:
<operationsengineer1@yahoo.com> writes:
> hi all, i'm looking at ksysguard and i notice that 4
> instances of postmaster are up and running.

> is this normal?

It's normal to have one postmaster process with three (or more) children, eg

tgl        603  0.0  0.3  39924  3576 ?        S    Apr26   0:00 postmaster -i -F
tgl        607  0.0  2.5  40060 26012 ?        S    Apr26   0:07 postgres: writer process
tgl        608  0.0  0.0  11936   708 ?        S    Apr26   0:00 postgres: stats buffer process
tgl        609  0.0  0.0  11172   916 ?        S    Apr26   0:00 postgres: stats collector process

If you're using a process-viewing tool that calls them all "postmaster",
get a better tool.  Even plain old "ps" can do better than that.
(The above is "ps auxww" output.)

            regards, tom lane

Re: Multiple Postmasters (Linux)

From
Date:
> <operationsengineer1@yahoo.com> writes:
> > hi all, i'm looking at ksysguard and i notice that
> 4
> > instances of postmaster are up and running.
>
> > is this normal?
>
> It's normal to have one postmaster process with
> three (or more) children, eg
>
> tgl        603  0.0  0.3  39924  3576 ?        S
> Apr26   0:00 postmaster -i -F
> tgl        607  0.0  2.5  40060 26012 ?        S
> Apr26   0:07 postgres: writer process
> tgl        608  0.0  0.0  11936   708 ?        S
> Apr26   0:00 postgres: stats buffer process
> tgl        609  0.0  0.0  11172   916 ?        S
> Apr26   0:00 postgres: stats collector process
>
> If you're using a process-viewing tool that calls
> them all "postmaster",
> get a better tool.  Even plain old "ps" can do
> better than that.
> (The above is "ps auxww" output.)

writer, buffer and collector - it says is in the
command field.  thanks, Tom.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com