Remove HDP Cluster from DPS using postgres script

This article explains how to delete a Registered HDP cluster from DPS

Steps:

1. Download the attached file dp-cluster-remove.txt and store it in postgres db server.

2. psql -f ./dp_cluster_remove.txt -d dataplane -v cluster_name=c149

-d --> <dataplane database name>

cluster_name --> Your HDP clustername that should be removed from DPS cluster.

Example Output:-

[root@rraman bin]# docker exec -it dp-database /bin/bash

bash-4.3# su - postgres

de0ff40ad912:~$ ls -lrt

total 8

drwx------ 19 postgres postgres 4096 Sep 21 01:27 data

-rwxrwxrwx 1 postgres postgres 892 Sep 21 17:59 dp_cluster_remove.txt

de0ff40ad912:~$ psql -f ./dp_cluster_remove.txt -d dataplane -v cluster_name=c149

CREATE FUNCTION

remove_cluster_from_dps

-------------------------

(1 row)

DROP FUNCTION