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_bg@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_bg@yahoo.com>
Para: suporte@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: suporte@logicworks.pt
Para: "Strahil Nikolov" <hunter86_bg@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_bg@yahoo.com>
Para: "users" <users@ovirt.org>, suporte@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-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/6YETINUGJEPAZSFTK35XVZ3SM5GH2OPU/

_______________________________________________
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/KG34CLI5MIUT7OG4EVZJHHNOQTMSKJTQ/