From: Pepe TD Vo <pepevo@yahoo.com>
To: soumik.bhattacharjee@kpn.com <soumik.bhattacharjee@kpn.com>
To: shreeyansh2014@gmail.com <shreeyansh2014@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: pg_dump Error in Windows
Date: Thu, 21 Mar 2019 12:24:53 +0000 (UTC)
Message-ID: <1181025133.8657674.1553171094004@mail.yahoo.com> (raw)
In-Reply-To: <2A91BEF8171A5349931391E0C721CC5326FAF285@CPEMS-KPN301.KPNCNL.LOCAL>
References: <2A91BEF8171A5349931391E0C721CC5326FAF1F0@CPEMS-KPN301.KPNCNL.LOCAL>
<CAGDYbUPMiL8ENWphfv000iSUXXzYRk+zDxm9eDOHxAwVkLH8OA@mail.gmail.com>
<2A91BEF8171A5349931391E0C721CC5326FAF260@CPEMS-KPN301.KPNCNL.LOCAL>
<CAGDYbUM_tp=xDYP2-dpSuRBYKHg7HtsQrfVWpqcA24BzKgwSuw@mail.gmail.com>
<2A91BEF8171A5349931391E0C721CC5326FAF285@CPEMS-KPN301.KPNCNL.LOCAL>
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.bhattacharjee@kpn.com" <soumik.bhattacharjee@kpn.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@gmail.com>
Sent: Thursday, March 21, 2019 1:07 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.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.bhattacharjee@kpn.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@gmail.com>
Sent: Thursday, March 21, 2019 12:45 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.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.bhattacharjee@kpn.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
Attachments:image001.png (image/png, 25.1K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pepevo@yahoo.com, soumik.bhattacharjee@kpn.com, shreeyansh2014@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: pg_dump Error in Windows
In-Reply-To: <1181025133.8657674.1553171094004@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox