On Wed, Nov 25, 2020 at 8:05 PM <[email protected]> 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 -- [email protected]
> To unsubscribe send an email to [email protected]
> 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/[email protected]/message/KWGD5PB7ACRAJ7VQRFSYFZE2SQDZTIPY/
>
_______________________________________________
Users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
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/[email protected]/message/GT4NWMLI4M6OYTCQFGDFXGNTLENEMWSR/
