unrecognized configuration parameter lc_collate on postgres 16 about postgres-operator

[andrewlecuyer]

Hi @flikweert44! What you're seeing is actually the result of a change in Postgres 16.

More specifically, please see the following in the Postgres 16 release notes:

https://www.postgresql.org/docs/release/16.0/

Remove read-only server variables lc_collate and lc_ctype (Peter Eisentraut)

Collations and locales can vary between databases so having them as read-only server variables was unhelpful.

Therefore, what you are seeing is expected after moving to Postgres 16.

Hope this helps!

[benjaminjb]

Hello @flikweert44, I believe the above question has been answered; if you check the database, it should have the Collate field so that you can check per database. I'm going to close this issue, but if you have other questions about this topic and PGO, please reopen it or come ask in our Discord server.

[flikweert44]

Yes that answers my question, thanks