Hello all,
since the message is 'Ident authentication failed for user "testusr"', in pg_hba.conf the host/user/database combination must be configured to be identified by the ident protocol, which is very insecure.
Please change the entry to "md5" or whatever is appropriate. Or you set up an ident service on the client, which would help authenticating the testusr. Please bear in mind that it isn't secure.
Regards,
Holger
Hi Shreeyansh,
In local and it’s a windows server, yes “testusr” is the local admin user and infact postgres is also installed using this “testusr”.
Thanks
Soumik
From: Shreeyansh Dba <shreeyansh2014@gmail.com>
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: pg_dump Error in Windows
Does your "testuser" have super user privilege..? User must have super user privileges to perform pg_dumpall.
Are you trying to perform backup from remote server or local...?
Hello All,
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?
Please suggest a solution.
Thanks
Soumik