From: Dmitry O Litvintsev <litvinse@fnal.gov>
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Help. The database was created using collation version 2.17, but the
 operating system provides version 2.34.
Thread-Topic: Help. The database was created using collation version 2.17, but
 the operating system provides version 2.34.
Thread-Index: AQHawuDa9Q6qey54bEmEIFA9yQBaTA==
Date: Thu, 20 Jun 2024 07:23:38 +0000
Message-ID:
 <SA1PR09MB73117897B54EBA26D2530CC1B9C82@SA1PR09MB7311.namprd09.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
msip_labels:
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=fnal.gov;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: SA1PR09MB7311:EE_|SJ0PR09MB11091:EE_
x-ms-office365-filtering-correlation-id: 902dd6dc-ba89-4016-8b4b-08dc90f9e780
x-fermilab-ob: 1
x-fermilab-sender-location: inside
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;ARA:13230037|1800799021|366013|38070700015;
x-microsoft-antispam-message-info:
 =?iso-8859-1?Q?gffeCWAlP1jjgymA0SaR5bAYLgOej36lO6O3CgDvlHOcmRvcqYWWY7AU8M?=
 =?iso-8859-1?Q?Qj5gW7VHCBRqWN3lqbXpfCyTlMQP8M17kw+cwqJgMXJlrAgL0i/powCTRx?=
 =?iso-8859-1?Q?lGlppc1a/zT8RVCl4Ka3eFeKC5fzkg0z5rPFDoEF1TeanvbAojDgImJsNu?=
 =?iso-8859-1?Q?rkRrEVNYaexDr33A273NtBVYmgf2A7kPtpDsaS6VsbhnUnqHGTDr2B8U2O?=
 =?iso-8859-1?Q?A+42+EJt5RZ7bosPEuTxLmL0tfaN82+mBi6rE2Qd5+/LnECmLpb83YF+Wm?=
 =?iso-8859-1?Q?iGdj4M0ntCOzdRXFKDGHaZit1yoFiDpQbMr/2EUC8bxNVlHsbjW+7t9bDX?=
 =?iso-8859-1?Q?ppyQjFfl289u8PqlXy6uoux7t7X/HRXSN9kaZExVhF6RcEqQakDPAD5iws?=
 =?iso-8859-1?Q?+yU/gv4V/OjtCnfQ7jQp4hwkos7D66aQb2rlgkEnECgsuzl2MpZ0nfjGJY?=
 =?iso-8859-1?Q?xjRH+KmVpzpE5g8DfDJkCXTEClXlDB68kvMv2fDZTYYR/4NpI0yD9yDEjV?=
 =?iso-8859-1?Q?q4aNk6LzzTfi58ZtXwRN+CPMjg2NOQ7eMVsMuuepMsukgFG+1ESQrO+9S6?=
 =?iso-8859-1?Q?4VyyeRwl3QSzwOE14ZBVNADyq5MtvuE4j1k0QB6/Ik18/rgiv8qxV9dUwW?=
 =?iso-8859-1?Q?qCfp3XP44pbMOSNdJoTZc56AM1RIsIe9VZngPrW16+RM6YVJJJJZ/BOeZe?=
 =?iso-8859-1?Q?qBrlBWranu4+HdyJhTw7Z0VRzeMpnTDOxU76zChjSDLpkOQxLpZLsQghMq?=
 =?iso-8859-1?Q?VmWq0KBq3WQMane0xH1hRZZ4fKNh2wf/YLG8MMAxjgWopn4BTiYpqUvn06?=
 =?iso-8859-1?Q?HdrrUnV8r+UclD1c7h0NUhe9WZ6rJ2A2Q8dY89e20vRT84h69FZha0GHoO?=
 =?iso-8859-1?Q?CAiFZY/0vk2xYQuV77coAu0B4nRF8BSjFkfSvKJhJvzpFpSrdc3XS3omWL?=
 =?iso-8859-1?Q?6iUuocPpryBSlKOY1BAOWs4Rb4SK7+zedbmMZChjV0x3aRL5r4GqMI3RAp?=
 =?iso-8859-1?Q?IE9Bn45QCyLf5vsLaQi3dQwcDI8+9CpzAz/K84QU05hXTMLT8EV6CIcr96?=
 =?iso-8859-1?Q?KXvpK5tDXL4ePAS1JsCM06QT0Fu1JgtHycx9hD/RXzAWabk6K9Pahdptdt?=
 =?iso-8859-1?Q?BKDy0GGH1L5uNPr6CLpnF5Dmr8DqL5PrBUxkBNdsDOomk29/5lXf0kvikC?=
 =?iso-8859-1?Q?6jnVYts7ii2suRVKRY9OaEUPxLI6VM1VjXiGnQQ85uEmBynqeou4lsVchD?=
 =?iso-8859-1?Q?v4o3L7O7atM2c1nYtEy+gCU2gJ55t0qG+ipIMDxnOVMbEXQpzAN+iwiP8X?=
 =?iso-8859-1?Q?f3AEeubENK1/O1Ak+rHGfTiC021GV42R5Ybg63xXX5zcBK0hdo8scvYhs/?=
 =?iso-8859-1?Q?6prjS1jAvrALCnPcTKTmZk6t33XZWCZzoSgHoJzhSr+JW2L8y+T5A=3D?=
