Bruce Momjian wrote:
> Christopher Kings-Lynne wrote:
> > > No, the Australians complained about the compile-time flag, and were
> > > very happy when it became a GUC parameter. I only mentioned to say that
> > > conflicting timezone issues are obviously a problem for some, and we did
> > > resolve it with GUC.
> >
> > OK, I've just realised I haven't set our server to use Australian
> > timezones - how do you do this with GUC? Can I put something in
> > postgresql.conf? I don't want to issue an extra query for every connection
> > to set it. I had a look at the timezone section of the manual and didn't
> > see anything about it...?
>
> Hmm, let's see... Hmm, I don't see anything. Maybe it isn't there. Oh,
> there it is:
>
> #australian_timezones = false
>
> Is that it? I think so. I am not 100% sure. Yes, I think that is it.
>
> :-)
>
> Smiley's all around. :-)
I am sorry Christopher. I just couldn't help myself. Yes, it is
australian_timezones in postgresql.conf. No need to set it for every
client. Make sure you remove the # comment character and set it to
true.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026