Postgres

[Frank D. Engel, Jr.]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

No, it wouldn't.

Let's say you want to enable 192.168.0.x, for example (x is anything in 
0..255):

all   all  192.168.0.0  255.255.255.0  trust

Note: "trust" for a network is a *really* *really* *really* bad idea, 
since it does not demand a password from any user, and anyone can just 
claim to be "postgres" (the database superuser), and the server will 
just "trust" that they are indeed who they claim to be.  You should *at 
least* use "password", or even better use "md5"...

all  all  192.168.0.0  255.255.255.0  md5


Note about Subnet Masks: when comparing two given IP addresses to 
determine if an incoming connection is part of the specified subnet, so 
to speak, both addresses are bitwise ANDed with the subnet mask, and 
the result must match.

So if you really trust the entire world of hackers and virus-writers 
with complete and unrestricted access to your database server:

all  all  0.0.0.0  0.0.0.0  trust


will probably work.

On Feb 7, 2005, at 11:58 PM, Hershel Fisch wrote:

> 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
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
- -----------------------------------------------------------
Frank D. Engel, Jr.  <fde101 at fjrhome.net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten 
Son, that whosoever believeth in him should not perish, but have 
everlasting life.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFCCN9p7aqtWrR9cZoRAsGFAKCEMVI7wSpF7gHgYmZ16unoE5BYNQCfcLGx
XQeR2reyjVYTmzc5ho7SAqI=
=LivA
-----END PGP SIGNATURE-----



___________________________________________________________
$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com