Thanks for ur reply John For information , We have Novell SuSe 11.0 server ON x86_32 and we have installed from source code
Regards sathish On Fri, Mar 6, 2009 at 1:46 AM, John R Pierce <pie...@hogranch.com> wrote: > Sathish Duraiswamy wrote: > >> hai >> >> Recently we migrated our database from 8.2.4 to 8.2.12 , went through >> manuals and followed the below steps >> >> 1.pg_dumpall to take data dump of current database >> 2.stopped database >> 3.moved the pgsql to backup folder >> 4.downloaded 8.2.12 , configured - gmake - gmake install >> 5.recreated cluster directory >> 6.restored the database with datadump >> >> It was like complete re-installation process. >> >> Can anyone explain a alternative method to upgrade a existing database >> > > details vary with platform and how postgresql was installed in the first > place. with a 8.2.x install from the pgdg82 yum repositories on a > rhel/centos/fedora platform > > $ yum upgrade postgresql-server > > would have sufficed. its only necessary to dump/restore when going > between major versions (8.2.x to 8.3.x, for instance), or when making > architecture changes (x86_32 to x86_64, or float timestamp to integer > timestamp). > > > > > -- BSG LeatherLink Pvt Limited, Mail To : sath...@leatherlink.net Website : http://www.leatherlink.net Contact : +91 44 65191757
