From: Mitch Pirtle <mitchy@spacemonkeylabs.com>
To: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Re: Dynamic IP authentication
Date: Fri, 19 Mar 2004 15:14:19 -0500
Message-ID: <405B549B.9000607@spacemonkeylabs.com> (raw)
In-Reply-To: <Pine.LNX.4.58.0403191904050.18946@short.lancs.ac.uk>
References: <4F44C51ED1C9D311B761009027DC72181889CEE6@exch1.unh.edu>
<Pine.LNX.4.58.0403191904050.18946@short.lancs.ac.uk>
Sam Barnett-Cormack wrote:
> On Fri, 19 Mar 2004, Richard Dockery wrote:
>
>
>> Does anyone know a way of authenticating client applications with
dynamic IP
>> addresses? All our client machines are receiving dynamic IP
addresses. Is
>> there a way to set up the pg_hba file to allow for this, or is there
another
>> 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
this:
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.
-- Mitch
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mitchy@spacemonkeylabs.com
Subject: Re: Dynamic IP authentication
In-Reply-To: <405B549B.9000607@spacemonkeylabs.com>
References: <4F44C51ED1C9D311B761009027DC72181889CEE6@exch1.unh.edu> <Pine.LNX.4.58.0403191904050.18946@short.lancs.ac.uk> <405B549B.9000607@spacemonkeylabs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox