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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
