修改ambari postgres-embedded数据库源数据，删除服务

因为需要重装impala，先将impala删除，但是误操作，使得ambari-server启动不了，正确的顺序是：

curl -u admin:admin -H "X-Requested-By: ambari" -X DELETE http://58.198.176.92:8093/api/v1/clusters/hadoop/services/IMPALA

再接着删除 ambari-server/resources中的IMPALA文件夹

于是查到需要在数据库中删除数据，我使用的是postgres-embedded，于是需要用ambari登入

任务一：使用ambari登录postgres,

root用户 

vim /var/lib/pgsql/data/pg_hba.conf

sudo su

加入

local  all  ambari,mapred md5
host  all   ambari,mapred 0.0.0.0/0  md5
host  all   ambari,mapred ::/0 md5

重启pg

/etc/init.d/postgresql restart

登录

psql -U ambari -d ambari

pwd: bigdata

删除数据IMPALA

delete from servicedesiredstate where service_name like '%IMPALA%';

delete from hostcomponentstate where component_name like '%IMPALA%';

delete from hostcomponentdesiredstate where component_name like '%IMPALA%';

delete from servicecomponentdesiredstate where component_name like '%IMPALA%';

delete from clusterservices where service_name like 'IMPALA';

启动服务

sudo service ambari-server restart

reference:

http://www.bubuko.com/infodetail-186279.html

http://www.thinksaas.cn/topics/0/497/497575.html