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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
