Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gh9I7-0008Hy-KS for pgsql-admin@arkaria.postgresql.org; Wed, 09 Jan 2019 08:32:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gh9I5-0001HP-TS for pgsql-admin@arkaria.postgresql.org; Wed, 09 Jan 2019 08:32:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gh9I5-0001Ep-IS for pgsql-admin@lists.postgresql.org; Wed, 09 Jan 2019 08:32:45 +0000 Received: from lungold.riddles.org.uk ([82.68.208.19]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gh9I2-0002KN-EM for pgsql-admin@lists.postgresql.org; Wed, 09 Jan 2019 08:32:44 +0000 Received: from [192.168.127.1] (port=37406 helo=caithnard.riddles.org.uk) by lungold.riddles.org.uk with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.88 (FreeBSD)) (envelope-from ) id 1gh9Hz-000G8F-Pa; Wed, 09 Jan 2019 08:32:39 +0000 Received: from [127.0.0.1] (port=40648 helo=caithnard.riddles.org.uk) by caithnard.riddles.org.uk with esmtp (Exim 4.89 (FreeBSD)) (envelope-from ) id 1gh9Hy-000F63-V2; Wed, 09 Jan 2019 08:32:39 +0000 From: Andrew Gierth To: Natalie Wenz Cc: pgsql-admin@lists.postgresql.org Subject: Re: Database migration across different operating systems In-Reply-To: (Natalie Wenz's message of "Tue, 8 Jan 2019 13:16:47 -0600") Message-ID: <87sgy2p70d.fsf@news-spur.riddles.org.uk> References: <875zuzr06z.fsf@news-spur.riddles.org.uk> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix) Date: Wed, 09 Jan 2019 08:32:37 +0000 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk >>>>> "Natalie" =3D=3D Natalie Wenz writes: Natalie> Thanks, Andrew.=20 Natalie> All of our databases do have lc_collate=3DC. To check my Natalie> understanding, if that were not the case, we=E2=80=99d need to Natalie> reindex, but since it is all lc_collate=3DC, we shouldn=E2=80=99t= run Natalie> into that particular problem. Did I get that right? To be completely precise, it's not enough to have lc_collate=3DC, you also need to not have indexed columns with individually specified non-default collations. i.e. what matters is not so much the database setting, but the actual collation being used for indexed columns (because it's the collation that determines the order in which values appear in the index). --=20 Andrew (irc:RhodiumToad)