From: Rossi, Maria <maria.rossi@jackson.com>
To: 'David G. Johnston' <david.g.johnston@gmail.com>
Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Re: Logging on without prompt for password
Date: Tue, 20 Oct 2015 16:15:14 +0000
Message-ID: <c8d74f38c3a443dea0907646a37c5134@DC01PXMBP007.jacksonnational.com> (raw)
In-Reply-To: <CAKFQuwYCGZ5HS7DUKxZR_1aP1EQRXnT9JMmyiaE5-B25ScyMTA@mail.gmail.com>
References: <c30f3796621147e2940b48745b5acb63@DC01PXMBP007.jacksonnational.com>
<CAKFQuwYCGZ5HS7DUKxZR_1aP1EQRXnT9JMmyiaE5-B25ScyMTA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Here’s what the automated discovery is using:
/usr/pgsql-9.3/bin/pg_dumpall" -U bmcap01 -s -x
And it got this error:
pg_dumpall: could not connect to database "template1": could not connect to server: No such file or directory
Then, I retried the pg_dumpall with the –p (for port#) and it prompted for the password.
Thanks.
Maria A Rossi
Database Administration
PGDS (US)
email: maria.rossi@jackson.com
cell phone: 517.256.4392
work phone: 517.367.3099
work phone extension: 23099
From: David G. Johnston [mailto:david.g.johnston@gmail.com]
Sent: Tuesday, October 20, 2015 12:07 PM
To: Rossi, Maria <maria.rossi@jackson.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Logging on without prompt for password
On Tue, Oct 20, 2015 at 10:38 AM, Rossi, Maria <maria.rossi@jackson.com<mailto:maria.rossi@jackson.com>> wrote:
Is there a way of enabling a user to logon without being prompted for password? 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.
In this situation you would have a single line for each cluster in the .pgpass file.
And at the pg_hba.conf file, the id already has ‘trust’ method, but it is still being prompted for password.
We can give better advice if you provide the command line invocations you are using.
David J.
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: maria.rossi@jackson.com, david.g.johnston@gmail.com
Subject: Re: Logging on without prompt for password
In-Reply-To: <c8d74f38c3a443dea0907646a37c5134@DC01PXMBP007.jacksonnational.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