Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h6wLr-0004iv-WD for pgsql-admin@arkaria.postgresql.org; Thu, 21 Mar 2019 11:59:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h6wLq-0004cO-Oa for pgsql-admin@arkaria.postgresql.org; Thu, 21 Mar 2019 11:59:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h6wLq-0004cH-FA for pgsql-admin@lists.postgresql.org; Thu, 21 Mar 2019 11:59:14 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_CAMELLIA_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h6wLn-0005Pw-M9 for pgsql-admin@lists.postgresql.org; Thu, 21 Mar 2019 11:59:14 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 55452BE0BF2 for ; Thu, 21 Mar 2019 12:59:10 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at rs.plausibolo.de Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id E0dC1nTr1IDa; Thu, 21 Mar 2019 12:59:07 +0100 (CET) Received: from [192.168.2.106] (p5B248C22.dip0.t-ipconnect.de [91.36.140.34]) by rs.plausibolo.de (Postfix) with ESMTPSA id 7D9D2BE0356; Thu, 21 Mar 2019 12:59:07 +0100 (CET) Subject: Re: pg_dump Error in Windows To: pgsql-admin@lists.postgresql.org References: <2A91BEF8171A5349931391E0C721CC5326FAF1F0@CPEMS-KPN301.KPNCNL.LOCAL> <2A91BEF8171A5349931391E0C721CC5326FAF260@CPEMS-KPN301.KPNCNL.LOCAL> From: Holger Jakobs Openpgp: preference=signencrypt Autocrypt: addr=holger@jakobs.com; prefer-encrypt=mutual; keydata= mQGiBEG8IA8RBAC6WqUzEPTjest7MvFca5WlI47EgtKzOy1D1X9gSEmPj0sQrilNGEitY/+Q kPnCvI3odz1XXf/MZQtXwlxJA4lPmx8/K7MqBj9vh0J5jRznpE7l+SBDmmDobIqBAgl6BZvH 1C7e2y72h5T1/plrXonLUGzthqBtsvWl0ogoyTJqiwCg6AOhYX+Xbcl8/AXy4F4qbUq4LXsD /j6yCKRkyleN688y9YpuS5J6/ZZ/OBCM74pa2iNge3GmXn1JeUowF693QFCGHkpswmDIoGhL 5iM6GHj9HFB6rTXW5H3sR1y6ta7vXwoNBGkgiM89B1a/KsLT5L6MZgZ5AV0tj6vxwAsuLixS SDiNVNAd8vp2FfqdLlOgThsgVIwKBACsCzZa1VxpdoNSYnkTOSZhEjZkbWApdneQ2bTxXJgW +fWgVeLiojCp6I1AmQqzwHz8UN1nrsQjH8Rnxt2J/C5H/Ek9jlOFakFQXlPMZw3tNeTA1P3B 3zPyq6hKFPZHFklUquE3gHVjnX9qxSW0xvFirf6xAMCMYWRnCQHRgiXoAbQhSG9sZ2VyIEph a29icyA8aG9sZ2VyQGpha29icy5jb20+iGQEExECACQCGwMGCwkIBwMCAxUCAwMWAgECHgEC F4AFAlZ7KnEFCSeLDWIACgkQileck7MZYbpbxgCgxM54+4qx/sfGwq01x93pWr2QghwAoIfD Of6Uoc43y98+xR5/Iu9Z1RH8uQENBEG8IBAQBACiGkoX8HKCocdCwRdMzc9siDs1w0YNayhT PnK9Ii3wzzS2R9NSyWsPQVyx6hkVfSmK6CE5RzfuDUzrYEgyaV/2vT3JD9Gko+RuFnjeQvVo 8hc19bmBSn95ATki+hFy/68MqpMlsG7YyCluRSpXh2qxlhbh2FzTIQmiEQAR4kFCEwADBQP/ Z1Y6nwoXw/5JmLJLFcvZZlFfn4g9TjyMSwH50/AXqOApccy9JSzoTFY87ItmGkhD0qj18PJB St2uqASGrk2/55XK596RWnoeyL9mzj5r6woDqPNRXIbK85foGVIMRrb/EufgSOP5H6VHybvB PD4CppEw4Q0fRsMCaOcvibkjHoqITwQYEQIADwIbDAUCVnsqcQUJJ4sNYQAKCRCKV5yTsxlh urunAJ9avyijdRls7l6XPc2cBMys3xu/sgCeOVJE6DzwBBRUd6S6mtf2eG4FPXg= Message-ID: <9101d8be-abc0-382f-9884-c371a90af3a1@jakobs.com> Date: Thu, 21 Mar 2019 12:59:07 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.5.1 MIME-Version: 1.0 In-Reply-To: <2A91BEF8171A5349931391E0C721CC5326FAF260@CPEMS-KPN301.KPNCNL.LOCAL> Content-Type: multipart/alternative; boundary="------------C318E04DFFC254A9B4A05999" Content-Language: de-DE List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------C318E04DFFC254A9B4A05999 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit 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 > *Sent:* Thursday, March 21, 2019 12:45 PM > *To:* Bhattacharjee, Soumik > *Cc:* Pgsql-admin > *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 > 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 oder +49 2202 817157 --------------C318E04DFFC254A9B4A05999 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

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

 

 

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

 

 

--

Holger Jakobs, Bergisch Gladbach
instant messaging: xmpp:holger@jakobs.com
+49 178 9759012 oder +49 2202 817157

--------------C318E04DFFC254A9B4A05999--