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

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Andy Colson <andy(at)squeakycode(dot)net>, 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:22:06
Message-ID: 552EBA5E.8030906@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Kiran 2015-04-15 20:35:34 Error in the connection to the server
Previous Message Andy Colson 2015-04-15 19:14:46 Re: Best way to migrate a 200 GB database from PG 2.7 to 3.6