Re: Enable user access from remote host

Piotre Ugrumov wrote:
> Hi,
> I inserted this line at the end of the pg_hba.conf
>
> host    test        angelo      ""          ident sameuser
>
> I inserted the "" to allow to everyone to access to the db.
> But if I try to access, from another host, I receive an error. What is
> the error in that line?
>

    host test angelo         0.0.0.0/0         ident sameuser

if you want to allow angelo to connect to database test from any IP...
*HOWEVER*   "ident sameuser" should *not* be used for HOST connections,
its only reliable for LOCAL connections.   instead, assign angelo a
password...

    alter user angelo with encrypted password 'somepassword';

and in pg_hba.conf, specify...

    host test angelo      0.0.0.0/0      md5

note, also, if there are any pg_hba.conf records in FRONT of this one
which would match on the connection, they will be used INSTEAD...  for
instance...

    host all all 192.168.1.0/24   md5

that allows any user, any database on the subnet 192.168.1.0/24 to
connect with md5 password authentication, and any following records
would be ignored.