Thread: pgpass hostname and IP address
(8.4 and 9.2, but soon to 9.6) If we sometimes access a db server by IP address, and sometimes by hostname, must we have two entries for each server+user (one with the hostname and the other with IP address), or is there a way to put them both on the same line? -- Angular momentum makes the world go 'round.
On Friday, March 9, 2018, Ron Johnson <ron.l.johnson@cox.net> wrote:
(8.4 and 9.2, but soon to 9.6)
If we sometimes access a db server by IP address, and sometimes by hostname, must we have two entries for each server+user (one with the hostname and the other with IP address), or is there a way to put them both on the same lin
So unless you can make a wildcard work you are stuck with two separate lines.
David J.
On 03/09/2018 10:26 PM, David G. Johnston wrote:
On Friday, March 9, 2018, Ron Johnson <ron.l.johnson@cox.net> wrote:(8.4 and 9.2, but soon to 9.6)
If we sometimes access a db server by IP address, and sometimes by hostname, must we have two entries for each server+user (one with the hostname and the other with IP address), or is there a way to put them both on the same linSo unless you can make a wildcard work you are stuck with two separate lines.
Yeah, I read that (well, the ones for my ancient versions), but hoped there might be something I missed, or some obscure and clever trick.
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.
On 03/09/2018 08:19 PM, Ron Johnson wrote: > (8.4 and 9.2, but soon to 9.6) > > If we sometimes access a db server by IP address, and sometimes by > hostname, must we have two entries for each server+user (one with the > hostname and the other with IP address), or is there a way to put them > both on the same line? > Not with .pgpass, though there is the service file method: https://www.postgresql.org/docs/9.6/static/libpq-pgservice.html https://www.postgresql.org/docs/10/static/libpq-connect.html#LIBPQ-CONNSTRING service Service name to use for additional parameters. It specifies a service name in pg_service.conf that holds additional connection parameters. This allows applications to specify only a service name so connection parameters can be centrally maintained. See Section 33.16. -- Adrian Klaver adrian.klaver@aklaver.com
On 03/09/2018 11:11 PM, Adrian Klaver wrote: > On 03/09/2018 08:19 PM, Ron Johnson wrote: >> (8.4 and 9.2, but soon to 9.6) >> >> If we sometimes access a db server by IP address, and sometimes by >> hostname, must we have two entries for each server+user (one with the >> hostname and the other with IP address), or is there a way to put them >> both on the same line? >> > > Not with .pgpass, though there is the service file method: > > https://www.postgresql.org/docs/9.6/static/libpq-pgservice.html > > https://www.postgresql.org/docs/10/static/libpq-connect.html#LIBPQ-CONNSTRING > > service > > Service name to use for additional parameters. It specifies a service > name in pg_service.conf that holds additional connection parameters. This > allows applications to specify only a service name so connection > parameters can be centrally maintained. See Section 33.16. That looks promising. -- Angular momentum makes the world go 'round.