Search Postgresql Archives

Re: Timezone mismatch

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux