On Wed, Nov 25, 2020 at 8:05 PM <3c.monitor(a)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(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/KWGD5PB7ACR...