Comment on PostgreSQL 8.4 ReleasedComments−drusenko17y"A dump/restore using pg_dump is required for those wishing to migrate data from any previous release."Don't know much about postgresql, but that sounds fun...−jawngee17yIt's one command to dump and one command to restore:pg_dump -Fc database > database.backupupgrade postgresqlpg_restore -d database database.backup−neilc17yYou should use pg_dumpall rather than pg_dump, typically. Also, remember to use the pg_dump implementation from the new version of PostgreSQL (e.g. 8.4), not the old one (e.g. 8.3).There's also the new (beta) pg_migrator tool which allows upgrades to be performed without a dump + reload. http://pgfoundry.org/projects/pg-migrator/
Comments
"A dump/restore using pg_dump is required for those wishing to migrate data from any previous release."
Don't know much about postgresql, but that sounds fun...
It's one command to dump and one command to restore:
pg_dump -Fc database > database.backup
upgrade postgresql
pg_restore -d database database.backup
You should use pg_dumpall rather than pg_dump, typically. Also, remember to use the pg_dump implementation from the new version of PostgreSQL (e.g. 8.4), not the old one (e.g. 8.3).
There's also the new (beta) pg_migrator tool which allows upgrades to be performed without a dump + reload. http://pgfoundry.org/projects/pg-migrator/