Re: Timezone mismatch

El 20/03/15 a las 12:38, Steve Crawford escibió:
> 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
>
>
>
Hi Steve, I did a "select pg_reload_conf();" from psql. Is this enough?.

In postgresql.conf I have timezone and timezone_abbreviations commented,
as default.

 From client side I never set any timezone related parameter.

Leonardo.