/etc/hosts is not case sensitive, and neither is the value passed via "--hosts=".
Thus, it is completely reasonable that .pgpass be case-insensitive.
On 3/29/23 09:24, c Campo wrote:
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.
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.
--
Born in Arizona, moved to Babylonia.