Thread: Error connecting using pgadmin from different computer !!

Error connecting using pgadmin from different computer !!

From
"Goutam Paruchuri"
Date:
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
listedin 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
intendedrecipient, is strictly prohibited. 


Re: Error connecting using pgadmin from different computer !!

From
Russell Smith
Date:
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
listedin 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
intendedrecipient, is strictly prohibited. 
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>