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

--
________________________________
Jose Ferradeira
http://www.logicworks.pt
_______________________________________________
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/KPW5FFKG3AI6EINW4G74IKTYB2E4A5DT/