Re: Best way to migrate a 200 GB database from PG 2.7 to 3.6 - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Best way to migrate a 200 GB database from PG 2.7 to 3.6
Date
Msg-id 552EBA5E.8030906@commandprompt.com
Whole thread Raw
In response to Re: Best way to migrate a 200 GB database from PG 2.7 to 3.6  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
On 04/15/2015 12:14 PM, Andy Colson wrote:

> Postgresql is on version 9.  What do you mean version 2 or 3?

He probably means 9.2.7 to 9.3.6. Remember to a lot of people 9 means 9.

That said, pg_upgrade is the way to do this as long as you can have an
outage.

JD


--
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.


pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: Best way to migrate a 200 GB database from PG 2.7 to 3.6
Next
From: Ravi Kiran
Date:
Subject: Error in the connection to the server