Regarding Postgres Upgrade

[Rohan Kadam <rohanka@xxxxxxxxxx>]

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.

I require your help for resolving the same. Is there anything I am missing?

Thanks in advance.

"Legal Disclaimer: This electronic message and all contents contain information from Cybage Software Private Limited which may be privileged, confidential, or otherwise protected from disclosure. The information is intended to be for the addressee(s) only. If you are not an addressee, any disclosure, copy, distribution, or use of the contents of this message is strictly prohibited. If you have received this electronic message in error please notify the sender by reply e-mail to and destroy the original message and all copies. Cybage has taken every reasonable precaution to minimize the risk of malicious content in the mail, but is not liable for any damage you may sustain as a result of any malicious content in this e-mail. You should carry out your own malicious content checks before opening the e-mail or attachment." www.cybage.com