Divya Rathod
Divya Rathod

Reputation: 85

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 !

Upvotes: 8

Views: 15992

Answers (6)

Dennis McB
Dennis McB

Reputation: 1

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)"

Refer to: https://www.postgresql.org/docs/16/release-16.html

Upvotes: 0

user26601845
user26601845

Reputation: 1

Update pgadmin, it will resolve the issue. I also faced same, it got resolved after updating it.

Upvotes: 0

Meowsterr_666
Meowsterr_666

Reputation: 1

I had the same error. Right click the server and hit "refresh". The UI must be acting weird with the new update. Hopefully this helped if you're running into this again.

Upvotes: 0

Mostafa Hassan
Mostafa Hassan

Reputation: 31

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.

Upvotes: 2

John Floeng
John Floeng

Reputation: 1

Check to see if you have an older verison of SQL installed, and delete it. This fixed the problem for me.

Upvotes: 0

Laurenz Albe
Laurenz Albe

Reputation: 247370

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).

Upvotes: 12

Related Questions