RE: how do I set DateStyle = European in postmaster ? - Mailing list pgsql-admin

From Anthony E. Greene
Subject RE: how do I set DateStyle = European in postmaster ?
Date
Msg-id 3.0.5.32.20000707171850.007c4e60@fmol.5sigcmd.army.mil
Whole thread Raw
In response to RE: how do I set DateStyle = European in postmaster ?  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List pgsql-admin
At 13:30 2000-07-07 +0100, Gary Stainburn wrote:
>-----Original Message-----
>From:    Michael Holopainen [SMTP:michael@laserle.fi]
>Sent:    Friday, July 07, 2000 12:22 PM
>To:    Gary Stainburn
>Subject:    Re: [ADMIN] how do I set DateStyle = European in postmaster ?
>
>>OK, here is the script (the whole postgres script)
[snip]

I set the DateStyle in /etc/profile, which works for ISO, but not for
European. That may have to do with locale settings in the RPM I have
installed.

It's a lot simpler if it works for you. Just put this in /etc/profile:

  export PGDATESTYLE='European'

Since the postmaster script uses "su -l" it gets the environment, including
things setup in /etc/profile (assuming the postgres user's shell is bash).


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

pgsql-admin by date:

Previous
From: Gary Stainburn
Date:
Subject: RE: how do I set DateStyle = European in postmaster ?
Next
From: "Peter Galbavy"
Date:
Subject: Re: Firewall setup