Re: Index corruption after pg_basebackup

From: Christoph Berg <myon(at)debian(dot)org>
To: Jorge Torralba <jorge(dot)torralba(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Index corruption after pg_basebackup
Date: 2018-08-28 17:27:44
Message-ID: 20180828172744.GD24526@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Re: Jorge Torralba 2018-08-28 <CACut7uTwWhXKHg+Fd3sy6hFnxWn58sLZPOr4frgrg23+NEgq-A(at)mail(dot)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ruben Pascual 2018-08-28 18:32:10 Re: Please remove me from the list
Previous Message Evan Bauer 2018-08-28 17:13:08 Re: More efficient pg_restore method?