how do I set DateStyle = European in postmaster ?
От | Michael Holopainen |
---|---|
Тема | how do I set DateStyle = European in postmaster ? |
Дата | |
Msg-id | 3962D99D.B0F12B0A@laserle.fi обсуждение исходный текст |
Ответ на | Dead Postmasters ("Len Morgan" <len-morgan@crcom.net>) |
Список | pgsql-admin |
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| --------------------------------------------------------------------
В списке pgsql-admin по дате отправления: