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/KWGD5PB7ACRAJ7VQRFSYFZE2SQDZTIPY/