Re: Error connecting using pgadmin from different computer

Поиск
Список
Период
Сортировка
От Goutam Paruchuri
Тема Re: Error connecting using pgadmin from different computer
Дата
Msg-id B2C547DF42419645804F05B54290755ADC7CB9@DAYTONEX.oneilinc.net
обсуждение исходный текст
Список 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@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
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. 


В списке pgsql-general по дате отправления:

Предыдущее
От: "Oleg Lebedev"
Дата:
Сообщение: Re: Modifying FK constraints
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Error connecting using pgadmin from different computer