Re: Restart after poweroutage

Jon Lapham wrote:
[...]
>
> I do not *think* I am running 2 postmasters.
>
> [root(at)bilbo ~]# service postgresql stop
> Stopping postgresql service: [ OK ]
> [root(at)bilbo ~]# ps -A | grep -i post
> [root(at)bilbo ~]# service postgresql start
> Starting postgresql service: [ OK ]
> [root(at)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