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 thanks in advance regards sathish On Fri, Mar 6, 2009 at 12:28 AM, John R Pierce <pie...@hogranch.com> wrote: > Heine Ferreira wrote: > >> Hi >> >> When you install a newer version of Postgres how do you upgrade your >> database to the new format? >> Apparantly you can't just backup the old database and restore it on the >> new software. >> How do you do this on Windows? >> > > you pg_dump >dumpfile.sql the old one, psql -f dumpfile.sql to the new. > > Typically, you only need to do this between major upgrades, like 8.2.x to > 8.3.y ... 8.3.x to 8.3.y doesn't require a dump/restore unless the > release notes state otherwise (this has only happened a few times, I think > there was a 8.0.1->8.0.N that required it due to a minor change required by > a bugfix) > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- BSG LeatherLink Pvt Limited, Mail To : sath...@leatherlink.net Website : http://www.leatherlink.net Contact : +91 44 65191757
