Re: Restart after poweroutage

Jon Lapham wrote:
[...]
>
> I do not *think* I am running 2 postmasters.
>
> [root@bilbo ~]# service postgresql stop
> Stopping postgresql service:                               [  OK  ]
> [root@bilbo ~]# ps -A | grep -i post
> [root@bilbo ~]# service postgresql start
> Starting postgresql service:                               [  OK  ]
> [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 it is, and even more, depending on the number of clients currently
connected...


akar# ps ax | grep postma
18626  ??  Is     0:36.48 /usr/local/bin/postmaster (postgres)
18627  ??  S      0:19.54 postmaster: logger process    (postgres)
18629  ??  S      3:50.58 postmaster: writer process    (postgres)
18630  ??  S      1:51.48 postmaster: stats buffer process    (postgres)
18632  ??  I      7:17.39 postmaster: stats collector process    (postgres)


18683  ??  I      0:47.33 postmaster: ipfwpglogger ipfw
192.168.0.1(59189) idle (postgres)
18685  ??  I      0:00.94 postmaster: ipfwpglogger ipfw
192.168.0.1(54261) idle (postgres)
49188  ??  I      0:04.37 postmaster: snortpguser ipfw
192.168.0.1(56173) idle (postgres)
80722  ??  I      0:00.11 postmaster: pgsql template1
192.168.0.250(49421) idle (postgres)
80723  ??  I      0:00.75 postmaster: pgsql ipfw 192.168.0.250(50624)
idle (postgres)
80724  ??  I      0:01.67 postmaster: pgsql ipfw 192.168.0.250(60737)
idle (postgres)
81216  ??  I      0:00.48 postmaster: perl ipfw [local] idle (postgres)
81253  ??  I      0:01.43 postmaster: webpguser ipfw [local] idle (postgres)

HTH,
--
MaXX