[ADMIN] Linux: ps output shows multiple instances of PostgreSQL running on the same port

2012-09-17 Thread David Throckmorton
Following a recent database crash, I encountered the following when doing debug: [root@my-db myhost]# ps -ef | grep pgsql postgres 19643 5737 0 09:42 ?00:00:00 /usr/pgsql-9.0/bin/postmaster -p 5432 -D /var/lib/pgsql/9.0/data postgres 19644 5737 0 09:42 ?00:00:00 /usr/pgsql-9.0/

Re: [ADMIN] Windows Services and Postgresql 9.1.3

2012-09-17 Thread Anibal David Acosta
Yes, is a Bug, sometimes in some circumstances pg_ctl go down but postgres server still running. You can easily reproduce. Go to "task manager", kill the process "pg_ctl" (simulate some kind of crash or something else). Now go to services management and try to start again. Start command will thro

Re: [ADMIN] Linux: ps output shows multiple instances of PostgreSQL running on the same port

2012-09-17 Thread Tom Lane
David Throckmorton writes: > Following a recent database crash, I encountered the following when doing > debug: > [root@my-db myhost]# ps -ef | grep pgsql > postgres 19643 5737 0 09:42 ?00:00:00 > /usr/pgsql-9.0/bin/postmaster -p 5432 -D /var/lib/pgsql/9.0/data > postgres 19644 5737 0

Re: [ADMIN] Windows Services and Postgresql 9.1.3

2012-09-17 Thread Anibal David Acosta
BTW, the windows service also can remain in an inconsistent state when the pg_ctl can't stop the postgres server. I think that pg_ctl uses stop "fast" so, if for some reason postgres don't response to stop fast, the service in windows service UI appear as stopping for long time and finally after so