how to data query a external postgressql db

relaxibus · Post by **relaxibus** » Tue Mar 11, 2014 9:16 am

Hi,

I´m looking to find a way to connect to a external postgressql db, read values and graph it (switch port performances). The problem is we can´t use SNMP to do this, but we have a switch managament tool based on postgres that comunicate with the switches.

Anyone has an idea how to to this?

Cheers,

-Jarno

phalek · Post by **phalek** » Tue Mar 11, 2014 9:33 am

Create a script pulling the data out of the db and have it graph/transfer to Cacti,

http://www.php.net/manual/en/pgsql.examples-basic.php

relaxibus · Post by **relaxibus** » Tue Mar 11, 2014 9:47 am

do you have something ready to install in Cacti (host template, data query, etc)? I´m not a scripter, but can adapt it.

phalek · Post by **phalek** » Tue Mar 11, 2014 9:51 am

Unfortunately not. I do have created a template for a customer which reads data from a mysql table and presents it within Cacti, but nothing for postgresql

relaxibus · Post by **relaxibus** » Thu Mar 13, 2014 6:35 am

Hi,

I think this could be a starting point for me to understand the technique to use and to adapt it to postgresql. Could you share your template?

Cacti

how to data query a external postgressql db

how to data query a external postgressql db

Re: how to data query a external postgressql db

Re: how to data query a external postgressql db

Re: how to data query a external postgressql db

Re: how to data query a external postgressql db

Who is online