Re: Timezone mismatch - Mailing list pgsql-general

From Leonardo M. Ramé
Subject Re: Timezone mismatch
Date
Msg-id 550C5F09.20406@griensu.com
Whole thread Raw
In response to Re: Timezone mismatch  ("Leonardo M. Ramé" <l.rame@griensu.com>)
Responses Re: Timezone mismatch  (Vick Khera <vivek@khera.org>)
List pgsql-general
El 20/03/15 a las 14:11, "Leonardo M. Ramé" escibió:
> El 20/03/15 a las 13:03, Adrian Klaver escibió:
>> 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?
> I don't know if the new time zone is beign used, It just coincede with
> the old local time zone which was -3 hours compared to UTC.
>
> Old time zone was:
>
> Current default time zone: 'America/Argentina/Cordoba'
> Local time is now: Fri Mar 20 06:46:58 ART 2015.
> Universal Time is now: Fri Mar 20 09:46:58 UTC 2015.
>
> New time zone is:
>
> Current default time zone: 'Etc/UTC'
> Local time is now: Fri Mar 20 09:47:48 UTC 2015.
> Universal Time is now: Fri Mar 20 09:47:48 UTC 2015.
>
>

Well, pg_load_conf didn't reoload the timezone config from
postgresql.conf, I had to restart the service to be changed.

Leonardo.



pgsql-general by date:

Previous
From: "Leonardo M. Ramé"
Date:
Subject: Re: Sequences not created, bug in pg_dump?
Next
From: Vick Khera
Date:
Subject: Re: Timezone mismatch