Sam Barnett-Cormack wrote:
> On Fri, 19 Mar 2004, Richard Dockery wrote:
>> Does anyone know a way of authenticating client applications with
>> addresses? All our client machines are receiving dynamic IP
>> there a way to set up the pg_hba file to allow for this, or is there
>> way to configure connections so as not to use this file?
>> Any thoughts would be appreciated.
>> Thank you!
> Open access to the whole IP range, but require passwords. I think you
> can wrap in SSL as well.
This is what I do, and now I won't let non-SSL connections through. The
pg_hba.conf entry that lets me connect over SSL from anywhere looks like
hostssl all mitchy 0.0.0.0 0.0.0.0 password
Of course you need to configure your database box with an SSL key, which
is well documented.
In response to
pgsql-admin by date
|Next:||From: Anton J. Garnik||Date: 2004-03-20 04:23:06|
|Subject: pgAdmin III bug|
|Previous:||From: Sam Barnett-Cormack||Date: 2004-03-19 19:04:29|
|Subject: Re: Dynamic IP authentication|