| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | nanaska_91(at)mail(dot)ru |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #13463: fatal 28000 no pg_hba.conf entry for host |
| Date: | 2015-06-24 00:17:56 |
| Message-ID: | 15865.1435105076@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
nanaska_91(at)mail(dot)ru writes:
> I can't connect to remote PostgreSQL database: error "28000 no pg_hba.conf
> entry for host" occurs.
> I've opened port 5432 in Firewall, my pg_hba.conf file looks like:
> # IPv4 local connections:
> hostnossl all all 0.0.0.0/0 md5
> # IPv6 local connections:
> host all all ::1/128 md5
Most likely bet seems to be that your remote connection is coming in over
IPv6. You're allowing IPv6 connections only from localhost in this
configuration.
Another possibility is that the client is trying to use SSL. By default
I think most clients would fall back to non-SSL after failing, but maybe
you have it set up not to.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2015-06-24 00:28:52 | Re: BUG #13464: Optimizer fails to use partial index on boolean when selected via "IS" operator. |
| Previous Message | corey.huinker | 2015-06-24 00:08:36 | BUG #13464: Optimizer fails to use partial index on boolean when selected via "IS" operator. |