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