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 1ls9bh-0000YR-5C for pgsql-docs@arkaria.postgresql.org; Sat, 12 Jun 2021 19:47:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ls9bf-0001nI-2F for pgsql-docs@arkaria.postgresql.org; Sat, 12 Jun 2021 19:47:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ls9be-0001n9-Sa for pgsql-docs@lists.postgresql.org; Sat, 12 Jun 2021 19:47:46 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ls9bc-0004iy-Hx for pgsql-docs@lists.postgresql.org; Sat, 12 Jun 2021 19:47:46 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 15CJlgqd2443004; Sat, 12 Jun 2021 15:47:42 -0400 From: Tom Lane To: postgresql@mailpen.com cc: pgsql-docs@lists.postgresql.org Subject: Re: Clarification needed In-reply-to: <162347037363.14468.17800688183418013591@wrigleys.postgresql.org> References: <162347037363.14468.17800688183418013591@wrigleys.postgresql.org> Comments: In-reply-to PG Doc comments form message dated "Sat, 12 Jun 2021 03:59:33 -0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2443002.1623527262.1@sss.pgh.pa.us> Date: Sat, 12 Jun 2021 15:47:42 -0400 Message-ID: <2443003.1623527262@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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