Should I use this to delete the year 2026 from the rows? DELETE FROM dwh_history_timekeeping WHERE EXTRACT(year FROM "date") = 2026;
thanks José De: "José Ferradeira via Users" <users@ovirt.org> Para: "Strahil Nikolov" <hunter86...@yahoo.com> Cc: "users" <users@ovirt.org> Enviadas: Segunda-feira, 25 De Janeiro de 2021 18:17:50 Assunto: [ovirt-users] Re: Ovirt reporting dashboard not working That worked there are 4 lines with dates 2026-03-26. What should I do? I'm not an expert in postgresql thanks De: "Strahil Nikolov" <hunter86...@yahoo.com> Para: supo...@logicworks.pt Cc: "users" <users@ovirt.org> Enviadas: Sábado, 23 De Janeiro de 2021 13:20:32 Assunto: Re: [ovirt-users] Re: Ovirt reporting dashboard not working Try using the 'source /opt/rh/rh-postgresql95/enable' Best Regards, Strahil Nikolov В 19:53 +0000 на 22.01.2021 (пт), José Ferradeira via Users написа: The postgres is older than 10: postgresql-jdbc-9.2.1002-6.el7_5.noarch postgresql-libs-9.2.23-3.el7_4.x86_64 rh-postgresql95-postgresql-server-9.5.9-4.el7.x86_64 rh-postgresql95-runtime-2.2-2.el7.x86_64 rh-postgresql95-postgresql-9.5.9-4.el7.x86_64 rh-postgresql95-postgresql-contrib-9.5.9-4.el7.x86_64 rh-postgresql95-postgresql-libs-9.5.9-4.el7.x86_64 collectd-postgresql-5.8.0-3.el7.x86_64 Should I use this instead: su - postgres scl enable rh-postgresql95 bash psql Thanks José De: supo...@logicworks.pt Para: "Strahil Nikolov" <hunter86...@yahoo.com> Cc: "users" <users@ovirt.org> Enviadas: Sexta-feira, 22 De Janeiro de 2021 16:39:04 Assunto: Re: [ovirt-users] Ovirt reporting dashboard not working Hello, # su - postgres -bash-4.2$ source /opt/rh/rh-postgresql10/enable -bash: /opt/rh/rh-postgresql10/enable: No such file or directory -bash-4.2$ psql engine -bash: psql: command not found -bash-4.2$ What am I doing wrong? Thanks José De: "Strahil Nikolov" <hunter86...@yahoo.com> Para: "users" <users@ovirt.org>, supo...@logicworks.pt Enviadas: Segunda-feira, 18 De Janeiro de 2021 19:16:17 Assunto: Re: [ovirt-users] Ovirt reporting dashboard not working Most probably the dwh is far in the future. The following is not the correct procedure , but it works: ssh root@engine su - postgres source /opt/rh/rh-postgresql10/enable psql engine engine=# select * from dwh_history_timekeeping ; Best Regards, Strahil Nikolov В понеделник, 18 януари 2021 г., 19:22:51 Гринуич+2, José Ferradeira via Users <users@ovirt.org> написа: Hello, Had a problem with the engine server, the clock changed to 2026 and now I don't have any report on the dashboard. The version is 4.2.3.8-1.el7 Any idea? Thanks _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/6YETINUGJEPAZSFTK35XVZ3SM5GH2OPU/ _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/KG34CLI5MIUT7OG4EVZJHHNOQTMSKJTQ/
_______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/RDMSESARKHEGCV4PTIDVBTLCTEK3VPTA/