Re: Missing or erroneus pg_hba.conf file - Mailing list pgsql-admin

From jseymour@linxnet.com (Jim Seymour)
Subject Re: Missing or erroneus pg_hba.conf file
Date
Msg-id 20040620120415.952C44311@jimsun.linxnet.com
Whole thread Raw
In response to Missing or erroneus pg_hba.conf file  (Sandro Ribeiro - Claro RS - <Sandro.Ribeiro@claro.com.br>)
List pgsql-admin
Sandro Ribeiro - Claro RS - <Sandro.Ribeiro@claro.com.br> wrote:
>
>
> Hello!
>
> My server is working with pgsql 7.4.2 and Unix Solaris 8. Well, when a try a
> connection from my PC to the server, using pgAdminIII, I get the message
> above. This is my pg_hba.conf file:
>
> local   all         all                                             trust
> # IPv4-style local connections:
> host    all         all         127.0.0.1         255.255.255.255   trust
> host    all         all         172.17.0.0        255.255.0.0       trust
[snip]

There is an issue, as yet not understood (last I knew), with some
versions of (?) Solaris and IP-address-with-netmask configuration
entries in pg_hba.conf.  Try changing your two "host" lines to:

# IPv4-style local connections:
host    all         all         127.0.0.1/32      trust
host    all         all         172.17.0.0/16     trust

and see if that doesn't resolve your problem.

Jim

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: problem with 7.4.2 for RH-9
Next
From: Tom Lane
Date:
Subject: Re: Missing or erroneus pg_hba.conf file