Hi Soumik,
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...?
On Thu, Mar 21, 2019 at 3:46 PM <soumik.bhattacharjee@xxxxxxx> wrote:
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
