Dead Postmasters

From: "Len Morgan" <len-morgan(at)crcom(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Dead Postmasters
Date: 2000-04-22 15:02:06
Message-ID: 002501bfac6b$bb498920$0908a8c0@H233.bstx.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On a couple of my installations, I've noticed that after a few days there
are several "dead" postmasters (i.e., not associated with any running
backend). When I do a ps -ax (RedHat 6.1, Postgresql 6.5.3) I see:

...
[postmaster]
[postmaster]
[postmaster]
[postmaster]
[postmaster]
[postmaster]
...
and several

/usr/bin/postgres ..... lines

The problem is that there are more [postmaster] lines (sometimes 4 or 5
times as many) as there are /usr/bin/postgres lines.

When I do a kill -TERM pid on all of the [postmaster] pids or restart the
postmaster, the system gets much faster. The problem is I also cut of
"live" connections in the process. My question is: Is there any way I can
determine which of the [postmaster] entries are associated with which
/usr/bin/postgres entries?

Thank you!

Len Morgan

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Teddy Turmeaux 2000-04-22 18:27:45 NT, Cygwin and Postmaster failure
Previous Message Sly Golovanov 2000-04-21 15:17:52 windows nt