On Tue, Apr 27, 2010 at 6:42 AM, <jkun...@laurcat.com> wrote:

> I am putting up a new server on version 8.4.3.  I copied pg_hba.conf
> from a running 8.3.6 system, changing only the public IP address for the
> local machine.
>
> I get the error:
> FATAL: no pg_hba.conf entry for host "209.159.145.248", user "postgres",
> database "arc"
>
> pg_hba.conf contains the line:
>  host    all         all        209.159.145.248      255.255.255.255
> trust
>
>
Hmm, just for giggles, does it work using CIDR syntax:

  host    all         all        209.159.145.248/32    trust

 ?

--Scott

--
Scott Mead
Principal Systems Engineer
EnterpriseDB Corporation
The Enterprise Postgres Company


> Other records work (I can connect from my remote site using pgAdmin,
> just fine), so I know the file is being read by posgres.
>
> Any ideas?
>
> Thanks in advance,
> Jim
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Reply via email to