Re: Index corruption after pg_basebackup - Mailing list pgsql-admin

From Christoph Berg
Subject Re: Index corruption after pg_basebackup
Date
Msg-id 20180828172744.GD24526@msg.df7cb.de
Whole thread Raw
In response to Re: Index corruption after pg_basebackup  (Jorge Torralba <jorge.torralba@gmail.com>)
List pgsql-admin
Re: Jorge Torralba 2018-08-28 <CACut7uTwWhXKHg+Fd3sy6hFnxWn58sLZPOr4frgrg23+NEgq-A@mail.gmail.com>
> Same on both systems.
> 
>  en_US.UTF-8

The problem is that you are moving from one OS (full installation, one
libc vendor, one libc version) to another OS (docker, possibly
different libc vendor, likely different libc version). If any
combination of strings sort differently in these locale incarnations,
you need to REINDEX.

I'm not aware of any specific problem with en_US.UTF-8, but I wouldn't
be surprised if there's differences.

Christoph


pgsql-admin by date:

Previous
From: Evan Bauer
Date:
Subject: Re: More efficient pg_restore method?
Next
From: Ruben Pascual
Date:
Subject: Re: Please remove me from the list