Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices

Поиск
Список
Период
Сортировка
От rihad
Тема Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices
Дата
Msg-id b3be637b-da6f-4684-6002-38869b7b6632@mail.ru
обсуждение исходный текст
Ответ на Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-general
On 12/22/2017 05:09 PM, Magnus Hagander wrote:
What platform are you on
FreeBSD 10.3-RELEASE-p26 amd64


, how was PostgreSQL installed
pkg install.
Additionally, 10.1 needed for pg_upgrade to run was installed using portmaster -m PREFIX=/10.1, because FreeBSD doesn't allow more than one major version to be installed simultaneously.
After the upgrade took place, 9.6.6 was pkg deleted and 10.1 was pkg installed.


and exactly how was pg_upgrade executed? (or is, since it's reproducible)


sudo -u postgres /10.1/bin/pg_upgrade -j2 --link -r -b /usr/local/bin -B /10.1/bin/ -d /var/db/postgres/data96/ -D /var/db/postgres/data10/

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

Предыдущее
От: Victor
Дата:
Сообщение: Why standby restores some WALs many times from archive?
Следующее
От: rihad
Дата:
Сообщение: Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices