0

How to troubleshoot Ident authentication on pgAdmin 4

Asked 4 weeks ago (Apr 17, 2021) in the field of Operating Systems by Amoury

Hi, thank you for the tutorial How to install pgAdmin 4 on Fedora 33. I have done all correctly but I faced the  Fatal: Ident authentication failed for user error. How can I solve it?


Answers


0
Answered 4 weeks 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.

We are by your side every step of the way

Think about developing your online business; We will protect it compassionately

We are by your side every step of the way

+18054214518

7 days a week, 24 hours a day