From: | Mike Alford <mikea(at)syscon-intl(dot)com> |
---|---|
To: | Michael Weaver <mweaver(at)corpusglobe(dot)com> |
Cc: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: ODBC and unknown i.p. |
Date: | 2003-02-11 13:32:17 |
Message-ID: | 200302111828.NAA32423@smtp.syscon-intl.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks. That did the trick. I knew there had to be a simple solution.
At 04:14 PM 2/11/03 +0800, you wrote:
>
> Mike,
> Have you tried adding an entry for the entire Internet?
> eg: IP: 127.0.0.1(could be anything) Mask: 0.0.0.0
>
> Mike.(also)
>
> > -----Original Message-----
> > From: Mike Alford
> [<mailto:mikea(at)syscon-intl(dot)com>mailto:mikea(at)syscon-intl(dot)com]
> > Sent: Monday, 10 February 2003 9:44 PM
> > To: pgsql-admin(at)postgresql(dot)org
> > Subject: [ADMIN] ODBC and unknown i.p.
> >
> >
> > I am using postgres 7.3.1 on a slackware linux server and psqlodbc.exe
> > version 07.02.0005. I am a novice at both linux and postgres
> > administration. We are in the process of converting from a
> > SCO unix server
> > with Ingres1.2 database to the aforementioned linux/postgres
> > server. Our
> > application is distributed to customers around the world and uses ODBC
> > connections in VB applications. With our old system, we only
> > had to be able
> > to connect to the database server through ODBC and
> > user/password security.
> > It appears that there is another level with postgres--namely
> > the addition
> > of entries into pg_hba.conf, which include the i.p.and
> > subnet. Since this
> > is a distributed application, we have no way to know in
> > advance what the ip
> > and subnet of users at a given site will be, much less when a customer
> > changes his local network. I tried a VB app without an entry
> > in pg_hba.conf
> > and failed, but succeed when the entry is added.
> >
> > Is there an easy way around the pg_hba.conf problem? If not,
> > has anyone who
> > has dealt with this issue have any suggestions?
> > Do not try to solve all life's problems at once -- learn to dread each
> > day as it comes.
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> >
> <http://www.postgresql.org/users-lounge/docs/faq.html>http://www.postgresq
> l.org/users-lounge/docs/faq.html
> >
Do not try to solve all life's problems at once -- learn to dread each
day as it comes.
From | Date | Subject | |
---|---|---|---|
Next Message | Sidar Lopez Cruz | 2003-02-11 14:26:40 | comparation !!! |
Previous Message | David De Graff | 2003-02-11 09:58:01 | Opening a PG filesystem db backup on a new server |