Re: pgpass hostname and IP address

[Ron Johnson <ron.l.johnson@xxxxxxx>]

On 03/09/2018 10:26 PM, David G. Johnston wrote:

On Friday, March 9, 2018, Ron Johnson <ron.l.johnson@xxxxxxx> 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

 https://www.postgresql.org/docs/10/static/libpq-pgpass.html

So 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.