Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dHOaQ-0005a6-Ij for pgsql-admin@arkaria.postgresql.org; Sun, 04 Jun 2017 06:00:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dHOaP-0004Y1-Fg for pgsql-admin@arkaria.postgresql.org; Sun, 04 Jun 2017 06:00:25 +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.84_2) (envelope-from ) id 1dHOYd-0001Hk-FA for pgsql-admin@postgresql.org; Sun, 04 Jun 2017 05:58:35 +0000 Received: from mimolette.dalibo.net ([212.85.157.144] helo=mail.dalibo.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dHOYV-0003hF-Gj for pgsql-admin@postgresql.org; Sun, 04 Jun 2017 05:58:34 +0000 Received: from nol.local (unknown [78.192.238.147]) by mail.dalibo.com (Postfix) with ESMTPSA id 5FD052C0619; Sun, 4 Jun 2017 07:58:26 +0200 (CEST) Subject: Re: Re: listen_addresses = '*' postgresql 9.5 does not allow local connect To: kschindl , pgsql-admin@postgresql.org References: <1496544711321-5964669.post@n3.nabble.com> <16591.1496553637@sss.pgh.pa.us> <1496554966743-5964682.post@n3.nabble.com> From: Julien Rouhaud Message-ID: <805878dc-7c73-78fe-43f3-b6435c799322@dalibo.com> Date: Sun, 4 Jun 2017 07:57:25 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.1.0 MIME-Version: 1.0 In-Reply-To: <1496554966743-5964682.post@n3.nabble.com> Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On 04/06/2017 07:42, kschindl wrote: > That is what the log says: > 2017-06-04 10:25:38 ICT [938-1] LOG: invalid connection type > "listen_addresses" > 2017-06-04 10:25:38 ICT [938-2] CONTEXT: line 74 of configuration file > "/etc/postgresql/9.5/main/pg_hba.conf" > 2017-06-04 10:25:38 ICT [938-3] FATAL: could not load pg_hba.conf > > That is line 74 > listen_addresses = '*' > > copied from manual > > so i am lost listen_addresses, like other configuration options, has to be configured in postgresql.conf, not pg_hba.conf. -- Julien Rouhaud http://dalibo.com - http://dalibo.org -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin