Re: Best way to migrate a 200 GB database from PG 2.7 to 3.6

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Filip Lyncker
Sent: Wednesday, April 15, 2015 3:03 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Best way to migrate a 200 GB database from PG 2.7 to 3.6

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

---

PG 2.7 to 3.6???

Anyway, did you look at pg_upgrade?

Regards,
Igor Neyman