Comment on PostgreSQL 8.4 ReleasedparentComments−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
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/