On 4/15/2015 2:03 PM, Filip Lyncker wrote:
Dear List,
I need to migrate my database from a 2.x to 3.x. Usually Im using
pg_basebackup , but this is not possible with different versions.
Pg_dump seems to be an option but it is slow like hell and I dont want
to stay offline all the time.
Is there another possibility to migrate a database with 200 GB ?
Thanks a lot,
cheers
Filip
Postgresql is on version 9. What do you mean version 2 or 3?
Maybe use replication?
http://www.slony.info/documentation/1.2/versionupgrade.html
Or something similar?
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general