Re: listen_addresses = '*' postgresql 9.5 does not allow local connect

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


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



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux