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/
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
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
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