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

From Christoph Berg
Subject Re: Index corruption after pg_basebackup
Date
Msg-id 20180828164239.GC24526@msg.df7cb.de
Whole thread Raw
In response to Index corruption after pg_basebackup  (Jorge Torralba <jorge.torralba@gmail.com>)
Responses Re: Index corruption after pg_basebackup  (Jorge Torralba <jorge.torralba@gmail.com>)
List pgsql-admin
Re: Jorge Torralba 2018-08-28 <CACut7uRx72_R-nGOdOdnTSYCGGdKZ_TfsSghCb35+deF3s-4nw@mail.gmail.com>
> ERROR:  failed to re-find parent key in index "myindex" for deletion target
> page 851753

Which data type is that, and which LC_COLLATE setting is used?

If it's text (or similar), there's a known incompatibility with
de_DE.UTF-8 in different glibc versions. Possibly other locales and
libcs are affected as well.

Christoph


pgsql-admin by date:

Previous
From: Jorge Torralba
Date:
Subject: Index corruption after pg_basebackup
Next
From: Ron
Date:
Subject: More efficient pg_restore method?