From: Dmitry O Litvintsev <litvinse@fnal.gov>
To: Daniel Verite <daniel@manitou-mail.org>
CC: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: 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: AQHawuDa9Q6qey54bEmEIFA9yQBaTLHQjamAgANFa52AAs3BAIAbPUCb
Date: Thu, 11 Jul 2024 16:57:18 +0000
Message-ID:
 <SA1PR09MB73114D8DF9E13773E9BD9E83B9A52@SA1PR09MB7311.namprd09.prod.outlook.com>
References:
 <SA1PR09MB7311E24901D1B718583739DFB9CA2@SA1PR09MB7311.namprd09.prod.outlook.com>
 <b8817ba6-1739-434f-bde5-5cb47ab85e8e@manitou-mail.org>
In-Reply-To: <b8817ba6-1739-434f-bde5-5cb47ab85e8e@manitou-mail.org>
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_|SA1PR09MB10547:EE_
x-ms-office365-filtering-correlation-id: bdb2e478-3685-4bd9-76bd-08dca1ca8629
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:13230040|366016|1800799024|38070700018;
x-microsoft-antispam-message-info:
 =?Windows-1252?Q?ILfFQDgzJqz8MJHON9c0kdBF4Y95uwKBZB/we7V+Lpg+gtpdixqc3Z1u?=
 =?Windows-1252?Q?RDfmdb+0MiXXrimB+rL+KVQYIw+cJGAwXsqiNaKgf4PmcCGiVCqdUJoy?=
 =?Windows-1252?Q?oc37b8ojB6cG9DANaoXTOsBIrDpULqC1OTCQ3tvwn9xdeB8fb0lcNjJ7?=
 =?Windows-1252?Q?3QEfchfolUrKA7PhJTl+WiAR2DyRcoN+pkB5MYKA9gBEjfRs1JUB5Emt?=
 =?Windows-1252?Q?TyeDpVhglW9JgH67iRjYDpHZkOybGFI1AmxZsGATJcKNr+PRBX7cp7B7?=
 =?Windows-1252?Q?+oIDuBLmh9EKK01hWiMLT2GKdsvKX9QLUeVU8/ueFP1tp8f4xMuFFXC/?=
 =?Windows-1252?Q?yoiRlqer2T94qpNyrpfZUVQ9lWOOR4zpehcHAzRfMQClkw5/RvPzGBBw?=
 =?Windows-1252?Q?czltP8XNoGurjp6xBcWWVGEiObJh1BKfGxJo1bLfZNobnbQl9jkEGwLk?=
 =?Windows-1252?Q?cliooLJ+/hkJMqCNmkPqRbbIGkAipYmUHhABGyvOE/0qKvrjiJrfzLvk?=
 =?Windows-1252?Q?s5a9lU3OkQEHwpAj2j8Ng5SNLyZ27MgUur6v88MSh6il0+Vj4G9J0M5L?=
 =?Windows-1252?Q?VTm4aFehcrOLuiRvqInWa7wDBsLIka0Tt+LAX02d7R7J5MdDrTO2Wrh3?=
 =?Windows-1252?Q?z8nq3BfiEdG9jIbETFQQKA05W/67gRCiyzWysUaqsKJ7zNVNw1jGKThm?=
 =?Windows-1252?Q?tB0o7yTRd6OIUI4PQUK1Qj7ittjQkXPNHvtwT2sXbT9fGeJyRGBou8SP?=
 =?Windows-1252?Q?5YdHM2M/r1kDH0FzRTmPcyhmvbXuZcvcb432y8b9j7BgDj2mf3847M6u?=
 =?Windows-1252?Q?aHU8rdkzocH3V/omjci+B0Iy5CRfDX4PuI93Cl20ZN7VJqZkdYVbdwo2?=
 =?Windows-1252?Q?btryAWMqVmb+8CALXZWz/0qYio3wjzR//03zJ0ItM7Gr/e6QWQb0Yw3a?=
 =?Windows-1252?Q?Zki9uk+5r9Qigg1cw3ri1+/RBDljdqWyf1aAHNxbDHPP5TPqYHKypnYJ?=
 =?Windows-1252?Q?9DqlS/qmMt16RiBMPkXPYpfnO5kODudhl5B5fmb1C8LpaUZLAaK75C8/?=
 =?Windows-1252?Q?lBFiz0BG6z2okLvP7Lto/ZxuJ3vAMA4eRchU/towA+Pco1BL6GYUfMA4?=
 =?Windows-1252?Q?g+ZArvu74V9Kp4sKPdC8XIQ/jNxf7i+TFL0xksiFnoa2cPu6oQ6MLmUJ?=
 =?Windows-1252?Q?KNVoGJB3HXDwCE/Zq6ePbn7NUKNXTAMFcijrTeN8iZHJ3g18v3P2O8f+?=
 =?Windows-1252?Q?qflCqGDMEhiiMZd3knvmWSPgzYxcdLVvAXip6wbWVxn+1cCSdh5FFFMb?=
 =?Windows-1252?Q?Ay8MSzCOp5nlkgrY6kS7/a5cQml24jqbQaDHfDFQNpu37cZOEW3p6oNZ?=
 =?Windows-1252?Q?d4qQiQyD0JS4aqPkH/kCc16NZ/8Gs9A+bdlNaBS99/fmv1f3ueTUzquP?=
 =?Windows-1252?Q?FVkdEWIzWX7GjXa7PcglSg=3D=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:(13230040)(366016)(1800799024)(38070700018);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?Windows-1252?Q?e+80PGb0cMoQl9ydGsvmFrpAvkqHYyexwMmI3cTYeoNYP+HH1f/8nZVn?=
 =?Windows-1252?Q?72O0nqPoD9jLnul8jS0L+b5EIWFW/TDx/5yWrnnk+LlayvJFvBRGeu7y?=
 =?Windows-1252?Q?v+DjuvG8ZiVY/RMK8Za5UMWocTGvA0s2PzXW/99ofQGBOoJtHUdBH6IV?=
 =?Windows-1252?Q?a7Od3lmgIG6+7q5l23pM0WtePHllWm94RBvz+9Gf10ZkbidK+CJ8t4ab?=
 =?Windows-1252?Q?qp0EYKPzAnMlUW4MGTpLkbgJW5iq2moOeA6br7vLn0XVJ+ZyJUbVSOEz?=
 =?Windows-1252?Q?76ebGoemjeAgsTb44LfDnIZW5H+7k6VFAkcZ6GuQX4OMaEZGC13u6M4s?=
 =?Windows-1252?Q?xhjLcYxiAOqS+ZfXEULGtxedt2/saDoM9oOOBk4JbvAkrIPKaubE0GdT?=
 =?Windows-1252?Q?qIHDRYwbn/vccXoy0fGk53LKoieIUMGeXagSaF/i5DoUyyVfQ46XjcDR?=
 =?Windows-1252?Q?iv+1s4h4dJlrRvBsU6ruS/e8ZIYtiYlWMuwKGk0gYJ3x3A5jIvx1Ct4R?=
 =?Windows-1252?Q?YQpWHxrDGjPclUgFobaLtHcV7Bc6yeh9wED4UWmNo7nTs4HG9/RGThyZ?=
 =?Windows-1252?Q?DAL5NTYlPsW4CUv+IVg4pp93np+iBoAFDWLoSnDvJnHQdePvArnZMVYr?=
 =?Windows-1252?Q?67mhlODfLawtzIZPRry6IKy695N5DG23n/6I4AS+zDdV+w4aylT6d4Go?=
 =?Windows-1252?Q?nZkfMBqVz/ZILNCsgs7eIx3Miz9FQtxMATkhEq91eWtFUu4JOL3LxHxo?=
 =?Windows-1252?Q?cTCtGWbM3E9ETxzoqMz7bRDk8dv7G8TEQQgbGwCBj3ix2P/CzHrs9+Lv?=
 =?Windows-1252?Q?4bGoPoHM4BYnnnYcANivQW1KB5DXgcC8RW9O9xGsYzXTMyRXEWTYjzIA?=
 =?Windows-1252?Q?zEyzJa+pXFzN42LGjzti4oCQfR6xhEDfXhE3JAP2bVUS9kseANZqE4Au?=
 =?Windows-1252?Q?2tVxOJ5vUzch0LhrH7/eOSA6xTIRGnMNQK+Sg8mkkJ/dwQvUk9p/jkKm?=
 =?Windows-1252?Q?AtG/rRIvGMRnVhTTX7peZZPwaQooHdFmwIQCbRBNbPd1J4UjTg7bPARY?=
 =?Windows-1252?Q?LQsy6exzFI6bnTjDJwRdAeG8e9QPbsvhHWBoR98VM3wwChQzHzpneUeP?=
 =?Windows-1252?Q?PwD1gwKbgTOI3ZqZCI7LW52ORNvg04OdMMxq4pyn/auZUbIJvxZn5XEZ?=
 =?Windows-1252?Q?OzDIfWPcIspVykzj4/x4XtaOtBj9AFpKy1ilXO4YDqAJndNXtxV4J9Yc?=
 =?Windows-1252?Q?KS/k1xk1lZ4pT1zqpjj66zvlYLypU9PsO418nwK9BzxkuecXkb8sl9Iq?=
 =?Windows-1252?Q?t9sQyhLjS80VzwZDlB4owKHYLFvICpg5BDZ4HF4ERad4Vd9LJX7fuXqs?=
 =?Windows-1252?Q?hAM56498yjB5jhN0Kh4kDhcRPzA192lTSolzZe1rAOWaPKs50sErfvyM?=
 =?Windows-1252?Q?iMtIb3CFVgrOeRWA9acdA6OEv/2vNVPmL4N1XvsW6ZwxmgjqG7og8x3m?=
 =?Windows-1252?Q?K78ss3zmCTr9mHgWpRzVH5tm2VKfzBe6ZpfMrETMYJyD0IttPU3mlo2Q?=
 =?Windows-1252?Q?+bUO6RbYR5yfAOMNQwLwNhC1blxvNsERhsMwtjf1mUvkg0Lb+7CfSgCM?=
 =?Windows-1252?Q?89B4NkOr4AltVNbxw8/mOP9G6pFwgIsivO6hlOhubLgZfBGktJQ8Or7U?=
 =?Windows-1252?Q?PKvj0vO/T5o2ncCVz2iNNtRcN6/m4B0B?=
Content-Type: text/plain; charset="Windows-1252"
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: bdb2e478-3685-4bd9-76bd-08dca1ca8629
X-MS-Exchange-CrossTenant-originalarrivaltime: 11 Jul 2024 16:57:18.5881
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 9d5f83d3-d338-4fd3-b1c9-b7d94d70255a
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SA1PR09MB10547
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/SA1PR09MB73114D8DF9E13773E9BD9E83B9A52%40SA1PR09MB7311.namprd09.prod.outlook.com>
Precedence: bulk

Hello,

Thank you to all who responded.
There is a follow up question.
Our admin tried the following:

  A host that wad been running postgresql11 was upgraded to Alma9 (from SL7=
) and
  postgresql15. They then built postgresql11 on that host from sources.
  Then they run pg_upgrade from 11 to 15. It worked and psql to db is not
  accompanied by "collation version" warning.

This was unexpected to me based on my experience that I related on this thr=
ead.
Is this a legit procedure?

To remind, what did no work:

  - upgrade to 15 on SL7 host, setup stream, replication to Alma9 host. psq=
l top replica
     complains about "The database was created using collation ..."

Advice is appreciated

P.S.: where I can still find postgresql11 RPMs for Alma9? Buiding from sour=
cres is OK, but a bit of a hassle.

