PostgreSQL Host Template

[_Dmitry_]

when I try to import the template from cacti_data_query_postgresql_database_stats.xml
I get:

Error: XML: Hash version does not exist.

what's wrong ? I run on cacti-0.8.6i-1.el4.rf .

thanks.

I have created this Export with 0.8.7b, I will reexport Template with 0.8.7d and attach it later.

PS: BTW, should I download postgresql_database_stats_1.tgz (10.67KB) or
postgresql_database_stats.tgz 9.92KB) ?

...stats_1.tgz is with DB Size and ...stats.tgz without.

[vguna]

Hi.

Great templates you've created there Dmitry! Runs like a charm with only a bit configuration effort.

Inspired from that, I added an additional report for connection usage. It displays:

- Total Connections
- Connections in use/idle

I patched your pgsql_stats.php file to add the new get data_idx operation in the manner you've created the ones before.

What I didn't figure out, how you embedded the reports into one single .xml file. I had to create an external one - outside of your package. Maybe you could create the whole package again with this new report? Would be great for other users.

One last problem though: Getting active connections requires that the user used to login (here: monitor) must be the same doing the queries against the db - or has superuser privileges. If that's not the case active == total connections. But that's ok I think.

Hope hearing from you.

[maxw]

Is anyone using this template on cacti 0.8.7f?

I've installed it, configured it and the data query runs fine but I get a screen asking for Index Type, Index Value and Output Type ID??

Screenshot attached.

Any ideas?

[trieuvi]

I can't see any file, please help me!!!!

[Richardtai]

>> If anyone interested I'll upload Host Template with all Scripts and XML here later.

Dear Sir,

Would you please send me the scripts in order to allow Cacti to monitor postgres database?
Thank you very much.

Richard

[Richardtai]

Hi,

I thing I have the file postgresql_database_stats_1.tgz. Will continue.

Thanks.

Richard

[Richardtai]

Hi,

I need the instruction on 5. Edit your Host Template or Device and add PostgreSQL Database Stats in Data Queries.
Thanks.

Richard

[Richardtai]

Hi,

I also not sure how to do on:

3. Cacti Import: cacti_data_query_postgresql_database_stats.xml - Data Query + Graphs - import into Cacti

Would you please give me instruction?

Thanks.

Richard

[Richardtai]

Hi:

I figureed out and completed: 5. Edit your Host Template or Device and add PostgreSQL Database Stats in Data Queries.

I am still trying on: cacti_data_query_postgresql_database_stats.xml - Data Query + Graphs - import into Cacti, please give me instruction if you could.

Thanks.

Richard

[Richardtai]

Hi,

Import on (cacti_data_query_postgresql_database_stats.xml) was completed. Thanks.

Richard

[leasonliang]

Is anyone using this template on cacti 0.8.7f?

I've installed it, configured it and the data query runs fine but I get a screen asking for Index Type, Index Value and Output Type ID??

Screenshot attached.

Any ideas?

Hi Smiles ,i hit your problem.Did you get the result? Please give me some idea?

[leasonliang]

hi, Dmitry!I had a problem ,when import your template.Please help me.

I used Version 0.8.7g. And I import your templates.And I click (Verbose Query) for debug.And return

+ Running data query [10].
+ Found type = '4 '[script query].
+ Found data query XML file at '/var/www/html/cacti/resource/script_queries/postgres_dbstat.xml'
+ XML file parsed ok.
+ Executing script for list of indexes '/usr/bin/php /var/www/html/cacti/scripts/pgsql_stats.php 192.168.0.244 index'
+ Executing script query '/usr/bin/php /var/www/html/cacti/scripts/pgsql_stats.php 192.168.0.244 query dbname'
+ Found data query XML file at '/var/www/html/cacti/resource/script_queries/postgres_dbstat.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/script_queries/postgres_dbstat.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/script_queries/postgres_dbstat.xml'

when I click the "Create Graphs for this Host" to create the graph. There is no graph for select.Please see the Screenshot.

[smccloud]

Just got this installed and I'm not able to create any graphs. When I click Create Graphs for this Host what you see in the attached screenshot. Debugging the query returns

Code: Select all

+ Running data query [20].
+ Found type = '4 '[script query].
+ Found data query XML file at '/usr/local/share/cacti/resource/script_queries/postgres_dbstat.xml'
+ XML file parsed ok.
+ Executing script for list of indexes '/usr/bin/php /usr/share/cacti/site/scripts/pgsql_stats.php sradmin index'
+ Executing script query '/usr/bin/php /usr/share/cacti/site/scripts/pgsql_stats.php sradmin query dbname'
+ Found data query XML file at '/usr/local/share/cacti/resource/script_queries/postgres_dbstat.xml'
+ Found data query XML file at '/usr/local/share/cacti/resource/script_queries/postgres_dbstat.xml'
+ Found data query XML file at '/usr/local/share/cacti/resource/script_queries/postgres_dbstat.xml'

And doing the select statement you said to returns results like expected.

[smccloud]

Ok, just figured out my problem. I had to add the data query to an existing device instead of creating a new device.

Do you know if it would be possible to automatically add stats graphs for databases that match a specific name pattern? I.e. ones that start with gsr.

[ejortegau]

Hi, all:

I realize this is an oooooold thread, but I was wondering whether anyone knows if the template still works. Particularly, on cacti 0.8.7g

Regards,

E.