x-forefront-antispam-report:
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:SA1PR09MB7311.namprd09.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230037)(1800799021)(366013)(38070700015);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?iso-8859-1?Q?CjmVpf30HFEvMr/KGK+CIxowdFBFqaxDFLjUAX6vrAb217SSwd7DcmGaL7?=
 =?iso-8859-1?Q?Tiv19vTsxnZhwEtxTra71mZxiIZUVxoModoBoSSEVcpIxS41RXbKSblpc1?=
 =?iso-8859-1?Q?V8zyGu4k3ocert8akbGZpoZzP9vi3mvcMY0RIaeGmnKL53rWXTo/Z6OLzw?=
 =?iso-8859-1?Q?AHk7wgrpItw2MU8FKu9CcwfQ5/YDsEei577fFkcdGKN75LEmEk2aKGam1y?=
 =?iso-8859-1?Q?KOHnXOae/PFTrRrIDJj+sVpGr7TFOMA13GShbVdE03NLRVmF7E+7ci28aT?=
 =?iso-8859-1?Q?R/5271kux937KAghhezO1Vd/VJmiQCFg5Uv0+rDcwwt5HLd07MKOutRT2N?=
 =?iso-8859-1?Q?oB7eGOPhfYpFMUqmRxLBJ78yJr/MaIZZa/Y1mSsbMEq2a4DbJ3cztWFiEh?=
 =?iso-8859-1?Q?tGcHFQ+k71OHKiS3/xtSpb2xcgKfy8q/t1RgeDE4gtdIAb9W4+cdeb35VQ?=
 =?iso-8859-1?Q?BIFnawDth9FJ/EIAbmLW3sWBU/s3FSDXN0dfzSoGI1f551mR0Vj8chzS4P?=
 =?iso-8859-1?Q?T+KVDpdZcR8uvxoigJDMCjjXPBOtARwq49krsB+0hcfiKL/BY4FB0odt6v?=
 =?iso-8859-1?Q?r2TPtSwTyAUVMjR1ZGo8WK6qE6vw6hE3jav73XY2z11XNMDBOffRoALbF+?=
 =?iso-8859-1?Q?2lGSmQtzo8P4NJ1cDMthV6dZ144lZaue89ET5ZIB41nmW6yrNCBdwD0MTK?=
 =?iso-8859-1?Q?7GSNiptkrOdkaXPehy+YR8NwY4gIwNqpS66VOfSGOT4X7jq1BYw9S9eT2E?=
 =?iso-8859-1?Q?Ok65HuQAnQpd2NRtbYQCMGmjCSXHl5YN4lOZ4qvmRRRBKAlfKO+Q4DrEt2?=
 =?iso-8859-1?Q?5PMbOhTHygk7qJqIVyLM7QUSc3VRshGLkFv7GNXWkfJerKAeNFu7fYnAt6?=
 =?iso-8859-1?Q?cN0JvmXv7WJkXmFmpzCNTlG1c/jbP6VArAJEipt950jWoCMeUHORo2NgYd?=
 =?iso-8859-1?Q?Q1q8W7TfKGcRigeefaG+c4OQBCCJJqY2j760U1kWlJHJVbvZrD3k800Ywk?=
 =?iso-8859-1?Q?S102d3knZOyKGlcZTdqExVxSGbhcs2wKnm2nWHnJM85aP5+8ZiPjlx10TH?=
 =?iso-8859-1?Q?xnwkiNaQa28bkwHiuUU4e2cQIraiI+n8ilPKIih1WalHB6l4lWi+FvVbP0?=
 =?iso-8859-1?Q?ZQe5LhYRexwq10MxwRKcXIP6CRidJwLzMRIgCu1ILuZlq5fBnHj5cuUn7r?=
 =?iso-8859-1?Q?nOiKBPLnKQXfozCSZN+4QhHp2b6/YWNmW47iAVBQ2RYBeAun4mHVAfEIwj?=
 =?iso-8859-1?Q?l0/VPdq5CCXZ+NQOa0cH0xe2R+QI1vFCTBGcjva9Bjce5dd8ZDCtp5zUxv?=
 =?iso-8859-1?Q?MAh2n32EYn+g2w/8ZnO0/g+QpqIYuf0E/3LygyuIitv+aMWQ7TT4RGAuKN?=
 =?iso-8859-1?Q?kMtOB2kQ4kfV198odXZk3Fv9f1+A+KzgBXOdlubJy+LhbNTQAk4o2jJoTN?=
 =?iso-8859-1?Q?2mBeNiB+Wq9LZqekLxdsaKfbGXpO2mSHRP00WtqQSqPQcCRnf+YuILx7Ho?=
 =?iso-8859-1?Q?DNaSPZGu37CzyuAfBmGpdRQc6GXYqO/iVlbFg2n2TaQhX0Vy9y1SKXRE0+?=
 =?iso-8859-1?Q?f3tqGOV5kQ8ZLjK54htG4SgC15MfC9N/812LJFau+ukYZnFA31YIYpHfV2?=
 =?iso-8859-1?Q?XP5dPTmHAUqeE345aAITx1+k4dY+gZMlmH?=
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: fnal.gov
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: SA1PR09MB7311.namprd09.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 902dd6dc-ba89-4016-8b4b-08dc90f9e780
X-MS-Exchange-CrossTenant-originalarrivaltime: 20 Jun 2024 07:23:38.4877
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 9d5f83d3-d338-4fd3-b1c9-b7d94d70255a
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SJ0PR09MB11091
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/SA1PR09MB73117897B54EBA26D2530CC1B9C82%40SA1PR09MB7311.namprd09.prod.outlook.com>
Precedence: bulk

Hello, =0A=
=0A=
I am in the process of migrating DB to Alma9 host. The databse =0A=
is rather large - few TBs. =0A=
=0A=
I have run pg_basebackup on Alma9 host and established replication from pro=
duction to it. The idea is to quickly switch from master to this new host d=
uring downtime. =0A=
=0A=
Establishing replication went fine. Source postgresql version is 15.6, dest=
ination is 15.7=0A=
=0A=
When I psql into replica I get:=0A=
=0A=
WARNING:  database "xxx" has a collation version mismatch=0A=
DETAIL:  The database was created using collation version 2.17, but the ope=
rating system provides version 2.34.=0A=
HINT:  Rebuild all objects in this database that use the default collation =
and run ALTER DATABASE xxx REFRESH COLLATION VERSION, or build PostgreSQL w=
ith the right library version.=0A=
=0A=
Looking up the issue the solution seems to be =0A=
=0A=
  REINDEX database xxx =0A=
  ALTER DATABASE xxx REFRESH COLLATION VERSION=0A=
=0A=
But this defeats the whole idea of having short downtime because REINDEX wi=
ll take forever. =0A=
=0A=
What is this "or build PostgreSQL with the right library version"?=0A=
Is this about 15.7 vs 15.6 or is it about different glibc version between R=
H7 and Alma9?=0A=
=0A=
Is there a better way to handle it? I cannot afford long downtime. =0A=
This came up rather unexpectedly and I am now in a tight situation having t=
o find solution fast. I do not recall having similar issue when going from =
RH6 to RH7. =0A=
=0A=
Thank you for your help.=0A=