Re: Error connecting using pgadmin from different computer

From: "Goutam Paruchuri" <gparuchuri(at)oneil(dot)com>
To: "Goutam Paruchuri" <gparuchuri(at)oneil(dot)com>, "Wilson, David" <wilsond(at)epbs(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Error connecting using pgadmin from different computer
Date: 2004-11-10 18:38:18
Message-ID: B2C547DF42419645804F05B54290755ADC7CB9@DAYTONEX.oneilinc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)postgresql(dot)org
> [mailto:pgsql-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.

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-11-10 18:41:38 Re: Error connecting using pgadmin from different computer
Previous Message Oleg Lebedev 2004-11-10 18:33:07 Re: Modifying FK constraints