Re: Host name in .pgpass

/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.
>> On March 29, 2023 10:16 AM Ron <ronljohnsonjr(at)gmail(dot)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.

--
Born in Arizona, moved to Babylonia.