hawq-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wenbin Lu <luwenbin...@gmail.com>
Subject HAWQ ident authentication
Date Tue, 27 Dec 2016 16:37:06 GMT
Dear all,

Does HAWQ support ident authentication?
According to
http://hdb.docs.pivotal.io/210/hawq/clientaccess/client_auth.html, HAWQ
supports all authentication methods in postgrel 9.0, which includes the

I tried to follow
https://www.postgresql.org/docs/9.0/static/auth-pg-hba-conf.html and

The two files:
local    all         gpadmin         ident
host     all         gpadmin    trust
host  all     gpadmin    ::1/128       trust
host  all     gpadmin       trust
host  all     gpadmin    fe80::250:56ff:fea5:d08d/128       trust
host  all     gpadmin       trust
#host  all     user1       trust
#host  all     user1       trust
*local   all          all    <>
 ident map=omicron*
#local   all          user1         ident
#host    all          user1    trust

omicron         user1                gpadmin

When I use *hawq restart cluster*, the start hangs at start master, not
If I uncomment the lines in pg_hba.conf and delete the ident lines, the
restart works find and I can use psql -U user1 to login.

Is there any error with the ways I config for ident authentication?

And another question, what is the best way to add a user to HAWQ?
My way is:
user1 is Linux local account
1) use createuser -s -l user1
2) add user1 into pg_hba.conf, the commented lines above

Is this the correct way?


Lu Wenbin

View raw message