Re: pg_hba.conf

On Tue, Apr 27, 2010 at 6:42 AM, <jkunkel(at)laurcat(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>