Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lsEqQ-0003JT-VN for pgsql-docs@arkaria.postgresql.org; Sun, 13 Jun 2021 01:23:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lsEqP-0003CJ-FO for pgsql-docs@arkaria.postgresql.org; Sun, 13 Jun 2021 01:23:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lsEqP-0003CB-9Q for pgsql-docs@lists.postgresql.org; Sun, 13 Jun 2021 01:23:21 +0000 Received: from aws.mailpen.com ([52.43.43.172] helo=aws2.mailpen.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lsEqL-00012Z-H6 for pgsql-docs@lists.postgresql.org; Sun, 13 Jun 2021 01:23:20 +0000 Received: from [172.20.70.208] (unknown [50.35.114.95]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by aws2.mailpen.com (Postfix) with ESMTPSA id 3DD8BC54064; Sat, 12 Jun 2021 18:23:15 -0700 (PDT) Subject: Re: Clarification needed To: Tom Lane Cc: pgsql-docs@lists.postgresql.org References: <162347037363.14468.17800688183418013591@wrigleys.postgresql.org> <2443003.1623527262@sss.pgh.pa.us> From: "Dean Gibson (DB Administrator)" Organization: UltiMeth Systems Message-ID: <5c0f812c-719c-b78b-097d-03d2e4e6cc03@mailpen.com> Date: Sat, 12 Jun 2021 18:23:15 -0700 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Thunderbird/78.11.0 MIME-Version: 1.0 In-Reply-To: <2443003.1623527262@sss.pgh.pa.us> Content-Type: multipart/alternative; boundary="------------5012AE1FB8306A94A7BF67ED" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------5012AE1FB8306A94A7BF67ED Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit On 2021-06-12 12:47, Tom Lane wrote: > PG Doc comments form writes: >> Are the fields in the .pgpass file case sensitive by default? > Yes. User name and database name clearly must preserve case > distinctions. Maybe there is an argument for the host name > to be matched case-insensitively, but I think it could cause > problems when the host string is a socket path name. > > regards, tom lane No argument from me; I like it the way it is. I just posted the comment as a potential update to the web page. Unless it is covered elsewhere. --------------5012AE1FB8306A94A7BF67ED Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

On 2021-06-12 12:47, Tom Lane wrote:

PG Doc comments form <noreply@postgresql.org> writes:

Are the fields in the .pgpass file case sensitive by default?

Yes.  User name and database name clearly must preserve case
distinctions.  Maybe there is an argument for the host name
to be matched case-insensitively, but I think it could cause
problems when the host string is a socket path name.

			regards, tom lane

No argument from me; I like it the way it is. I just posted the comment as a potential update to the web page. Unless it is covered elsewhere.
--------------5012AE1FB8306A94A7BF67ED--