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

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13463: fatal 28000 no pg_hba.conf entry for host
Date: 2015-06-23 23:28:35
Message-ID: 5589EBA3.9040104@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 6/23/2015 9:09 AM, nanaska_91(at)mail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message corey.huinker 2015-06-24 00:08:36 BUG #13464: Optimizer fails to use partial index on boolean when selected via "IS" operator.
Previous Message nanaska_91 2015-06-23 16:09:48 BUG #13463: fatal 28000 no pg_hba.conf entry for host