I got the following to work to remove HBASE and NIFI from Ambari: [root@ambari-server ~] # ambari-server stop Using python /usr/bin/python Stopping ambari-server Ambari Server stopped [root@ambari-server ~] # su - postgres - bash -4.1$ psql psql (8.4.20) Type "help" for help. postgres= # \connect ambari psql (8.4.20) You are now connected to database "ambari" . ambari= # DELETE FROM ambari.hostcomponentstate WHERE service_name IN ('HBASE'); DELETE 14 ambari= # DELETE FROM ambari.hostcomponentdesiredstate WHERE service_name IN ('HBASE'); DELETE 14 ambari= # DELETE FROM ambari.servicecomponentdesiredstate WHERE service_name IN ('HBASE'); DELETE 4 ambari= # DELETE FROM ambari.servicedesiredstate WHERE service_name IN ('HBASE'); DELETE 1 ambari= # DELETE FROM ambari.clusterservices WHERE service_name IN ('HBASE'); DELETE 1 ambari= # \q - bash -4.1$ exit logout [root@ambari-server ~] # ambari-server start Using python /usr/bin/python Starting ambari-server Ambari Server running with administrator privileges. Organizing resource files at /var/lib/ambari-server/resources ... Server PID at: /var/run/ambari-server/ambari-server .pid Server out at: /var/log/ambari-server/ambari-server .out Server log at: /var/log/ambari-server/ambari-server .log Waiting for server start.................... Ambari Server 'start' completed successfully. [root@ambari-server ~] # ambari-server stop Using python /usr/bin/python Stopping ambari-server Ambari Server stopped [root@ambari-server ~] # su - postgres - bash -4.1$ psql psql (8.4.20) Type "help" for help. postgres= # \connect ambari psql (8.4.20) You are now connected to database "ambari" . ambari= # DELETE FROM ambari.hostcomponentstate WHERE service_name IN ('NIFI'); DELETE 1 ambari= # DELETE FROM ambari.hostcomponentdesiredstate WHERE service_name IN ('NIFI'); DELETE 1 ambari= # DELETE FROM ambari.servicecomponentdesiredstate WHERE service_name IN ('NIFI'); DELETE 1 ambari= # DELETE FROM ambari.servicedesiredstate WHERE service_name IN ('NIFI'); DELETE 1 ambari= # DELETE FROM ambari.clusterservices WHERE service_name IN ('NIFI'); DELETE 1 ambari= # \q - bash -4.1$ exit logout [root@ambari-server ~] # ambari-server start Using python /usr/bin/python Starting ambari-server Ambari Server running with administrator privileges. Organizing resource files at /var/lib/ambari-server/resources ... Server PID at: /var/run/ambari-server/ambari-server .pid Server out at: /var/log/ambari-server/ambari-server .out Server log at: /var/log/ambari-server/ambari-server .log Waiting for server start.................... Ambari Server 'start' completed successfully. [root@ambari-server ~] # , This worked for me and now HBASE and NIFI no longer show up in Ambari: [root@ambari-server ~]# ambari-server stop Using python /usr/bin/python Stopping ambari-server Ambari Server stopped [root@ambari-server ~]# su - postgres -bash-4.1$ psql psql (8.4.20) Type "help" for help. postgres=# \connect ambari psql (8.4.20) You are now connected to database "ambari". ambari=# DELETE FROM ambari.hostcomponentstate WHERE service_name IN ('HBASE'); DELETE 14 ambari=# DELETE FROM ambari.hostcomponentdesiredstate WHERE service_name IN ('HBASE'); DELETE 14 ambari=# DELETE FROM ambari.servicecomponentdesiredstate WHERE service_name IN ('HBASE'); DELETE 4 ambari=# DELETE FROM ambari.servicedesiredstate WHERE service_name IN ('HBASE'); DELETE 1 ambari=# DELETE FROM ambari.clusterservices WHERE service_name IN ('HBASE'); DELETE 1 ambari=# \q -bash-4.1$ exit logout [root@ambari-server ~]# ambari-server start Using python /usr/bin/python Starting ambari-server Ambari Server running with administrator privileges. Organizing resource files at /var/lib/ambari-server/resources... Server PID at: /var/run/ambari-server/ambari-server.pid Server out at: /var/log/ambari-server/ambari-server.out Server log at: /var/log/ambari-server/ambari-server.log Waiting for server start.................... Ambari Server 'start' completed successfully. [root@ambari-server ~]# ambari-server stop Using python /usr/bin/python Stopping ambari-server Ambari Server stopped [root@ambari-server ~]# su - postgres -bash-4.1$ psql psql (8.4.20) Type "help" for help. postgres=# \connect ambari psql (8.4.20) You are now connected to database "ambari". ambari=# DELETE FROM ambari.hostcomponentstate WHERE service_name IN ('NIFI'); DELETE 1 ambari=# DELETE FROM ambari.hostcomponentdesiredstate WHERE service_name IN ('NIFI'); DELETE 1 ambari=# DELETE FROM ambari.servicecomponentdesiredstate WHERE service_name IN ('NIFI'); DELETE 1 ambari=# DELETE FROM ambari.servicedesiredstate WHERE service_name IN ('NIFI'); DELETE 1 ambari=# DELETE FROM ambari.clusterservices WHERE service_name IN ('NIFI'); DELETE 1 ambari=# \q -bash-4.1$ exit logout [root@ambari-server ~]# ambari-server start Using python /usr/bin/python Starting ambari-server Ambari Server running with administrator privileges. Organizing resource files at /var/lib/ambari-server/resources... Server PID at: /var/run/ambari-server/ambari-server.pid Server out at: /var/log/ambari-server/ambari-server.out Server log at: /var/log/ambari-server/ambari-server.log Waiting for server start.................... Ambari Server 'start' completed successfully. [root@ambari-server ~]# ... View more