Re: Restart after poweroutage - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Restart after poweroutage
Date
Msg-id 20060924225500.GC13591@alvh.no-ip.org
Whole thread Raw
In response to Re: Restart after poweroutage  (Jon Lapham <lapham@jandr.org>)
List pgsql-general
Jon Lapham wrote:

> [root@bilbo ~]# ps -A | grep -i post
> 30760 ?        00:00:00 postmaster
> 30762 ?        00:00:00 postmaster
> 30764 ?        00:00:00 postmaster
> 30765 ?        00:00:00 postmaster
> 30766 ?        00:00:00 postmaster
>
> ...is that normal to see 5 of them running?

Yes, because they are not really postmasters; they are child processes,
which can be backends, the logger process, the background writer, etc.
Try with this:

ps u -C postmaster

That should show more detail, and save you the "grep".  Or try something
like this:

$ ps -w -C postmaster -o pid,ppid,args
  PID  PPID COMMAND
15812 15808 /pgsql/install/00orig/bin/postmaster
15814 15812 postgres: writer process
15815 15812 postgres: stats collector process
15830 15812 postgres: alvherre alvherre [local] idle in transaction


Here you can see that there is a postmaster with PID 15812, and several
processes which are children of that one.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: serial column
Next
From: Shane Ambler
Date:
Subject: Re: Connecting to PostgreSQL Server