Re: pg_dump Error in Windows

[Holger Jakobs <holger@xxxxxxxxxx>]

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

Am 21.03.19 um 12:53 schrieb soumik.bhattacharjee@xxxxxxx:

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@xxxxxxxxx>
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@xxxxxxx>
Cc: Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: pg_dump Error in Windows

 

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...?

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com

 

 

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

 

 

--

Holger Jakobs, Bergisch Gladbach
instant messaging: xmpp:holger@xxxxxxxxxx
+49 178 9759012 oder +49 2202 817157