| From: | Alex Hunsaker <badalex(at)gmail(dot)com> |
|---|---|
| To: | Rohan Kadam <rohanka(at)cybage(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Regarding Postgres Upgrade |
| Date: | 2011-07-29 10:23:37 |
| Message-ID: | CAFaPBrTXi8ptVXNjXufjYx5KJHKkkE6jtjivThord6_bcLALiQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, Jul 29, 2011 at 03:39, Rohan Kadam <rohanka(at)cybage(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Willy-Bas Loos | 2011-07-29 13:26:49 | how much work_mem is my server using |
| Previous Message | Rohan Kadam | 2011-07-29 09:42:47 | Regarding Postgres Upgrade |