Re: migrating data from an old postgres version - Mailing list pgsql-general

From Willy-Bas Loos
Subject Re: migrating data from an old postgres version
Date
Msg-id CAHnozTgbsB_a3daOrsT7e9AkkQPuXO1ZyNax_jk_UrpiudW+Uw@mail.gmail.com
Whole thread Raw
In response to Re: migrating data from an old postgres version  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general

On Fri, Jul 15, 2016 at 4:13 PM, Melvin Davidson <melvin6925@gmail.com> wrote:
If you dump with -F p (plain is default) then the version does not matter.

That is the recommended method for upgrading from older versions.
https://www.postgresql.org/docs/9.4/static/upgrading.html


Problem is that we use postgis and the versions differ between the postgres installations.
So we have to upgrade postgis in the process.
We use a perl script for that, which gets a list of the objects in the backup and then filters what will be restored. But for that it needs a custom dump, hence Paul Ramsey's advice.

--
Willy-Bas Loos

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_restore out of memory
Next
From: Adrian Klaver
Date:
Subject: Re: migrating data from an old postgres version