Hello list,
I need to upgrade my dbs from 743 to 801, current data size is around 5GB, I've tried this way:
./pg_dump -d dbtest -p 9980 | ./psql -d template1 -p 9981
but is too slow, any idea or suggestion to properly upgrade my dbs, I also have blobs stored there.
Try pg_dump followed by pg_restore - both using version 8.0.1. If that's still too slow, the only other option is to dump/restore and then setup replication between the old and new databases to bring your new system up to date. Slony can be used for this.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
