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.
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 |