Adrian Klaver <adrian.klaver@xxxxxxxxx> writes: > On 01/30/2014 03:17 PM, Anand Kumar, Karthik wrote: >> 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. Yeah. Likely theories include 1. You ran initdb in a different environment than you normally start the server in. 2. You blindly copied the 9.1 postgresql.conf into the 9.3 installation, overwriting what initdb had done. If there's no uncommented timezone setting in the .conf file, 9.3 will fall back to GMT, IIRC. But that approach to configuration has a lot of pitfalls besides this one. In any case the fix is to set the zone you want in postgresql.conf. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
