5 ms·

"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..

• jawngee 17y ago
  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
  • neilc 17y ago
    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/ http://pgfoundry.org/projects/pg-migrator/