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