Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fiNLX-0005Er-S8 for pgsql-docs@arkaria.postgresql.org; Wed, 25 Jul 2018 17:13:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fiNLV-0001UH-0u for pgsql-docs@arkaria.postgresql.org; Wed, 25 Jul 2018 17:13:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fiNLU-0001UA-Ri for pgsql-docs@lists.postgresql.org; Wed, 25 Jul 2018 17:13:04 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fiNLN-0000LS-Uu for pgsql-docs@lists.postgresql.org; Wed, 25 Jul 2018 17:13:04 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id w6PHCtWw006669; Wed, 25 Jul 2018 13:12:55 -0400 From: Tom Lane To: postgress@sendthemtomir.com cc: pgsql-docs@lists.postgresql.org Subject: Re: Docs for version 10 incorrectly claim that ~/.pgpass with 0600 perms work. In-reply-to: <153246792915.1402.4290097572382403810@wrigleys.postgresql.org> References: <153246792915.1402.4290097572382403810@wrigleys.postgresql.org> Comments: In-reply-to =?utf-8?q?PG_Doc_comments_form?= message dated "Tue, 24 Jul 2018 21:32:09 -0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <6667.1532538775.1@sss.pgh.pa.us> Date: Wed, 25 Jul 2018 13:12:55 -0400 Message-ID: <6668.1532538775@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk =?utf-8?q?PG_Doc_comments_form?= writes: > .pgpass does not work with 10.4 Works for me. Care to provide a complete example? $ cat $PGDATA/pg_hba.conf ... # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5 ... regression=# create user joe password 'joespw'; CREATE ROLE $ ls -l ~/.pgpass -rw-------. 1 tgl tgl 25 Jul 25 13:09 /home/tgl/.pgpass $ cat ~/.pgpass localhost:*:*:joe:joespw $ psql -U joe -h localhost regression psql (10.4) Type "help" for help. I can replicate your symptoms if there's not actually a matching entry in the .pgpass file ... regards, tom lane