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