From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Host name in .pgpass
Date: Wed, 29 Mar 2023 09:28:29 -0500
Message-ID: <d8f99c38-1002-5df1-3ebe-49176c811edc@gmail.com> (raw)
In-Reply-To: <342987862.335875.1680099854060@webmailb.networksolutionsemail.com>
References: <a5b3740b-a665-7afe-052b-4382d6daf733@gmail.com>
<342987862.335875.1680099854060@webmailb.networksolutionsemail.com>
/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@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.
--
Born in Arizona, moved to Babylonia.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Host name in .pgpass
In-Reply-To: <d8f99c38-1002-5df1-3ebe-49176c811edc@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox