469,313 Members | 2,550 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,313 developers. It's quick & easy.

Error connecting using pgadmin from different computer !!

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

Nov 23 '05 #1
1 5333
On Thu, 11 Nov 2004 03:31 am, Goutam Paruchuri wrote:
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 /254 <- that is not a valid subnet mask. /0 - /32 are valid, did you mean /31?
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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Egyd Csaba | last post: by
1 post views Thread by Dishaa V | last post: by
13 posts views Thread by Edward Mitchell | last post: by
2 posts views Thread by Juan Jose Costello Levien | last post: by
5 posts views Thread by Raymond O'Donnell | last post: by
1 post views Thread by John Shadel | last post: by
5 posts views Thread by James | last post: by
13 posts views Thread by AAaron123 | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.