How to troubleshoot Ident authentication on pgAdmin 4

Answered 3 years ago (Apr 17, 2021) by Eldernode staff

Dear Amoury, 

To fix the issue, edit pg_hba.conf file.

So, for PostgreSQL 11, run:

vi /var/lib/pgsql/11/data/pg_hba.conf

And for PostgreSQL 10, run:

vi /var/lib/pgsql/11/data/pg_hba.conf  

Then, update the below line:

TYPE  DATABASE        USER            ADDRESS                 METHOD  host     all            all              all                     md5

Finally, restart the PostgreSQL service.
 

For PostgreSQL 11, run:

systemctl restart postgresql-11

And for PostgreSQL 10, run:

systemctl restart postgresql-10

I guess your issue should be solved now, but feel free to send me a message again if you still face the error.

Good Luck.