I try to use PostgreSQL backup script here. I set the username at the config file and tried to run pg_backup.sh.
But I get "Ident authentication fault for user 'aquila'".(aquila is the username I am trying to connect with).
I created a .pgpass file at the home directory. The content of the file is like
*:*:*:aquila:<password> (I am sure password is correct).
I also tried to change pg_hba.conf file as;
local all all md5
Also I tried
local all all ident
Whatever I did, I couldn't achive to run this script because of this error.
How can I get rid of this error?
Thanks.
pg_hba.conf
#TYPE DATABASE USER ADDRESS METHOD
local all all md5
host all all 0.0.0.0 md5
host all all ::1/128 ident
I did not share command-out parts of the file. This is the current pg_hba.conf file. But I also tried to add followings;
local all all ident
local all all trust
host all all 127.0.0.1/32 trust
I finally found the solution. I have changed
#TYPE DATABASE USER ADDRESS METHOD
local all all md5
host all all 0.0.0.0 md5
host all all ::1/128 ident
to
#TYPE DATABASE USER ADDRESS METHOD
local all all md5
host all all 0.0.0.0 md5
host all all ::1/128 md5
I really did't understand why this fixed the problem but it is fixed :)
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments