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

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
>

In response to

Browse pgsql-admin by date

  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