From: Pepe TD Vo <pepevo@yahoo.com>
To: Shreeyansh Dba <shreeyansh2014@gmail.com>
To: soumik.bhattacharjee@kpn.com <soumik.bhattacharjee@kpn.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: pg_dump Error in Windows
Date: Thu, 21 Mar 2019 12:58:40 +0000 (UTC)
Message-ID: <44634550.8675094.1553173120647@mail.yahoo.com> (raw)
In-Reply-To: <CAGDYbUNuLnh=bGwwZ+MqFAyv6rHpH8EkTGHZvfW_6PSXpM3MBQ@mail.gmail.com>
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>
<CAGDYbUNuLnh=bGwwZ+MqFAyv6rHpH8EkTGHZvfW_6PSXpM3MBQ@mail.gmail.com>
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@gmail.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.bhattacharjee@kpn.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@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”. ThanksSoumik 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. ThanksSoumik
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, shreeyansh2014@gmail.com, soumik.bhattacharjee@kpn.com, pgsql-admin@lists.postgresql.org
Subject: Re: pg_dump Error in Windows
In-Reply-To: <44634550.8675094.1553173120647@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