Skip to content

Instantly share code, notes, and snippets.

@ikurni

ikurni/force-remove-rhv-hosts-from-database

Created July 18, 2023 08:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ikurni/339e962534030b040565d7e22630457f to your computer and use it in GitHub Desktop.
Save ikurni/339e962534030b040565d7e22630457f to your computer and use it in GitHub Desktop.
Download ZIP
Force Remove RHV Hypervisor Hosts from Database
Raw
force-remove-rhv-hosts-from-database
### Removal from RHV Manager UI is not possible anymore, remove button has been greyed out
# SSH to RHV Manager hosts
su - postgres
psql -d engine
SELECT vds_id FROM vds_static WHERE vds_name = 'hostname of the unresponsive hosts';
# Capture the vds_id
DELETE FROM vds_dynamic WHERE vds_id = 'vds_id of the unresponsive hosts';
DELETE FROM vds_statistics WHERE vds_id = 'vds_id of the unresponsive hosts';
DELETE FROM vds_static WHERE vds_name = 'hostname of the unresponsive hosts';
# Check again the unresponsive hosts, make sure it has been removed from the hosts lists
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment