Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZoZIS-0004lD-N0 for pgsql-admin@arkaria.postgresql.org; Tue, 20 Oct 2015 15:57:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZoZIR-0000NS-GD for pgsql-admin@arkaria.postgresql.org; Tue, 20 Oct 2015 15:57:55 +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_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZoY3n-00080c-4g for pgsql-admin@postgresql.org; Tue, 20 Oct 2015 14:38:43 +0000 Received: from mgap1c-mgmt.jacksonnational.com ([12.34.36.38]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_CAMELLIA_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZoY3c-0001ma-RO for pgsql-admin@postgresql.org; Tue, 20 Oct 2015 14:38:41 +0000 X-IronPort-AV: E=Sophos;i="5.17,707,1437451200"; d="scan'208,217";a="227655792" Received: from vtunpep1c.jacksonnational.com (HELO DC03PXMBP003.jacksonnational.com) ([10.12.111.24]) by mgap1c-mgmt.jacksonnational.com with ESMTP; 20 Oct 2015 10:38:28 -0400 Received: from DC01PXMBP007.jacksonnational.com (10.8.105.36) by DC03PXMBP003.jacksonnational.com (10.12.105.32) with Microsoft SMTP Server (TLS) id 15.0.1044.25; Tue, 20 Oct 2015 10:38:27 -0400 Received: from DC01PXMBP007.jacksonnational.com ([10.8.105.36]) by DC01PXMBP007.jacksonnational.com ([10.8.105.36]) with mapi id 15.00.1044.021; Tue, 20 Oct 2015 10:38:27 -0400 From: "Rossi, Maria" To: "'pgsql-admin@postgresql.org'" Subject: Logging on without prompt for password Thread-Topic: Logging on without prompt for password Thread-Index: AdELQWPpQzGXFEKyQiSOrVWy+uTkEw== Date: Tue, 20 Oct 2015 14:38:27 +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.10.31.212] x-tm-as-product-ver: SMEX-11.0.0.1251-8.000.1202-21890.007 x-tm-as-result: No--56.578900-0.000000-31 x-tm-as-user-approved-sender: Yes x-tm-as-user-blocked-sender: No Content-Type: multipart/alternative; boundary="_000_c30f3796621147e2940b48745b5acb63DC01PXMBP007jacksonnati_" MIME-Version: 1.0 X-DLP-JNL: Passed X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_000_c30f3796621147e2940b48745b5acb63DC01PXMBP007jacksonnati_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, Is there a way of enabling a user to logon without being prompted for passw= ord? I know there is the .pgpass file, but this file requires the port# = and my server has several postgres clusters with different port#. So, = am not sure if I can use the .pgpass file. And at the pg_hba.conf file, the id already has 'trust' method, but it is = still being prompted for password. This id will be used for automated scanning and needs to run pg_dumpall. Thanks. Maria A Rossi Database Administration PGDS (US) email: maria.rossi@us.pgds.com cell phone: 517.256.4392 work phone: 517.367.3099 work phone extension: 23099 --_000_c30f3796621147e2940b48745b5acb63DC01PXMBP007jacksonnati_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

 

Is there a way of enabling a user to logon without b= eing prompted for password?  I know  there is the .pgpass file,&n= bsp; but this file requires the port#  and my server has several postg= res clusters with different port#.    So,  am  not= sure if I can use the .pgpass file.

 

And at the pg_hba.conf file,  the id already ha= s ‘trust’ method, but it is still being prompted for password.

 

This id will  be used for automated scanning an= d needs to run pg_dumpall.

 

Thanks.

 

Maria A Rossi

Database Administration

PGDS (US)=

email: maria.rossi@us.pgds.com
cell phone: 517.256.4392

work phone: 517.367.3099
work phone extension: 23099
=

 

--_000_c30f3796621147e2940b48745b5acb63DC01PXMBP007jacksonnati_--