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

From: David Throckmorton <throckwork(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Linux: ps output shows multiple instances of PostgreSQL running on the same port
Date: 2012-09-18 00:38:48
Message-ID: CAPWMjattJK8QtkmimpT-vx_k5TqdcmrLbs7TUs0Ge+ipfK5PJw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Following a recent database crash, I encountered the following when doing
debug:

[root(at)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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Anibal David Acosta 2012-09-18 01:27:20 Re: Windows Services and Postgresql 9.1.3
Previous Message Bruce Momjian 2012-09-17 21:07:23 Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed