RE: pg_dump Error in Windows

Ok, Thanks all, let me try and come back.

From: Pepe TD Vo <pepevo(at)yahoo(dot)com>
Sent: Thursday, March 21, 2019 1:59 PM
To: Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>; 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

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<mailto: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<http://127.0.0.1/32> md5
# IPv6 local connections:
host all all ::1/128 md5

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com<http://www.shreeyansh.com/>

On Thu, Mar 21, 2019 at 5:49 PM <soumik(dot)bhattacharjee(at)kpn(dot)com<mailto: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..

[cid:image001(dot)png(at)01D4DFEE(dot)C478F960]

From: Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com<mailto:shreeyansh2014(at)gmail(dot)com>>
Sent: Thursday, March 21, 2019 1:07 PM
To: Bhattacharjee, Soumik <soumik(dot)bhattacharjee(at)kpn(dot)com<mailto:soumik(dot)bhattacharjee(at)kpn(dot)com>>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org<mailto: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<http://www.shreeyansh.com/>

On Thu, Mar 21, 2019 at 5:23 PM <soumik(dot)bhattacharjee(at)kpn(dot)com<mailto: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<mailto:shreeyansh2014(at)gmail(dot)com>>
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik <soumik(dot)bhattacharjee(at)kpn(dot)com<mailto:soumik(dot)bhattacharjee(at)kpn(dot)com>>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org<mailto: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