________________________________________
From: Daniel Verite <daniel@manitou-mail.org>
Sent: Monday, June 24, 2024 3:48 AM
To: Dmitry O Litvintsev
Cc: pgsql-generallists.postgresql.org
Subject: Re: Help. The database was created using collation version 2.17, b=
ut the operating system provides version 2.34.

[EXTERNAL] =96 This message is from an external sender

        Dmitry O Litvintsev wrote:

> Just want to make clear (sorry I am slow on uptake). I should first
> REINDEX and then ALTER DATABASE xxx REFRESH COLLATION VERSION, or
> first ALTER and then REINDEX or does the order of these action
> matter at all?

The order does not matter. The ALTER DATABASE command will simply
update the pg_database.datcollversion field with the current version
of libc. That will stop the warning being issued, but it doesn't have
any other concrete effect.

Best regards,
--
Daniel V=E9rit=E9
https://urldefense.proofpoint.com/v2/url?u=3Dhttps-3A__postgresql.verite.pr=
o_&d=3DDwIFaQ&c=3DgRgGjJ3BkIsb5y6s49QqsA&r=3D7PHi3TDlwkvpc07MjENbOxVFl0u_sE=
urf250JnUFWCU&m=3DF7VKeBFcE7ctVYy8fHvYvWPu4XkawA0hCuQOkYZk28e1uHpd_pb21GOrR=
My9JB7a&s=3DM6qlhocjLWWgy8tVbTGTDEewC5JWHAfVztgV_XTx8Lg&e=3D
Twitter: @DanielVerite