From: | Michael Holopainen <michael(at)laserle(dot)fi> |
---|---|
To: | |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | how do I set DateStyle = European in postmaster ? |
Date: | 2000-07-05 06:45:49 |
Message-ID: | 3962D99D.B0F12B0A@laserle.fi |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)laserle(dot)fi|
--------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Yadira M. Rodriguez | 2000-07-05 14:14:29 | No such function 'to_char' with the specified attributes |
Previous Message | Paulo Henrique Baptista de Oliveira | 2000-07-05 03:10:07 | Redundant |