Re: Help, Australian Time Problem - Mailing list pgsql-general

From Tom Lane
Subject Re: Help, Australian Time Problem
Date
Msg-id 28262.1069778507@sss.pgh.pa.us
Whole thread Raw
In response to Help, Australian Time Problem  (Dean Grubb <dean@atrium-online.com.au>)
Responses Re: Help, Australian Time Problem  (Dean Grubb <dean@atrium-online.com.au>)
List pgsql-general
Dean Grubb <dean@atrium-online.com.au> writes:
> I've set TimeZone to local

That will certainly not work - TimeZone needs to be set to a string that
your system will recognize as a specific time zone.  (Unfortunately, a
bogus setting gets treated as "UTC" on most platforms, which in fact is
what you're seeing.)

I dunno what the standard BSD names are for the Aussie timezones; can
anyone help?  On HPUX you'd use something like 'EST-10EDT' but I'm not
sure about BSD...

            regards, tom lane

pgsql-general by date:

Previous
From: "Marc A. Leith"
Date:
Subject: Re: Lock strategies!
Next
From: Paul Ramsey
Date:
Subject: Re: [OT... But couldn't resist!] Master/Slave