Search Postgresql Archives

Re: Restart after poweroutage

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux