Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #13463: fatal 28000 no pg_hba.conf entry for host - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #13463: fatal 28000 no pg_hba.conf entry for host
Date
Msg-id 15865.1435105076@sss.pgh.pa.us
Whole thread Raw
In response to BUG #13463: fatal 28000 no pg_hba.conf entry for host  (nanaska_91@mail.ru)
List pgsql-bugs
Tree view 
nanaska_91@mail.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

pgsql-bugs by date:

Previous
From: corey.huinker@gmail.com
Date:
Subject: BUG #13464: Optimizer fails to use partial index on boolean when selected via "IS" operator.
Next
From: Tom Lane
Date:
Subject: Re: BUG #13464: Optimizer fails to use partial index on boolean when selected via "IS" operator.