Re: fully qualified domain names and .pgpass - Mailing list pgsql-general

On Tue, Oct 4, 2022 at 1:02 PM Ron <ronljohnsonjr@gmail.com> wrote:
>
> Sometimes (both interactively and via script) I access a remote Pg server
> via just the bare host name "foobar", and other times via the FQDN
> "foobar.example.com".
>
> I've only been able to get this to work by having two lines in the .pgpass file:
>
> foobar:5432:postgres:Allegedly.Strong.Password
> foobar.example.com:5432:postgres:Allegedly.Strong.Password
>
> But I'd rather have only one line.  Is there any way to do that?

This is not a FQDN:

> "foobar.example.com".

A FQDN ends in dot '.' The dot denotes the top of the dns tree. So a
FQDN for the host would be:

    foobar.example.com.

Anyone who tells you any different has not read W. Richard Stevens :)

Jeff