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/bin/postmaster -p 5432 -D /var/lib/pgsql/9.0/data postgres 19657 5737 0 09:42 ? 00:00:00 /usr/pgsql-9.0/bin/postmaster -p 5432 -D /var/lib/pgsql/9.0/data postgres 19658 5737 0 09:42 ? 00:00:00 /usr/pgsql-9.0/bin/postmaster -p 5432 -D /var/lib/pgsql/9.0/data pgstartup.log doesn't indicate anything about multiple instances starting, and indicates that PID 5737 was the initial PID for the instance: # cat pgstartup.log 2012-09-07 08:01:33 MDT [5737] Not to mention the fact that a whole series of things would have to go wrong to have PostgreSQL listening on the same port and different PIDs - so many I can't even imagine it. So I'm wondering if this has even been seen before (and/or whether I'm just chasing windmills here). Environment: OS: CentOS 5 - 2.6.18-194.32.1.el5 #1 SMP Wed Jan 5 17:52:25 EST 2011 x86_64 x86_64 x86_64 GNU/Linux PostgreSQL Version: psql (9.0.4) Thanks.
