| From: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
|---|---|
| To: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: migrating data from an old postgres version |
| Date: | 2016-07-15 14:18:58 |
| Message-ID: | CAHnozTgbsB_a3daOrsT7e9AkkQPuXO1ZyNax_jk_UrpiudW+Uw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jul 15, 2016 at 4:13 PM, Melvin Davidson <melvin6925(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2016-07-15 14:19:32 | Re: migrating data from an old postgres version |
| Previous Message | Adrian Klaver | 2016-07-15 14:16:33 | Re: pg_restore out of memory |