Thanks Jignesh for the reply. On Fri, Jan 16, 2009 at 11:22 AM, Jignesh K. Shah <J.K.Shah at sun.com> wrote:
> Hi Poorni, > > I hope you are aware of how to upgrade from one major version to another > with PostgreSQL. > > Upgrade of PostgreSQL 8.2 (32-bit) to PostgreSQL 8.3 (64-bit) is > non-trivial > > The best safe way is to dump data/schema from 8.2 (32-bit) and reload the > schema/data into PostgreSQL 8.3 (64-bit). > > There is some support for upgrade in place using pg_upgrade but it is > generally for same 32-bit to 32-bit upgrades and that too very specific > verions and I am not sure it works for 32-bit to 64-bit upgrades (maybe > Zdenek can comment more on this or confirm) > > > Hope this helps > > Regards, > Jignesh > > > > On 01/16/09 10:58, Poorni Anneshwari wrote: > >> Hi .. DOes anybody know what are the differences between postgres vs 8.2 >> of 32 bits and postgres version 8.3of 64 bits? I am upgrading my system and >> so will like to know the difference. Any help would be appreciated. Thanks! >> >> > -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mail.opensolaris.org/pipermail/databases-discuss/attachments/20090116/84f72772/attachment.html>
