Received: from malur.postgresql.org ([2a02:16a8:dc51::56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1fuhmZ-0003Pm-5c
	for pgsql-admin@arkaria.postgresql.org; Tue, 28 Aug 2018 17:27:59 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1fuhmX-0001L7-Gk
	for pgsql-admin@arkaria.postgresql.org; Tue, 28 Aug 2018 17:27:57 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <cb@df7cb.de>)
	id 1fuhmX-0001Kz-4e
	for pgsql-admin@lists.postgresql.org; Tue, 28 Aug 2018 17:27:57 +0000
Received: from feynman.df7cb.de ([195.49.152.168])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <cb@df7cb.de>)
	id 1fuhmP-0003ie-C4
	for pgsql-admin@postgresql.org; Tue, 28 Aug 2018 17:27:55 +0000
Received: from msg.df7cb.de (unknown
 [IPv6:2a02:908:1470:e5c0:76e5:bff:fef3:7e00])
	(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
	(Client did not present a certificate)
	by feynman.df7cb.de (Postfix) with ESMTPSA id 420G0w5B5Zz3DyB;
	Tue, 28 Aug 2018 19:27:44 +0200 (CEST)
Date: Tue, 28 Aug 2018 19:27:44 +0200
From: Christoph Berg <myon@debian.org>
To: Jorge Torralba <jorge.torralba@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Index corruption after pg_basebackup
Message-ID: <20180828172744.GD24526@msg.df7cb.de>
Mail-Followup-To: Christoph Berg <myon@debian.org>,
	Jorge Torralba <jorge.torralba@gmail.com>,
	pgsql-admin@postgresql.org
References: 
 <CACut7uRx72_R-nGOdOdnTSYCGGdKZ_TfsSghCb35+deF3s-4nw@mail.gmail.com>
 <20180828164239.GC24526@msg.df7cb.de>
 <CACut7uTwWhXKHg+Fd3sy6hFnxWn58sLZPOr4frgrg23+NEgq-A@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CACut7uTwWhXKHg+Fd3sy6hFnxWn58sLZPOr4frgrg23+NEgq-A@mail.gmail.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

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