From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: pg_dump Error in Windows
Date: Thu, 21 Mar 2019 12:59:07 +0100
Message-ID: <9101d8be-abc0-382f-9884-c371a90af3a1@jakobs.com> (raw)
In-Reply-To: <2A91BEF8171A5349931391E0C721CC5326FAF260@CPEMS-KPN301.KPNCNL.LOCAL>
References: <2A91BEF8171A5349931391E0C721CC5326FAF1F0@CPEMS-KPN301.KPNCNL.LOCAL>
<CAGDYbUPMiL8ENWphfv000iSUXXzYRk+zDxm9eDOHxAwVkLH8OA@mail.gmail.com>
<2A91BEF8171A5349931391E0C721CC5326FAF260@CPEMS-KPN301.KPNCNL.LOCAL>
Hello all,
since the message is 'Ident authentication failed for user "testusr"',
in pg_hba.conf the host/user/database combination must be configured to
be identified by the ident protocol, which is very insecure.
Please change the entry to "md5" or whatever is appropriate. Or you set
up an ident service on the client, which would help authenticating the
testusr. Please bear in mind that it isn't secure.
Regards,
Holger
Am 21.03.19 um 12:53 schrieb soumik.bhattacharjee@kpn.com:
>
> 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 <http://www.shreeyansh.com;
>
>
>
>
>
> On Thu, Mar 21, 2019 at 3:46 PM <soumik.bhattacharjee@kpn.com
> <mailto: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
>
>
>
>
>
--
Holger Jakobs, Bergisch Gladbach
instant messaging: xmpp:holger@jakobs.com
+49 178 9759012 <tel:+491789759012> oder +49 2202 817157
<tel:+492202817157>
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: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: pg_dump Error in Windows
In-Reply-To: <9101d8be-abc0-382f-9884-c371a90af3a1@jakobs.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