Hello,

I get an error in my log when connecting to postgres server on Windows.
Postgres version : 8.0.0-beta4

LOG TEXT

2004-11-10 11:22:47 LOG: invalid entry in file "C:/Program
Files/PostgreSQL/8.0.0-beta4/data/pg_hba.conf" at line 64, token
"192.168.2.1/254"
2004-11-10 11:22:47 FATAL: missing or erroneous pg_hba.conf file
2004-11-10 11:22:47 HINT: See server log for details.

Configuration file pg_hba.conf

host all all 192.168.2.1/254 md5
host all all 127.0.0.1/32 md5

Any ideas how to fix it ??

Thanks !
Goutam




Confidentiality Notice
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Goutam Paruchuri wrote:

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

My understanding was it means ip range of 1 to 254.

192.168.2.1 to 192.168.1.254






Confidentiality Notice
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

The IP of the client machine aim connecting from is 192.168.2.123
Which is greater than 32.

Thanks !
- Goutam



Confidentiality Notice
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Goutam Paruchuri wrote:
No, it refers to the number of bits. You can use either of:
192.168.2.0 255.255.255.0
192.168.2.0/24
Both of these cover the range:
192.168.2.1 - 192.168.1.255

Might be worth searching for a network howto on CIDR subnet formats.
--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Its works if I specify the ipaddress of each client which is being
connecting to the server.
Its hard to do it on a DHCP network . Any roundabouts ?
- Goutam


Confidentiality Notice
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster