[ADMIN] Re: listen_addresses = '*' postgresql 9.5 does not allow localconnect

David G Johnston wrote
> On Saturday, June 3, 2017, kschindl <

> chuck666xx@

> > 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.