Re: Enable user access from remote host

On 11 Mar, 01:41, akla(dot)(dot)(dot)(at)comcast(dot)net (Adrian Klaver) wrote:
> 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
> akla(dot)(dot)(dot)(at)comcast(dot)net
>
> --
> 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

I restarted my xubuntu (where I installed postgresql) but I have the
problem.
Thanks, bye bye.