On Wed, Nov 25, 2020 at 8:05 PM <3c.monitor@gruppofilippetti.it> wrote:
Hi, it seems not work...
bash-4.2$ psql psql (10.6) Type "help" for help.
postgres=# SELECT vm_name from vms where vm_guid = (SELECT vm_guid FROM vm_images_view where imagestatus = 2); ERROR: relation "vms" does not exist LINE 1: SELECT vm_name from vms where vm_guid = (SELECT vm_guid FROM...
seems you did not connect at engine DB. At ovirt 4.3, do the following: 1. ssh at engine 2. su - postgres -c 'scl enable rh-postgresql10 -- psql' 3. \c engine 4. SELECT vm_name from vms where vm_guid = (SELECT vm_guid FROM vm_images_view where imagestatus = 2); 5. SELECT image_guid from vm_images_view where imagestatus=2; 6. update images SET imagestatus=1 where image_guid = {The guid which returned in the last query} ^
postgres=#
Thanks a lot anyway. M. _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@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/KWGD5PB7ACRAJ7...