On Wed, Nov 09, 2005 at 02:24:28PM -0200, Giovanni M. wrote: > I'm situated in Brazil and recently daylights savings/summer time kicked in > and clocks were set one hour ahead. Now on my windows box the system clock > automatically adjusted to the correct time. But performing the following > query on the postgresql-8.0 server i get this result: > select now() > ---------------------- > 2005-11-09 13:22:27.625-03 > while the actual current time is 14:22h, and being reported correctly in > the windows system clock > I have tried finding some information in the documentation and came across > locale settings in the postgresql.conf configuration file but Im not sure if > this is the correct place to be looking. Should i set the timezone property > in postgresql.conf to something other than unknown?
Do you see the correct time if you do the following?
SET timezone TO 'Brazil/East'; SELECT now();
If so then change the timezone line in postgresql.conf to:
