Subject: Re: Re: listen_addresses = '*' postgresql 9.5 does not allow
 local connect
To: pgsql-admin@postgresql.org
References: <1496544711321-5964669.post@n3.nabble.com>
 <CAKFQuwYQhrMP95AMR7Pt0nAXgBkbADaCOWR2HMWbv_L7gvp59Q@mail.gmail.com>
 <1496546846616-5964671.post@n3.nabble.com>
From: =?UTF-8?B?0JzQuNGF0LDQuNC7INCo0YPRgNGD0YLQvtCy?=
 <m.shurutov@postgrespro.ru>
Message-ID: <25ae79cd-7824-648a-db89-216f6b1b6311@postgrespro.ru>
Date: Sun, 4 Jun 2017 06:39:27 +0300
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.8.0
MIME-Version: 1.0
In-Reply-To: <1496546846616-5964671.post@n3.nabble.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Please set listen_addresses parameter and show output of command

netstat -ltxn|grep 5432

04.06.2017 06:27, kschindl пишет:
> David G Johnston wrote
>> On Saturday, June 3, 2017, kschindl &lt;
> 
>> chuck666xx@
> 
>> &gt; wrote:
>>
>> Please show some psql commands and resultant error messages.
>>
>> David J.
> 
> kschindl@BelgarathUbuntu:~$ sudo -u postgres psql 
> psql: could not connect to server: No such file or directory
> 	Is the server running locally and accepting
> 	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
> 
> Pgadmin:
> Server doesn't listen
> The server doesn't accept connections: the connection library reports 
> could not connect to server: Connection refused Is the server running on
> host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432? 
> 
> as soon as i remove the listen_addresses it works and connects on port 5432
> 
> 
> 
> --
> View this message in context: http://www.postgresql-archive.org/listen-addresses-postgresql-9-5-does-not-allow-local-connect-tp5964669p5964671.html
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
> 
> 

-- 
WBR, Michail Shurutov
Postgres Professional: http://www.postgrespro.ru
The Russian Postgres Company


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin