[ovirt-users] Re: How to force removal of old host from Engine

Not a good approach. It's important to know if the node was also a gluster peer in the storage pool - if yes, it needs to be replaced with 'replace-brick' or 'reset-brick' (depending if you use the old hostname or not). Once the storage node is replaced - oVirt will allow you to remove it. Best Regards, Strahil Nikolov В вторник, 21 април 2020 г., 19:46:47 Гринуич+3, Maton, Brett <matonb(a)ltresources.co.uk&gt; написа: Last time I had to do this I removed from the database. (at your own risk) On ovirt engine switch to the postgres user from root: su - postgres Enable postgres 10 and connect to the engine database: . scl_source enable rh-postgresql10 psql -d engine Change <host name to remove> to the name (Name column of the host in the UI) of the host you want to get rid of ( leave the '\' and \'' in place ) BEGIN;\set host '\'<host name to remove>\''DELETE FROM vds_dynamic WHERE vds_id IN (SELECT vds_id FROM vds_static WHERE vds_name = :host);DELETE FROM vds_statistics WHERE vds_id IN (SELECT vds_id FROM vds_static WHERE vds_name = :host);DELETE FROM vds_static WHERE vds_name = :host;COMMIT; <CTRL d - exit> On Tue, 21 Apr 2020 at 15:19, Shareef Jalloq <shareef(a)jalloq.co.uk&gt; wrote: _______________________________________________ Users mailing list -- users(a)ovirt.org To unsubscribe send an email to users-leave(a)ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/EAFO7EBLCET...