Re: database migration question between different ubuntus and different postgresql server versions - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: database migration question between different ubuntus and different postgresql server versions
Date
Msg-id 20150416215108.GF3477@crankycanuck.ca
Whole thread Raw
In response to Re: database migration question between different ubuntus and different postgresql server versions  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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@crankycanuck.ca


pgsql-general by date:

Previous
From: Andomar
Date:
Subject: Re: Waiting on ExclusiveLock on extension
Next
From: Guillaume Lelarge
Date:
Subject: Re: Where does vacuum FULL write temp-files?