Re: Timezone mismatch

On 03/20/2015 08:43 AM, "Leonardo M. Ramé" wrote:
> 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.

I am not sure what the exact issue is?

How are you determining that the new time zone is not being used?

What was the old time zone, what is the new one?

>
> Leonardo.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com