On 03/20/2015 08:29 AM, "Leonardo M. Ramé" wrote:
> Hi, I had to change the O.S. timezone and aparently PostgreSql
> continues using the old timezone, how can I force update it's time zone?.
>
> Using PostgreSql 8.4 on Ubuntu Server 12.04.
>
> To update the OS timezone I used sudo dpkg-reconfigure tzdata
Did you reload/restart PostgreSQL after making the change?
What is the setting of timezone in postgresql.conf?
What is set as the timezone on the *client* side? (That's really more
relevant for timestamp_tz data.)
Cheers,
Steve