Postgres 16 Docker Image gives error: unrecognized configuration parameter "lc_ctype"

[birarisonali26]

Steps to reproduce:

1. docker pull postgres:16
2. docker run -d --name postgresnew -e LANG=en_US.utf8 -e POSTGRES_INITDB_ARGS="--locale-provider=icu --icu-locale=en-US" -e POSTGRES_PASSWORD=welcome1 postgres:16
3. docker exec -ti postgresnew bash
4. Once inside container, execute: psql -U postgres
5. this will launch postgresql promt
6. Enter following command: show lc_ctype
7. It gives following error:

   postgres=# show lc_ctype
   postgres-# ;
   ERROR:  unrecognized configuration parameter "lc_ctype"

   

Same query works for Postgres14 Version

[LaurentGoderre]

Not sure this is a problem with the image itself. Using your example, running show all; shoows a list and lc_ctype idsn't there but other ones like lc_numeric are so show lc_numeric; works.

Listing the databases shows the ctype though

   Name    |  Owner   | Encoding | Locale Provider |  Collate   |   Ctype    | ICU Locale | ICU Rules |   Access privileges   
-----------+----------+----------+-----------------+------------+------------+------------+-----------+-----------------------
 postgres  | postgres | UTF8     | icu             | en_US.utf8 | en_US.utf8 | en-US      |           | 
 template0 | postgres | UTF8     | icu             | en_US.utf8 | en_US.utf8 | en-US      |           | =c/postgres          +
           |          |          |                 |            |            |            |           | postgres=CTc/postgres
 template1 | postgres | UTF8     | icu             | en_US.utf8 | en_US.utf8 | en-US      |           | =c/postgres          +
           |          |          |                 |            |            |            |           | postgres=CTc/postgres

[ImreSamu]

ERROR: unrecognized configuration parameter "lc_ctype"

In Postgresql 16, many server variables will be removed, which are included in the PG16 Release Notes.

---

Version 16 contains a number of changes that may affect compatibility with previous releases.

• _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._

• _Remove the server variable vacuum_defer_cleanup_age (Andres Freund) This has been unnecessary since hot_standby_feedback and replication slots were added._

• _Remove server variable promote_trigger_file (Simon Riggs) This was used to promote a standby to primary, but is now easier accomplished with pg_ctl promote or pg_promote()._

• ....

see the full changes: https://www.postgresql.org/docs/16/release-16.html

[LaurentGoderre]

Closing since this is an expected change and there are alternate ways to access the info

[birarisonali26]

Thanks LaurentGoderre and ImreSamu. This helps.