From: | Hans Spaans <pgsql-admin(at)lists(dot)hansspaans(dot)nl> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Pg_hba and dynamic dns |
Date: | 2003-05-09 22:14:26 |
Message-ID: | 20030509221426.GA10275@sch01r01.nexit.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Fri, May 09, 2003 at 09:51:54AM -0400, Randall Perry wrote:
> Ok, those are valid points.
>
> What I'm trying to do is get access to the db for clients who are on the
> road using connections with dynamic IPs, from a PC running an MS Access db
> app. Dynamic DNS would have been an easy solution.
>
> Any ideas how to achieve this in other ways?
Don't do it. You need to look in another direction, because your
design is pretty lame. My design would be to use something like IPsec
to create a VPN between client and a router. This way all traffic is
encrypted, your ACL's aren't dynamic and you can safely control and
account who is accessing the data. This because the client becomes
part from the network.
Another suggestion, but proberly would cost more on the short term
and proberly will safe money on the long term is to build a 100%
webapp. This also can be safe by granting access based on SSL-keys and
username/password.
--
Hans
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Goldberg | 2003-05-09 23:30:31 | Re: Pg_hba and dynamic dns |
Previous Message | Erick Dennis | 2003-05-09 17:02:06 | Re: Upgrade to RH9.....Help....PostgreSQL newbie |