Re: Help. The database was created using collation version 2.17, but the operating system provides version 2.34. - Mailing list pgsql-general

From Daniel Verite
Subject Re: Help. The database was created using collation version 2.17, but the operating system provides version 2.34.
Date
Msg-id b8817ba6-1739-434f-bde5-5cb47ab85e8e@manitou-mail.org
Whole thread Raw
In response to Re: Help. The database was created using collation version 2.17, but the operating system provides version 2.34.  (Dmitry O Litvintsev <litvinse@fnal.gov>)
List pgsql-general
    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érité
https://postgresql.verite.pro/
Twitter: @DanielVerite



pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Upgrade PG from 12 to latest
Next
From: arun chirappurath
Date:
Subject: Execute permission to function