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

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Filip Lyncker <lyncker(at)lyth(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: Best way to migrate a 200 GB database from PG 2.7 to 3.6
Date: 2015-04-15 19:07:30
Message-ID: 552EB6F2.2050302@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 15/04/2015 20:03, 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 ?

Those version numbers aren't correct... current PG major versions run
from 9.0 to 9.4. I don't think there was ever any version less than 6
(though I could be wrong).

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2015-04-15 19:10:52 Re: Best way to migrate a 200 GB database from PG 2.7 to 3.6
Previous Message Filip Lyncker 2015-04-15 19:03:19 Best way to migrate a 200 GB database from PG 2.7 to 3.6