On Wed, 2005-03-30 at 01:33, Richard Huxton wrote:
josue wrote:
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.
Actually, if you're gonna use slony, the only thing you need to dump and restore to the target database is the schema, slony will move all the data for you.
Thanks for the anwser, currently I'm using pg_dump to create a tar file and I'll restore it with pg_restore
-- Sinceramente, Josué Maldonado.
... "Cuando era joven leía casi siempre para aprender; hoy, a veces, leo para olvidar."
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
