Re: database migration question between different ubuntus and different postgresql server versions

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: database migration question between different ubuntus and different postgresql server versions
Date: 2015-04-16 21:51:08
Message-ID: 20150416215108.GF3477@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Apr 16, 2015 at 02:38:56PM -0700, Adrian Klaver wrote:
> Well it is an upgrade from one major version to another, so you have the
> following options using Postgres core utilities:

And, if you don't want to use core utilities, you can use one of the
trigger-based replication systems to move all the data from one to the
other. Depending on your uptime requirements and the size of the
database, this approach can either be a life saver or a total waste of
time and will to live. More often the latter, please be aware.

A

--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2015-04-16 22:05:47 Re: Where does vacuum FULL write temp-files?
Previous Message Andomar 2015-04-16 21:39:20 Re: Waiting on ExclusiveLock on extension