Обсуждение: Host name in .pgpass

https://www.postgresql.org/docs/current/libpq-pgpass.html doesn't mention anything about host name case sensitivity, but my experience is that the the field IS case sensitive.

Am I missing some other bit of documentation?

$ psql --host=FISPTAPPGS302a.itocservices.com -c "\q"

$ psql --host=FISPTAPPGS302A.itocservices.com -c "\q"
Password for user postgres:
psql: error: fe_sendauth: no password supplied

/etc/hosts is not case sensitive, and neither is the value passed via "--hosts=".

Thus, it is completely reasonable that .pgpass be case-insensitive.

Since PostgreSQL runs on UNIX/LINUX/Win systems, which ARE case sensitive operating systems, and since PostgreSQL database table field names ARE case sensitive, then I would assume that case sensitivity would carry over to the .pgpass table.

On March 29, 2023 10:16 AM Ron <ronljohnsonjr@gmail.com> wrote:

https://www.postgresql.org/docs/current/libpq-pgpass.html doesn't mention anything about host name case sensitivity, but my experience is that the the field IS case sensitive.

Am I missing some other bit of documentation?

$ psql --host=FISPTAPPGS302a.itocservices.com -c "\q"

$ psql --host=FISPTAPPGS302A.itocservices.com -c "\q"
Password for user postgres:
psql: error: fe_sendauth: no password supplied

--
Born in Arizona, moved to Babylonia.