vmware vc删除冗余存储信息

发布时间 2023-09-12 10:26:44作者: 咿呀哒喏

参考链接:https://kb.vmware.com/s/article/79623?lang=zh_cn

 

VCDB=# delete from vpx_ds_assignment where ds_id=414 or ds_id=415 or ds_id=416;
VCDB=# delete from vpx_vm_ds_space where ds_id=414 or ds_id=415 or ds_id=416;
VCDB=# delete from vpx_datastore where id=414 or id=415 or id=416;
VCDB=# delete from vpx_entity where id=414 or id=415 or id=416;

service-control --restart vmware-vpxd

 

Command> shell
Shell access is granted to root
root@photon-machine [ ~ ]# service-control --stop vmware-vpxd root@photon
-machine [ ~ ]# /opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres psql.bin (9.6.19 (VMware Postgres 9.6.19.0-16828821 release)) Type "help" for help. VCDB=# select id,storage_url from vpx_datastore; id | storage_url -----+--------------------------------------------------------- 13 | ds:///vmfs/volumes/5d27e65e-59843a39-2617-0cc47a28be3e/ 14 | ds:///vmfs/volumes/5df90e52-82fee578-e4cc-ac1f6b36ab6e/ 16 | ds:///vmfs/volumes/60d434dd-3fd64c90-d9a2-ac1f6bd0401e/ 15 | ds:///vmfs/volumes/60cc0145-e6398148-ba07-ac1f6bd0401e/ 17 | ds:///vmfs/volumes/6319b7da-b762d218-2419-ac1f6bd0401e/ 18 | ds:///vmfs/volumes/63783da0-0a2d9438-5bf4-ac1f6bd0401e/ 414 | ds:///vmfs/volumes/64feea99-942c43f6-8dc4-7cc255331ed8/ 415 | ds:///vmfs/volumes/64feeaa8-e13a8ed2-dcc0-7cc255331ed8/ 416 | ds:///vmfs/volumes/64feed4d-44485b22-8638-7cc255331ed8/ (9 rows) VCDB=# delete from vpx_ds_assignment where ds_id=414 or ds_id=415 or ds_id=416; DELETE 13 VCDB=# delete from vpx_vm_ds_space where ds_id=414 or ds_id=415 or ds_id=416; DELETE 10 VCDB=# delete from vpx_datastore where id=414 or id=415 or id=416; DELETE 3 VCDB=# delete from vpx_entity where id=414 or id=415 or id=416; DELETE 3 VCDB=# select id,storage_url from vpx_datastore; id | storage_url ----+--------------------------------------------------------- 13 | ds:///vmfs/volumes/5d27e65e-59843a39-2617-0cc47a28be3e/ 14 | ds:///vmfs/volumes/5df90e52-82fee578-e4cc-ac1f6b36ab6e/ 16 | ds:///vmfs/volumes/60d434dd-3fd64c90-d9a2-ac1f6bd0401e/ 15 | ds:///vmfs/volumes/60cc0145-e6398148-ba07-ac1f6bd0401e/ 17 | ds:///vmfs/volumes/6319b7da-b762d218-2419-ac1f6bd0401e/ 18 | ds:///vmfs/volumes/63783da0-0a2d9438-5bf4-ac1f6bd0401e/ (6 rows) VCDB=#\q
root@photon-machine [ ~ ]# service-control --start vmware-vpxd