On Thu, Jan 8, 2026 at 2:18 PM Rihad <[email protected]> wrote: > We only have "i" & "c" in pg_collation. And we aren't using any of "i" it > seems. All this locale/encoding/collate stuff is too much for me to handle, > sorry)
As Daniel already told you, it's pg_database.datlocprovider that matters. > So if we are using the internal (builtin) "c" provider how come the PG 18.1 > run on FreeBSD 13.5 version shows warnings that the system version is 34.0? "c" is NOT built-in. It's implemented thanks to the OS' libc as a dependency. "b" is built-in, i.e. entirely within postgres, w/o external dependencies (like icu or libc). New in PostgreSQL 18. > Then upgrading (the OS from) 13.5 to 14.3 is our only option. Given you're likely on "c", probably. As recommeded by Daniel. --DD
