Re: Timezone mismatch

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