On Fri, Jul 29, 2011 at 03:39, Rohan Kadam <rohanka@cybage.com> 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?