Re: pg_dump Error in Windows

Try to reconfig your script and use localhost not hostname and it work well.

I had an issue with this too and I found out the port works only for local host not registered with hostname.  SA tried to help me and still not work.  Since it's development server, I just let it be with localhost.
 Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success

On Thursday, March 21, 2019 8:19 AM, "soumik(dot)bhattacharjee(at)kpn(dot)com" <soumik(dot)bhattacharjee(at)kpn(dot)com> wrote:

#yiv6584036234 #yiv6584036234 -- _filtered #yiv6584036234 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv6584036234 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv6584036234 #yiv6584036234 p.yiv6584036234MsoNormal, #yiv6584036234 li.yiv6584036234MsoNormal, #yiv6584036234 div.yiv6584036234MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New serif;}#yiv6584036234 a:link, #yiv6584036234 span.yiv6584036234MsoHyperlink {color:blue;text-decoration:underline;}#yiv6584036234 a:visited, #yiv6584036234 span.yiv6584036234MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv6584036234 p.yiv6584036234msonormal0, #yiv6584036234 li.yiv6584036234msonormal0, #yiv6584036234 div.yiv6584036234msonormal0 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;}#yiv6584036234 span.yiv6584036234EmailStyle18 {font-family:sans-serif;color:#1F497D;}#yiv6584036234 .yiv6584036234MsoChpDefault {font-family:sans-serif;} _filtered #yiv6584036234 {margin:70.85pt 70.85pt 70.85pt 70.85pt;}#yiv6584036234 div.yiv6584036234WordSection1 {}#yiv6584036234 Below are the entries in pg_hba.conf  file.   I tried re-setting the postgres db user password, but it did not helped.   Could you please let me know do I need to put the entries in this file for “testusr” and bounce the server back?   Thanks..       From: Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
Sent: Thursday, March 21, 2019 1:07 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   To perform any backup requires DB level superuser reset postgres db user password then try . Also make sure user entry in pg_hba.file  if you are using authentication method to md5.
Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com     On Thu, Mar 21, 2019 at 5:23 PM <soumik(dot)bhattacharjee(at)kpn(dot)com> wrote:
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     On Thu, Mar 21, 2019 at 3:46 PM <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