Re: pg_dump Error in Windows

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(dot)bhattacharjee(at)kpn(dot)com:
>
> 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(at)gmail(dot)com>
> *Sent:* Thursday, March 21, 2019 12:45 PM
> *To:* Bhattacharjee, Soumik <soumik(dot)bhattacharjee(at)kpn(dot)com>
> *Cc:* Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
> *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 <http://www.shreeyansh.com>
>
>  
>
>  
>
> On Thu, Mar 21, 2019 at 3:46 PM <soumik(dot)bhattacharjee(at)kpn(dot)com
> <mailto:soumik(dot)bhattacharjee(at)kpn(dot)com>> 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(at)jakobs(dot)com
+49 178 9759012 <tel:+491789759012> oder +49 2202 817157
<tel:+492202817157>