pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rossi, Maria <maria.rossi@jackson.com>
To: Glauco Torres <torres.glauco@gmail.com>
Cc: 'David G. Johnston' <david.g.johnston@gmail.com>
Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Cc: 'scottm@openscg.com' <scottm@openscg.com>
Subject: Re: Logging on without prompt for password
Date: Tue, 20 Oct 2015 17:44:21 +0000
Message-ID: <fd4443c88fb64c64911f0c2da8251816@DC01PXMBP007.jacksonnational.com> (raw)
In-Reply-To: <CAMd+QORnXHgRzZ_xLCEHDj5n0ZSzB4GeORSvs=op6546gQU3Og@mail.gmail.com>
References: <c30f3796621147e2940b48745b5acb63@DC01PXMBP007.jacksonnational.com>
	<CAKFQuwYCGZ5HS7DUKxZR_1aP1EQRXnT9JMmyiaE5-B25ScyMTA@mail.gmail.com>
	<c8d74f38c3a443dea0907646a37c5134@DC01PXMBP007.jacksonnational.com>
	<CAMd+QORe_S2Zq2SCRHOmapHv+uFTahgVJQ_msmxN_jcswr+uiw@mail.gmail.com>
	<CAMd+QORnXHgRzZ_xLCEHDj5n0ZSzB4GeORSvs=op6546gQU3Og@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

Hi,

We will  try the .pgpass file at the user’s home directory, using *.* for port  as suggested by Scott Mead.    This way I don’t  have to worry about setting the  PGPASSWORD env var for the user.

I still need to create a role for the user, correct?  It needs admin to be able to rung pg_dumpall.

Thanks everyone.



Maria A Rossi
Database Administration
PGDS (US)
email: maria.rossi@us.pgds.com<mailto:maria.rossi@us.pgds.com>
cell phone: 517.256.4392
work phone: 517.367.3099
work phone extension: 23099

From: Glauco Torres [mailto:torres.glauco@gmail.com]
Sent: Tuesday, October 20, 2015 12:19 PM
To: Rossi, Maria <maria.rossi@jackson.com>
Cc: David G. Johnston <david.g.johnston@gmail.com>; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Logging on without prompt for password



2015-10-20 14:17 GMT-02:00 Glauco Torres <torres.glauco@gmail.com<mailto:torres.glauco@gmail.com>>:


2015-10-20 14:15 GMT-02:00 Rossi, Maria <maria.rossi@jackson.com<mailto:maria.rossi@jackson.com>>:

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.



Are you using pgbouncer?


view thread (13+ messages)  latest in thread

Message-ID: <fd4443c88fb64c64911f0c2da8251816@DC01PXMBP007.jacksonnational.com>
Permalink:  ../fd4443c88fb64c64911f0c2da8251816@DC01PXMBP007.jacksonnational.com/
Also on:    postgresql.org/message-id/fd4443c88fb64c64911f0c2da8251816@DC01PXMBP007.jacksonnational.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: maria.rossi@jackson.com, torres.glauco@gmail.com, david.g.johnston@gmail.com, scottm@openscg.com
  Subject: Re: Logging on without prompt for password
  In-Reply-To: <fd4443c88fb64c64911f0c2da8251816@DC01PXMBP007.jacksonnational.com>
  References: <c30f3796621147e2940b48745b5acb63@DC01PXMBP007.jacksonnational.com> <CAKFQuwYCGZ5HS7DUKxZR_1aP1EQRXnT9JMmyiaE5-B25ScyMTA@mail.gmail.com> <c8d74f38c3a443dea0907646a37c5134@DC01PXMBP007.jacksonnational.com> <CAMd+QORe_S2Zq2SCRHOmapHv+uFTahgVJQ_msmxN_jcswr+uiw@mail.gmail.com> <CAMd+QORnXHgRzZ_xLCEHDj5n0ZSzB4GeORSvs=op6546gQU3Og@mail.gmail.com> <fd4443c88fb64c64911f0c2da8251816@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