Upgrade data

From: josue <josue(at)lamundial(dot)hn>
To: PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Upgrade data
Date: 2005-03-29 21:39:28
Message-ID: 4249CB10.7000504@lamundial.hn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks in advance,

--
Sinceramente,
Josué Maldonado.

... "La amistad, como todo verdadero encuentro, es dar y recibir." P.
Guisar.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Caleb Simonyi-Gindele 2005-03-29 22:06:57 Re: do I need replication or something else?
Previous Message John Burger 2005-03-29 21:00:37 Re: do I need replication or something else?