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 <pierce@xxxxxxxxxxxx> wrote:
you pg_dump >dumpfile.sql the old one, psql -f dumpfile.sql to the new.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?
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
BSG LeatherLink Pvt Limited,
Mail To : sathish@xxxxxxxxxxxxxxx
Website : http://www.leatherlink.net
Contact : +91 44 65191757
