Re: Enable user access from remote host - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Enable user access from remote host
Date
Msg-id 200903101741.20919.aklaver@comcast.net
Whole thread Raw
In response to Re: Enable user access from remote host  (Piotre Ugrumov <afmulone@gmail.com>)
List pgsql-general
On Tuesday 10 March 2009 4:36:36 pm Piotre Ugrumov wrote:
> On 9 Mar, 02:22, t...@sss.pgh.pa.us (Tom Lane) wrote:
> > John R Pierce <pie...@hogranch.com> writes:
> > > Tom Lane wrote:
> > >> A more accurate statement is that it's trustworthy to the extent that
> > >> you trust the owner of the other machine to be running a non-broken
> > >> identd daemon.  Within a LAN it might be perfectly reasonable to use.
> > >
> > > you would have to extend that trust to any machine connected to any
> > > network which can be routed to the server in question as he was
> > > specifying a wildcard IP, and that includes anything that anyone could
> > > plug into any network port.
> >
> > Agreed, it's pretty stupid to use IDENT with a wildcard IP that allows
> > connections from untrusted networks.  I was just objecting to the
> > statement that it's unsafe in all cases.
> >
> >                         regards, tom lane
> >
> > --
> > Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
> > To make changes to your
> > subscription:http://www.postgresql.org/mailpref/pgsql-general
>
> Hi,
> I inserted the following line:
>
> host    test        angelo      0.0.0.0/0          md5

Did you pg_ctl reload to get the change noticed?

>
> and in pgAdmin I insert
>
> angelo as user
> mypassword as password
> test as service
>
> and I left blank the SSL field.
>
> Moreover I have executed the following commands (before try to
> connect):
> sudo -u angelo psql template1
> then
> alter user angelo with encrypted password 'mypassword';
>
> But I have the same problems.
> Why?
> What do I wrong?
> Thanks, bye bye.



--
Adrian Klaver
aklaver@comcast.net

pgsql-general by date:

Previous
From: Piotre Ugrumov
Date:
Subject: Re: Enable user access from remote host
Next
From: Glen Parker
Date:
Subject: I don't want to back up index files