It seems the the local level entry are missed in pg_hba.conf file your entry must like below...
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only local all all peer # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5
To perform any backup requires DB level superuser reset postgres db user password then try . Also make sure user entry in pg_hba.file if you are using authentication method to md5.
When I am trying to take backup using pg_dump.exe , it’s asking for password, when I provide the default password of “postgres” it never accepts and throws below error-
pg_dump: [archiver (db)] connection to database "test_database" failed: FATAL: Ident authentication failed for user "testusr"
Is there any changes I need to do in pg_hba.conf file?