
Hi Team, 1) How to access the default postgres database running as default in the ovirt engine environment ? 2) What are the tables used for collecting disk level statistics in postgresql? 3) Is there any datamodel available to debug the postgresql tables? Thanks, Harry

I am not able login to psql also :( [root@ovirt ovirt-engine]# su - postgres Last login: Tue Apr 17 23:24:32 IST 2018 on pts/4 -bash-4.2$ psql bash: psql: command not found... -bash-4.2$ On Tue, Apr 17, 2018 at 11:13 PM, Hari Prasanth Loganathan < hariprasanth.l@msystechnologies.com> wrote:
Hi Team,
1) How to access the default postgres database running as default in the ovirt engine environment ?
2) What are the tables used for collecting disk level statistics in postgresql?
3) Is there any datamodel available to debug the postgresql tables?
Thanks, Harry

Guys any help on this please ! On Tue, 17 Apr 2018 at 11:13 PM, Hari Prasanth Loganathan < hariprasanth.l@msystechnologies.com> wrote:
Hi Team,
1) How to access the default postgres database running as default in the ovirt engine environment ?
2) What are the tables used for collecting disk level statistics in postgresql?
3) Is there any datamodel available to debug the postgresql tables?
Thanks, Harry

If you searched in the archives you'll find the explanation: postgres comes from softwarecollections. You need to do this: su - postgres scl enable rh-postgresql95 bash psql Luca Il mar 17 apr 2018, 22:48 Hari Prasanth Loganathan < hariprasanth.l@msystechnologies.com> ha scritto:
Guys any help on this please !
On Tue, 17 Apr 2018 at 11:13 PM, Hari Prasanth Loganathan < hariprasanth.l@msystechnologies.com> wrote:
Hi Team,
1) How to access the default postgres database running as default in the ovirt engine environment ?
2) What are the tables used for collecting disk level statistics in postgresql?
3) Is there any datamodel available to debug the postgresql tables?
Thanks, Harry
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

Much appreciated. I need the read bandwidth, write bandwidth, read latency, write latency, read iops, wrote iops of all disks available in ovirt. So which is the table I need to look ? Thanks On Wed, 18 Apr 2018 at 2:25 AM, Luca 'remix_tj' Lorenzetto < lorenzetto.luca@gmail.com> wrote:
If you searched in the archives you'll find the explanation: postgres comes from softwarecollections.
You need to do this:
su - postgres scl enable rh-postgresql95 bash psql
Luca
Il mar 17 apr 2018, 22:48 Hari Prasanth Loganathan < hariprasanth.l@msystechnologies.com> ha scritto:
Guys any help on this please !
On Tue, 17 Apr 2018 at 11:13 PM, Hari Prasanth Loganathan < hariprasanth.l@msystechnologies.com> wrote:
Hi Team,
1) How to access the default postgres database running as default in the ovirt engine environment ?
2) What are the tables used for collecting disk level statistics in postgresql?
3) Is there any datamodel available to debug the postgresql tables?
Thanks, Harry
_______________________________________________
Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
participants (2)
-
Hari Prasanth Loganathan
-
Luca 'remix_tj' Lorenzetto