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 !
I am getting an error in pgadmin as "unrecognized configuration parameter "lc_collate" " how to fix this?
2.3k Views Asked by Divya Rathod At
4
There are 4 best solutions below
0
On
Check to see if you have an older verison of SQL installed, and delete it. This fixed the problem for me.
0
On
Update to the latest version of pgAdmin 4 to resolve this issue.
The version disparity between PostgreSQL and pgAdmin 4 caused this problem and other issues such as the inability to Backup the database.
1
On
Re: "The parameter lc_collate got removed in PostgreSQL v16, because it didn't reflect the actual collation any more."
Clarification - the text of the PostgreSQL 16 Doc post speaks to only the "server" level variables having been removed, not the database level.
"Remove read-only server variables lc_collate and lc_ctype (Peter Eisentraut)"
The parameter
lc_collategot 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).