Thread: BUG #13463: fatal 28000 no pg_hba.conf entry for host

BUG #13463: fatal 28000 no pg_hba.conf entry for host

From
nanaska_91@mail.ru
Date:
The following bug has been logged on the website:

Bug reference:      13463
Logged by:          Anastasiia
Email address:      nanaska_91@mail.ru
PostgreSQL version: 9.4.0
Operating system:   Windows Server 2012 R2
Description:

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:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
hostnossl     all     all     0.0.0.0/0     md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#host    replication     postgres        127.0.0.1/32            md5
#host    replication     postgres        ::1/128                 md5

But I can't connect anyway. What should I do? Please, help!

Thanks!

Re: BUG #13463: fatal 28000 no pg_hba.conf entry for host

From
John R Pierce
Date:
On 6/23/2015 9:09 AM, nanaska_91@mail.ru wrote:
> 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:

what is the listen_addresses parameter in postgresql.conf ?  the default
is to listen to localhost only.   change it to...

listen_addresses = '*'

and restart postgresql to take effect.



--
john r pierce, recycling bits in santa cruz

Re: BUG #13463: fatal 28000 no pg_hba.conf entry for host

From
Tom Lane
Date:
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