Re: pg_dump Error in Windows

I do have this entry on pg_hba.conf# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
 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:39 AM, Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> wrote:

It seems the the local level entry are missed in pg_hba.conf file your entry must like below...
# TYPE  DATABASE    USER     ADDRESS    METHOD# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             127.0.0.1/32        md5
# IPv6 local connections:
host    all             all             ::1/128                md5

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

On Thu, Mar 21, 2019 at 5:49 PM <soumik(dot)bhattacharjee(at)kpn(dot)com> wrote:

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”. ThanksSoumik 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. ThanksSoumik