Re: Upgrade data

Scott Marlowe wrote:
> 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."