On Fri, Jul 29, 2011 at 03:39, Rohan Kadam <rohanka@xxxxxxxxxx> wrote: > Hi All, > > I have currently upgraded our database from postgres 8.2 to 9.0. When trying > to restore my old database dump taken form 8.2 version(using pg_dumpall), I > observed that my timezone is getting changed and getting set to GMT instead > of IST(GMT+5.30) as in the older version of postgres. Perhaps you twiddled with the timezone setting in postgresql.conf and forgot to set it in 9.0's postgresql.conf? Or maybe you are launching postgres under a different environment where TZ is not set to what you expect? -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
