sqldatabasepostgresqlpgadmin-4postgresql-16

I am getting an error in pgadmin as "unrecognized configuration parameter "lc_collate" " how to fix this?

Refer this!

I was creating a database and got this error i tried to uninstall and then reinstall postgresql-16 and pgadmin4 but it didn't work for me! It creates a database but gives this error i am worried that what if it would block my task when i am half done !

Solution

  • The parameter lc_collate got removed in PostgreSQL v16, because it didn't reflect the actual collation any more.

    Use a version of pgAdmin that supports PostgreSQL v16. According to the release notes, that should be 7.8 or better (but use the latest one).