Content-Type: multipart/alternative;
 boundary="------------9gypzQvL63kSb4hjcTRzjfOY"
Message-ID: <d8f99c38-1002-5df1-3ebe-49176c811edc@gmail.com>
Date: Wed, 29 Mar 2023 09:28:29 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.8.0
Subject: Re: Host name in .pgpass
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: <a5b3740b-a665-7afe-052b-4382d6daf733@gmail.com>
 <342987862.335875.1680099854060@webmailb.networksolutionsemail.com>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: 
 <342987862.335875.1680099854060@webmailb.networksolutionsemail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/d8f99c38-1002-5df1-3ebe-49176c811edc%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------9gypzQvL63kSb4hjcTRzjfOY
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

/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.
--------------9gypzQvL63kSb4hjcTRzjfOY
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    /etc/hosts is not case sensitive, and neither is the value passed
    via "--hosts=".<br>
    <br>
    Thus, it is completely reasonable that .pgpass be case-insensitive.<br>
    <br>
    <div class="moz-cite-prefix">On 3/29/23 09:24, c Campo wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:342987862.335875.1680099854060@webmailb.networksolutionsemail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <meta charset="UTF-8">
      <div> 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. <br>
      </div>
      <blockquote type="cite">
        <div> On March 29, 2023 10:16 AM Ron
          <a class="moz-txt-link-rfc2396E" href="mailto:ronljohnsonjr@gmail.com">&lt;ronljohnsonjr@gmail.com&gt;</a> wrote: </div>
        <div> <br>
        </div>
        <div> <br>
        </div>
        <br>
        <a
          href="https://www.postgresql.org/docs/current/libpq-pgpass.html"
          class="moz-txt-link-freetext" moz-do-not-send="true">https://www.postgresql.org/docs/current/libpq-pgpass.html</a>
        doesn't mention anything about host name case sensitivity, but
        my experience is that the the field <strong>IS</strong> case
        sensitive. <br>
        <br>
        Am I missing some other bit of documentation? <br>
        <br>
        $ psql --host=FISPTAPPGS302a.itocservices.com -c "\q" <br>
        <br>
        $ psql --host=FISPTAPPGS302A.itocservices.com -c "\q" <br>
        Password for user postgres: <br>
        psql: error: fe_sendauth: no password supplied <br>
        <br>
        <br>
        <br>
        <div class="moz-signature"> -- <br>
          Born in Arizona, moved to Babylonia. </div>
      </blockquote>
    </blockquote>
    <br>
    <div class="moz-signature">-- <br>
      Born in Arizona, moved to Babylonia.</div>
  </body>
</html>

--------------9gypzQvL63kSb4hjcTRzjfOY--