Re: pg_upgrade 9.6 to 12 without 9.6 binaries

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: pg_upgrade 9.6 to 12 without 9.6 binaries
Дата
Msg-id ba6bc784-c425-9747-9fb8-b2f408a254d7@aklaver.com
обсуждение исходный текст
Ответ на pg_upgrade 9.6 to 12 without 9.6 binaries  ("Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>)
Ответы Re: pg_upgrade 9.6 to 12 without 9.6 binaries  (Jerry Sievers <gsievers19@comcast.net>)
Список pgsql-general
On 3/13/20 6:47 AM, Zwettler Markus (OIZ) wrote:
> We are running Postgres 9.6 on server A.
> 
> We want to upgrade it to Postgres 12 on server B.
> 
> pg_upgrade requires the old (-b) and new (-B) binary set on the same server.
> 
> We don't want to install both binary sets on the same server as we had 
> some library conflicts in the past.
> 
> Is there still a way to use pg_upgrade without the old (-b) binary set 
> (I am aware of pg_dump/pg_restore)?

No. As I understand it pg_upgrade needs to see the state of old instance 
to recreate that state on the new instance.

> 
> Markus
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Stefan Blanke
Дата:
Сообщение: Re: ERROR: invalid memory alloc request size 1073741824
Следующее
От: Ron
Дата:
Сообщение: Re: vacuum full doubled database size