Re: Error connecting using pgadmin from different computer

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

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of
Goutam Paruchuri
Sent: Wednesday, November 10, 2004 1:12 PM
To: Wilson, David
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Error connecting using pgadmin from
different computer

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

192.168.2.1 to 192.168.1.254

-----Original Message-----
From: Wilson, David [mailto:wilsond@epbs.com]
Sent: Wednesday, November 10, 2004 12:05 PM
To: Goutam Paruchuri
Subject: RE: [GENERAL] Error connecting using pgadmin from

different

computer !!

Maybe the 254 at the end of the ip address? Should be

between 0 and 32

or
128 according to the text in the pg_hba.conf file. I'm no expert
though :)

-----Original Message-----
From: Goutam Paruchuri [mailto:gparuchuri@oneil.com]
Sent: Wednesday, November 10, 2004 10:32 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Error connecting using pgadmin from different
computer !!
Importance: High

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

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 7: don't forget to increase your free space map settings

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.

"Goutam Paruchuri" <gparuchuri@oneil.com> writes:

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

You're mistaken. /n means an n-bit netmask. /254 is nonsense.
What you probably want is 192.168.2.0/24, which effectively
means "all of 192.168.2.*".

regards, tom lane