Re: migrating data from an old postgres version

Поиск
Список
Период
Сортировка
От Willy-Bas Loos
Тема Re: migrating data from an old postgres version
Дата
Msg-id CAHnozTgbsB_a3daOrsT7e9AkkQPuXO1ZyNax_jk_UrpiudW+Uw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: migrating data from an old postgres version  (Melvin Davidson <melvin6925@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_restore out of memory
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: migrating data from an old postgres version