Postgres

[Hershel Fisch]

On 2/7/05 2:45 PM, "Jan Schenkel" <janschenkel at yahoo.com> wrote:
Thanks, it works with the addition of 255.255.255.255 . My question now if I
want to enable a range of ip's how do I do that instead of putting a whole
lot of lines , like writing
All    all    0.0.0.0   255.255.255.255  trust
or leaving it blank
All    all              255.255.255.255  trust
would work?
Hershel

> --- Hershel Fisch <hershrev at realtorsgroup.us> wrote:
>> Hi all I'm trying to connect to  my postgres 8.0
>> server on a osx 10.3
>> 
>> 
>> This is a copy from the pg_hpa.con file
>> 
>> 
>> # TYPE  DATABASE    USER        CIDR-ADDRESS
>>  METHOD
>> 
>> # "local" is for Unix domain socket connections only
>> local   all         all
>>  trust
>> # IPv4 local connections:
>> host    all         all         127.0.0.1/32
>>  trust
>> 
>> host    all        all        192.168.1.101
>> trust  # this is the
>> line I added .
>> 
>> # IPv6 local connections:
>> host    all         all         ::1/128
>>  trust
>> 
>> The error " FATAL: missing or erroneous pg_hba.conf
>> file."
>> Thanks a mill.
>> Ps I reinstalled postgres clean.
>> Thanks , Hershel
>> 
> 
> Hi Hershel,
> 
> I think you forgot to add the subnet-mask at the end
> of that IP-address 192.168.1.101 -- I think that ought
> to be /24 but I'm not good with this sort of
> calculations. However, there are calculators on the
> internet.
> 
> Hope this helped,
> 
> Jan Schenkel.
> 
> =====
> Quartam - Tools for Revolution
> <http://www.quartam.com>
> 
> =====
> "As we grow older, we grow both wiser and more foolish at the same time."  (La
> Rochefoucauld)
> 
> 
> 
> __________________________________
> Do you Yahoo!? 
> The all-new My Yahoo! - What will yours do?
> http://my.yahoo.com
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution