Re: Connect to postgres from a dynamic IP - Mailing list pgsql-general

From Jorge Godoy
Subject Re: Connect to postgres from a dynamic IP
Date
Msg-id 200803030833.29319.jgodoy@gmail.com
Whole thread Raw
In response to Re: Connect to postgres from a dynamic IP  (Raymond O'Donnell <rod@iol.ie>)
Responses Re: Connect to postgres from a dynamic IP  (paul rivers <rivers.paul@gmail.com>)
Re: Connect to postgres from a dynamic IP  (Andrei Kovalevski <andyk@commandprompt.com>)
List pgsql-general
Em Monday 03 March 2008 08:08:36 Raymond O'Donnell escreveu:
> On 03/03/2008 11:01, dfx wrote:
> > The question il: Is there a method to avoid to insert the addesses of
> > the clients in the pg_hba.conf and to allow connections from internet
> > with security assured only by username and password?
>
> Yes, that's what people have been explaining: you insert a line
> something like:
>
>    host  [database]   [user]   0.0.0.0/0   md5

But make it "hostssl" instead of "host", to require some cryptography in the
channel used, specially to authenticate the connection.

Opening your access to everyone without crypto sounds like something you don't
want to do.  Specially if users can change their own passwords...


--
Jorge Godoy      <jgodoy@gmail.com>


pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Connect to postgres from a dynamic IP
Next
From: Richard Huxton
Date:
Subject: Re: how to auto GRANT custom ACL on a new table?