Re: Enable user access from remote host

On Tuesday 10 March 2009 4:36:36 pm Piotre Ugrumov wrote:
> On 9 Mar, 02:22, t(dot)(dot)(dot)(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote:
> > John R Pierce <pie(dot)(dot)(dot)(at)hogranch(dot)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(dot)(dot)(dot)(at)postgresql(dot)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(at)comcast(dot)net