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

From: rihad <rihad(at)mail(dot)ru>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices
Date: 2017-12-22 14:42:26
Message-ID: b3be637b-da6f-4684-6002-38869b7b6632@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message rihad 2017-12-22 14:50:44 Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices
Previous Message Victor 2017-12-22 14:01:24 Why standby restores some WALs many times from archive?