Postgres Pro
Downloads
Home   >   mailing lists

LibPQ doesn't say host=* translates to localhost - Mailing list pgsql-bugs

From David G. Johnston
Subject LibPQ doesn't say host=* translates to localhost
Date
Msg-id CAKFQuwbCeu4X7vwV7SZ8cGUycmKRxGE8YGmPGJof8tP8jgKWfw@mail.gmail.com
Whole thread Raw
Responses Re: LibPQ doesn't say host=* translates to localhost
Re: LibPQ doesn't say host=* translates to localhost
List pgsql-bugs
Tree view
The documentation [0] doesn't say this should work and general networking knowledge leads me to believe it wouldn't [1].

PGHOST='*' psql postgres
psql (17beta1)
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off, ALPN: postgresql)
Type "help" for help.

postgres=# \conninfo
You are connected to database "postgres" as user "davidj" on host "*" (address "127.0.0.1") at port "5432".
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off, ALPN: postgresql)

David J.

[0] https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS

[1]
ping *
ping: src: Temporary failure in name resolution

ping localhost
PING localhost (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.026 ms
64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.031 ms
64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=0.028 ms

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #18500: Detaching a partition with an index manually attached to the parent's index triggers Assert
Next
From: Tom Lane
Date:
Subject: Re: LibPQ doesn't say host=* translates to localhost