PostgreSQL Host Template

[pesticles]

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

I've just successfully installed this template on Debian Squeeze with Cacti 0.8.7g, monitoring a PostgresQL 9.0 database.

I made some changes to the graph templates and edited the pgsql_stats.php script as I'm using a non-standard port, I may post up an update if _Dmitry_ doesn't mind.

Luke.

[jelesp]

Please update post, Dmitry's template is not working for me

[ddk]

I've just installed this template on cacti 0.8.7i
But I can't understand where to input login|password for db connect?
When I'm running data query, I had:

Code: Select all

+ Running data query [11].
+ Found type = '4' [Script Query].
+ Found data query XML file at '<path>/cacti/resource/script_queries/postgres_dbstat.xml'
+ XML file parsed ok.
+ <arg_num_indexes> missing in XML file, 'Index Count Changed' emulated by counting arg_index entries
+ Executing script for list of indexes '/usr/bin/php <path>/cacti/scripts/pgsql_stats.php 192.168.0.239 index' Index Count: 0
+ Executing script query '/usr/bin/php <path>/cacti/scripts/pgsql_stats.php 192.168.0.239 query dbname'

if run script I got an error:

Code: Select all

# php -q pgsql_stats.php index 192.168.0.239 user password
ERROR

^ because syntax is wrong, right syntax is:

Code: Select all

php -q pgsql_stats.php 192.168.0.239 index

there is a mistake in help line #260.

But I can connect to database with same login|password via psql.

I did not have enough patience
After changing the username/password on lines 197/198 it worked.

[chrischris]

Hi,

is it possible to run the script with different ports, dbnames on multiple servers?
Or just to import the script twice?

[Shivaramakrishnan]

_Dmitry_
Can you send me the xml files and host templates ?I am interested in it.

[WildChildX]

Hi, im using Version 0.8.8a of cacti. I have checked the remote connections to the databse and imported all of the files but i got the following error on the data query:

Code: Select all

Data Query Debug Information
+ Running data query [11].
+ Found type = '4' [Script Query].
+ Found data query XML file at '/usr/share/cacti/resource/script_queries/postgres_dbstat.xml'
+ XML file parsed ok.
+ <arg_num_indexes> missing in XML file, 'Index Count Changed' emulated by counting arg_index entries
+ Executing script for list of indexes '/usr/bin/php /usr/share/cacti/scripts/pgsql_stats.php 10.20.12.100 index' Index Count: 1
+ Found index: Error: PostgreSQL connect failed. Check PostgreSQL parameters (10.20.12.100/username/password)
+ Executing script query '/usr/bin/php /usr/share/cacti/scripts/pgsql_stats.php 10.20.12.100 query dbname'
+ Found item [pg_DBName=' PostgreSQL connect failed. Check PostgreSQL parameters (10.20.12.100/username/password)'] index: Error

Also i have provided the username and password in the php file... Any ideas?

[jimcjulsonjr]

Hi, im using Version 0.8.8a of cacti. I have checked the remote connections to the databse and imported all of the files but i got the following error on the data query:

Code: Select all

Data Query Debug Information
+ Running data query [11].
+ Found type = '4' [Script Query].
+ Found data query XML file at '/usr/share/cacti/resource/script_queries/postgres_dbstat.xml'
+ XML file parsed ok.
+ <arg_num_indexes> missing in XML file, 'Index Count Changed' emulated by counting arg_index entries
+ Executing script for list of indexes '/usr/bin/php /usr/share/cacti/scripts/pgsql_stats.php 10.20.12.100 index' Index Count: 1
+ Found index: Error: PostgreSQL connect failed. Check PostgreSQL parameters (10.20.12.100/username/password)
+ Executing script query '/usr/bin/php /usr/share/cacti/scripts/pgsql_stats.php 10.20.12.100 query dbname'
+ Found item [pg_DBName=' PostgreSQL connect failed. Check PostgreSQL parameters (10.20.12.100/username/password)'] index: Error

Also i have provided the username and password in the php file... Any ideas?

What lines did you edit in the pgsql_stats.php file to setup the Username/Password that you configured in your PGSQL instance? And also, did you confirm that the Username/Password that you did setup in PGSQL could execute the test queries that the OP outlined in his first post? Sorry if this is redundant, but I figured it was worth asking to make sure.

[msn308590655]

I import templates success, but also to properly connect to the database, but can not figure out。
when i add it will tips me need follow：
ostgreSQL - Rows Stats]
Index Type
Index Value
Output Type ID

and
RRDTool:
/usr/local/rrdtool/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title='TEST - PgSQL - DB Row' \
--base=1000 \
--height=200 \
--width=700 \
--alt-autoscale-max \
--lower-limit=1 \
--vertical-label='' \
--slope-mode \
--font TITLE:10: \
--font AXIS:8: \
--font LEGEND:8: \
--font UNIT:8: \
DEF:a="/var/www/html/rra/17/627.rrd":n_tup_del:AVERAGE \
DEF:b="/var/www/html/rra/17/627.rrd":n_tup_ins:AVERAGE \
DEF:c="/var/www/html/rra/17/627.rrd":n_tup_upd:AVERAGE \
LINE1:a#FF0000FF:"Deleted" \
GPRINTLAST:" Current\:%8.0lf" \
GPRINTAVERAGE:"Average\:%8.0lf" \
GPRINTMAX:"Maximum\:%8.0lf\n" \
LINE1:b#35962BFF:"Inserted" \
GPRINTLAST:"Current\:%8.0lf" \
GPRINTAVERAGE:"Average\:%8.0lf" \
GPRINTMAX:"Maximum\:%8.0lf\n" \
LINE1:c#EA8F00FF:"Updated" \
GPRINT:c:LAST:" Current\:%8.0lf" \
GPRINT:c:AVERAGE:"Average\:%8.0lf" \
GPRINT:c:MAX:"Maximum\:%8.0lf\n"
RRDTool:
ERROR: opening '/var/www/html/rra/17/627.rrd': No such file or directory

I'm sure other monitoring is normal, except for postgresql。

i think it is postgresql 8.3 or higher doesn't have follow cause
stats_row_level = on
stats_reset_on_server_start = off
stats_block_level = on
stats_command_string = on
stats_start_collector = on
。Are there any other way to do it？

[rgreiner]

Did someone manage to find out how to solve the problem reported by msn308590655? I'm running Cacti version 0.8.7g on a Debian 6 server, and after installing everything I ran into the same problem: Every graph ask for "Index Type", "Index Value" and "Output Type ID".

Any help would be appreciated.

Roberto

[nago]

Hi,

I modified these templates to work with check_postgres.pl perl script. To get it working you need to download the check_postgres.pl from http://bucardo.org/downloads/check_post ... 1.0.tar.gz

Then put that script to cacti's scripts folder and create a data input method. After that you can import the data templates and graph templates inside the attachment psqlstats.zip. This is the very first time I have done something in Cacti so I apologize if this is a bit complicated. Also my approach only supports one host since I dont know how to modify the data input method to support multiple hosts.

But yeah, at least it works.

Happy graphing!

[mikygee]

Hello,
I'm not sure why the script is written in perl. Maybe php would have been better.
I mean, in some cases (web server chrooted) it's more convenient to use a language that is inside the chroot.
Anyway, is it the latest template to monitor postgresql ?
Thanks

[bheng]

Where is postgresql.conf in a Mac OS ?

[bheng]

Can someone please post an instruction step-by-step on how to configure cacti with psql in stead of mysql ?