From: | Steven Chang <stevenchang1213(at)gmail(dot)com> |
---|---|
To: | kschindl <chuck666xx(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Re: listen_addresses = '*' postgresql 9.5 does not allow local connect |
Date: | 2017-06-04 09:19:44 |
Message-ID: | CAEJt7k3UQ6VA+MJ_=4t2f6fkCyqzk07Mz1PeSvOhGzZms-c3OQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)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(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Harold Falkmeyer | 2017-06-05 21:20:12 | VACUUM ANALYZE Issues |
Previous Message | kschindl | 2017-06-04 07:11:49 | Re: listen_addresses = '*' postgresql 9.5 does not allow local connect |