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 < > >> 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. > > -- WBR, Michail Shurutov Postgres Professional: http://www.postgrespro.ru The Russian Postgres Company -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
