Re: Upgrade data

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.

--
   Richard Huxton
   Archonet Ltd