Thread: Dead Postmasters

Dead Postmasters

From
"Len Morgan"
Date:
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


RE: Dead Postmasters

From
Nicolas Huillard
Date:
What I always do is "ps -axf", which will display a "tree" of the processes : you'll know which ones are children of
theothers. 
I don't know if the "dead" postmaster will be shown in a readable location... The problem seems to be somewhere else
(kills/signalsto the postmaster/backends, not correctly disconnected connections, etc) 

Nicolas Huillard
G.H.S
Directeur Technique
Tél : +33 1 43 21 16 66
Fax : +33 1 56 54 02 18
mailto:nhuillard@ghs.fr
http://www.ghs.fr


-----Message d'origine-----
De:    Len Morgan [SMTP:len-morgan@crcom.net]
Date:    samedi 22 avril 2000 17:02
À:    pgsql-admin@postgresql.org
Objet:    [ADMIN] Dead Postmasters

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


how do I set DateStyle = European in postmaster ?

From
Michael Holopainen
Date:
How do I set datestyle to European in server end ?

I tried running postmaster with "-oe" as instructed in one email, but it
resulted as error it did not accept -oe.
for moment I all connections set datestyle = European, but it's not
enough.

please, help!!!!1

-michael (A)

Len Morgan wrote:
>
> 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

--
   --"Would you fly on airplane controlled by MS Windows ?"--
--------------------------------------------------------------------
| Michael Holopainen | Valuraudantie 25 | Tel: +358-(0)9-35093825  |
|                    | 00700 Helsinki   | Fax : +358-(0)9-35093850 |
| Laserle Oy         | Finland          | email: michael@laserle.fi|
--------------------------------------------------------------------

Re: how do I set DateStyle = European in postmaster ?

From
"Anthony E. Greene"
Date:
Michael Holopainen wrote:
>
> How do I set datestyle to European in server end ?
>
> I tried running postmaster with "-oe" as instructed in one email, but it
> resulted as error it did not accept -oe.
> for moment I all connections set datestyle = European, but it's not
> enough.

This can be set in an environment variable in the same script that
starts the postmaster. The name of the varible is in the docs.

--
Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
Linux. The choice of a GNU Generation. <http://www.linux.org/>