From: | Michael Weaver <mweaver(at)corpusglobe(dot)com> |
---|---|
To: | 'Mike Alford' <mikea(at)syscon-intl(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 08:14:24 |
Message-ID: | 3B663B41B350D311AEEF00A0C9254563201A6D@VISION1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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]
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | David De Graff | 2003-02-11 09:58:01 | Opening a PG filesystem db backup on a new server |
Previous Message | Yudha Setiawan | 2003-02-11 06:57:46 | Spread the schema |