Reputation: 85
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
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
Reputation: 1
Update pgadmin, it will resolve the issue. I also faced same, it got resolved after updating it.
Upvotes: 0
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
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
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
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