Re: Error connecting using pgadmin from different computer

#1

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

192.168.2.1 to 192.168.1.254

Quote:

-----Original Message-----
From: Wilson, David [mailto:wilsond (AT) epbs (DOT) 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 (AT) oneil (DOT) com]
Sent: Wednesday, November 10, 2004 10:32 AM
To: pgsql-general (AT) postgresql (DOT) 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

#2

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

Quote:

-----Original Message-----
From: pgsql-general-owner (AT) postgresql (DOT) org
[mailto

gsql-general-owner (AT) postgresql (DOT) org] On Behalf Of
Goutam Paruchuri
Sent: Wednesday, November 10, 2004 1:12 PM
To: Wilson, David
Cc: pgsql-general (AT) postgresql (DOT) 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 (AT) epbs (DOT) 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 (AT) oneil (DOT) com]
Sent: Wednesday, November 10, 2004 10:32 AM
To: pgsql-general (AT) postgresql (DOT) 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.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#3

"Goutam Paruchuri" <gparuchuri (AT) oneil (DOT) com> writes:

Quote:

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

---------------------------(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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Error connecting using pgadmin from different computer

comp.databases.postgresql.general comp.databases.postgresql.general

Re: Error connecting using pgadmin from different computer - 11-10-2004 , 12:12 PM

Re: Error connecting using pgadmin from different computer - 11-10-2004 , 12:38 PM

Re: Error connecting using pgadmin from different computer - 11-10-2004 , 12:41 PM