Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Re: listen_addresses = '*' postgresql 9.5 does not allowlocal connect - Mailing list pgsql-admin

From Steven Chang
Subject Re: [ADMIN] Re: listen_addresses = '*' postgresql 9.5 does not allowlocal connect
Date
Msg-id CAEJt7k3UQ6VA+MJ_=4t2f6fkCyqzk07Mz1PeSvOhGzZms-c3OQ@mail.gmail.com
Whole thread Raw
In response to [ADMIN] Re: listen_addresses = '*' postgresql 9.5 does not allow localconnect  (kschindl <chuck666xx@gmail.com>)
List pgsql-admin
Tree view
Hello,

  check your pg_hba.conf.
here is my record :
# "local" is for Unix domain socket connections only
local   all             all                                     md5

then testing connection :
oot@jessie:/etc/postgresql/9.6/main6# psql -U postgres -p 5437
Password for user postgres:
psql (9.6.3)
Type "help" for help.
postgres=#


Steven


2017-06-04 15:11 GMT+08:00 kschindl <chuck666xx@gmail.com>:
thx that was it.




--
View this message in context: http://www.postgresql-archive.org/listen-addresses-postgresql-9-5-does-not-allow-local-connect-tp5964669p5964685.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


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

pgsql-admin by date:

Previous
From: kschindl
Date:
Subject: [ADMIN] Re: listen_addresses = '*' postgresql 9.5 does not allow localconnect
Next
From: Harold Falkmeyer
Date:
Subject: [ADMIN] VACUUM ANALYZE Issues