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:
timezone = Brazil/East
Then reload or restart the database.
--
Michael Fuhr
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
