PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – 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 !

Tags:

2

Answers


  1. 0

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

    Login or Signup to reply.
  2. 0

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

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search