Re: Upgrade data

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.