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

From: Filip Lyncker <lyncker(at)lyth(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Best way to migrate a 200 GB database from PG 2.7 to 3.6
Date: 2015-04-15 19:03:19
Message-ID: 552EB5F7.3040706@lyth.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2015-04-15 19:07:30 Re: Best way to migrate a 200 GB database from PG 2.7 to 3.6
Previous Message Pawel Veselov 2015-04-15 18:19:11 Re: Help with slow table update