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.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
