Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fzNRl-00072V-OF for pgsql-sql@arkaria.postgresql.org; Mon, 10 Sep 2018 14:45:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fzNRj-0004ia-4G for pgsql-sql@arkaria.postgresql.org; Mon, 10 Sep 2018 14:45:47 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fzNRi-0004iD-PG; Mon, 10 Sep 2018 14:45:46 +0000 Received: from dc01pesav001.jacksonnational.com ([12.34.36.219]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fzNRd-0007VY-O8; Mon, 10 Sep 2018 14:45:45 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=jackson.com; i=@jackson.com; q=dns/txt; s=Internal; t=1536590741; x=1568126741; h=from:to:subject:date:message-id:mime-version; bh=rRqLKvBMH7XXCd/wlM0oXd8E3c4WOHEi4glfK5JOcZ0=; b=iLYw6wNerV5wyAKtF/ReF3FmotiTaHjzmp+I+X/5KM4ZbTgeNI4TT3ap navr9cBv6eBuemFTjSPZbnVxkxu8jxBa3erPdoxmhDDKhLumopF3aBhKE HFGCOoL9iLP53z+lRNSFJjbt2clN605UA4k5i1u+Mj4OyoaAFK5XwO0LR E=; X-IronPort-AV: E=Sophos;i="5.53,356,1531800000"; d="scan'208,217";a="27722384" Received: from dc0xpdlpv002.jacksonnational.com (HELO DC01PXMBP007.jacksonnational.com) ([10.5.49.47]) by DC01PESAV001.jacksonnational.com with ESMTP; 10 Sep 2018 10:45:39 -0400 Received: from DC03PXMBP003.jacksonnational.com (10.12.105.32) by DC01PXMBP007.jacksonnational.com (10.8.105.36) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Mon, 10 Sep 2018 10:45:38 -0400 Received: from DC03PXMBP003.jacksonnational.com ([10.12.105.32]) by DC03PXMBP003.jacksonnational.com ([10.12.105.32]) with mapi id 15.00.1367.000; Mon, 10 Sep 2018 10:45:38 -0400 From: "Rossi, Maria" To: "'pgsql-sql@lists.postgresql.org'" , "'pgsql-novice@lists.postgresql.org'" Subject: md5 and trust and pg_hba.conf Thread-Topic: md5 and trust and pg_hba.conf Thread-Index: AdRJFNwTPwLNPvCxSpW8WqeiWxuJkg== Date: Mon, 10 Sep 2018 14:45:38 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.12.16.10] x-tm-as-product-ver: SMEX-12.5.0.1300-8.5.1010-24086.000 x-tm-as-result: No-32.424200-5.000000-11 x-tmase-matchedrid: GDE3Z+tCY2RHW+94FA8JF8K1Ib9JAALxrogFtKd/P7eW+zaNLK605Oyg QWdkAVMs0Nt5/j+aSDEUI4s17Ql301mKiy1F9pgLQesjq8XPMbt3Bf9JIqsoeEbaqUVvLFsixNx vPmI6N152+AZuxakJy1x59CtgmyHsU6L1rmVqlpEV271HorxLNC6GDroi1vrli2KmUKycrQlLCM Yt+C2yUm99qnN13BnND7tlU8zCTpOI0KPyMNrNUhiTH2TyLmz+nophrTcsI7ayy072phvASaPFj JEFr+olqSmmA3WmgxkvM/mydp5vVKi/iDMTcIUOj1BDBV+OaYmSTDBFkfyoGRsaON87dwg/gBYY sUnZffd+3BndfXUhXQ== x-tm-as-user-approved-sender: Yes x-tm-as-user-blocked-sender: No x-tmase-result: 11-32.424200-5.000000 x-tmase-version: SMEX-12.5.0.1300-8.5.1010-24086.000 Content-Type: multipart/alternative; boundary="_000_daa1d04cccf6417e83a3f52cd8ab1781DC03PXMBP003jacksonnati_" MIME-Version: 1.0 X-CFilter-Loop: Reflected List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_daa1d04cccf6417e83a3f52cd8ab1781DC03PXMBP003jacksonnati_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, Question on pg_hba.conf. I have these entries: host all psgdba localhost trust host all psgdba 127.0.0.1/32 trust host all gd07 localhost trust host all gd07 127.0.0.1/32 trust Command to logon to Postgres: /usr/pgsql-9.3/bin/psql -d postgres If I am logged on 'gd07' at the server , it lets me log-on to Postgres wit= hout prompting for password If I am logged on as 'psgdba', it prompts for password. As you can see, both have 'trust', but 'gd07' is the instance owner. Why does 'psgdba' prompts? What I am missing? Your help would be much appreciated. Thanks. Maria --_000_daa1d04cccf6417e83a3f52cd8ab1781DC03PXMBP003jacksonnati_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

Question on pg_hba.conf.  I have these entries:=

 

host    all    &n= bsp;        psgdba   &nbs= p;       localhost    &nb= sp;      trust

host    all    &n= bsp;        psgdba   &nbs= p;       127.0.0.1/32    =         trust

host    all    &n= bsp;        gd07    =        localhost     = ;           trust

host    all    &n= bsp;        gd07    =         127.0.0.1/32   &n= bsp;       trust

 

 

Command to logon to Postgres:

/usr/pgsql-9.3/bin/psql -d postgres

 

If I am logged on ‘gd07’  at the se= rver , it lets me log-on to Postgres without prompting for password

If I am logged on as ‘psgdba’, it prompt= s for password.

As you can see, both have ‘trust’, but &= #8216;gd07’ is the instance owner.

 

Why does ‘psgdba’ prompts?  What I = am missing?

Your help would be much appreciated.

 

Thanks.

Maria

 

--_000_daa1d04cccf6417e83a3f52cd8ab1781DC03PXMBP003jacksonnati_--