Re: Restart after poweroutage

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Restart after poweroutage
Дата
Msg-id 20060924225500.GC13591@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Restart after poweroutage  (Jon Lapham <lapham@jandr.org>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: serial column
Следующее
От: Shane Ambler
Дата:
Сообщение: Re: Connecting to PostgreSQL Server