Re: Restart after poweroutage

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