I solve the problem now !!!!!! it is working ! 😉 I reindex the index withe the posgres user and it works now! ambari=# REINDEX INDEX pg_type_typname_nsp_index; REINDEX ambari=# \di pg_type_typname_nsp_index; List of relations Schema | Name | Type | Owner | Table -----------+---------------------------+-------+----------+--------- pg_catalog | pg_type_typname_nsp_index | index | postgres | pg_type (1 row) Many thanks to all for the great support! special thanx to Jay SenSharma BOB ... View more

@Jay SenSharma I try to reindex the table but i need Superuser rights to do this ! ambari=> select oid,relname from pg_class where oid =16384 or oid=2704; oid | relname ------+--------------------------- 2704 | pg_type_typname_nsp_index (1 row) Then I try to REINDEX how I can get own rights to the index ? ambari=> REINDEX INDEX pg_type_typname_nsp_index; ERROR: must be owner of relation pg_type_typname_nsp_index ambari=> \du List of roles Role name | Attributes | Member of ------------+-------------+----------- ambari | | {} kappacherr | | {} postgres | Superuser | {} : Create role : Create DB ... View more

I solve this problem whit update the file /var/lib/pgsql/data/pg_hba.conf to # "local" is for Unix domain socket connections only local all postgres trust # IPv4 local connections: host all postgres 127.0.0.1/32 trust host all all 172.16.4.183/24 trust # IPv6 local connections: host all postgres ::1/128 trust local all all md5 host all ambari,mapred 0.0.0.0/0 md5 host all ambari,mapred ::/0 md5 It is a work around! but anyway the ambari login did not work ! ... View more

[root@sandbox /]# psql -U raj_ops ambari psql: FATAL: no pg_hba.conf entry for host "[local]", user "raj_ops", database "ambari", SSL off Now I try to connect with raj_ops to ambari and I get that error! ... View more

@rguruvannagari Thanks for your help! I try to connect but I don’t know the Password for user ambari ! Where I can find it or where can I set it? [root@sandbox /]# psql -U ambari ambari Password for user ambari: psql: FATAL: password authentication failed for user "ambari" ... View more