1

I have a problem when I am trying to connect the database that I have in pgadmin with my QGIS project. I am trying to create a New PostGIS connection like in the following picture:

enter image description here

But I am always getting the following when I am trying to connect with my credentials to the database.

enter image description here

Do you know what should I do in order to solve it? I have checked that solution but it doesn't work for me (Authentication using PG 10 scram-sha-256 password encryption)

PS: I am using QGIS3.6 and pgAdmin 4 v6.

Improve this question
2
  • Click the Store button? for username/password
    – Mapperz ♦
    Feb 9, 2022 at 14:45
  • @Mapperz I have done it already but this doesn't change the error!
    – Anas.S
    Feb 9, 2022 at 14:46

1 Answer 1

Reset to default
0

this worked for me: QGIS failure in PostGIS connection: "ident authentication failed for user"

The local connection (to 127.0.0.1) worked if I use trust in /etc/postgresql/11/main/pg_hba.conf:

host all all 127.0.0.1/32 trust host all all ::1/128 trust

Improve this answer
1
  • "Trust" actually means anyone can connect without password
    – Boodoo
    Jul 13 at 14:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.