Re: Pg_upgrade and collation - Mailing list pgsql-docs

From Bruce Momjian
Subject Re: Pg_upgrade and collation
Date
Msg-id 20160617220159.GD19359@momjian.us
Whole thread Raw
In response to Re: Pg_upgrade and collation  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: Pg_upgrade and collation
List pgsql-docs
On Fri, Jun 17, 2016 at 05:51:54PM -0400, Alvaro Herrera wrote:
> Bruce Momjian wrote:
> > The attached patch documents that pg_upgrade requires old/new servers to
> > use compatibile collation library versions as well.
>
> I think this is way too thin to be helpful:

Well, this is a much larger issue than pg_upgrade, e.g. moving a data
directory from one cluster to another with a different collation library
version could also cause problems, and I don't know that is documented
at all.

If we want to go larger, we have to do this in a more central location.

>
> > --- 61,68 ----
> >     checking for compatible compile-time settings, including 32/64-bit
> >     binaries.  It is important that
> >     any external modules are also binary compatible, though this cannot
> > !   be checked by <application>pg_upgrade</>.  Compatible collation
> > !   library versions must also be used.
> >    </para>
>
> I think it would be useful to indicate what to do if they are not
> compatible.

The indexes don't work reliably.  We don't document what happens if
shared objects don't match either, but again, if we want to clarify
this, we need to do it more centrally.  Ideas?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+                     Ancient Roman grave inscription +


pgsql-docs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Pg_upgrade and collation
Next
From: Bruce Momjian
Date:
Subject: Re: pg_rewind option clarification