On 01/30/2014 03:17 PM, Anand Kumar, Karthik wrote:
Hi,
We just upgraded our postgres database from 9.1 to 9.3. And noticed that
the timezone changed from PST to GMT.
Is that known behavior? Has anyone else run into it, or am I just
missing something?
Well there where changes in the way timezones are set in 9.2.
http://www.postgresql.org/docs/9.3/interactive/release-9-2.html
Identify the server time zone during initdb, and set postgresql.conf
entries timezone and log_timezone accordingly (Tom Lane)
This avoids expensive time zone probes during server start.
I've verified the server's timezone is right, and nothing in the
postgres user's profile is changing the timezone at startup. The
postgres start up scripts aren't setting the timezone either, from what
I can see.
What is the server timezone?
What is the timezone value in postgresql.conf?
Where are you seeing the change?
Thanks,
Karthik
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
