Thank you. Its a 'yes' on 2 there. I did copy the config file from the 9.1 installation. Thank you for mentioning that, will fix it. Thanks, Karthik On 1/30/14 4:17 PM, "Tom Lane" <tgl@xxxxxxxxxxxxx> wrote: >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
