Cacti and PostgreSQL

[hahnn]

Hi,

Please find my first attempt to provide a SQL schema of the cacti database for PostgreSQL (v 9.4.x).

If you want to create a PostgreSQL DB with this schema, you have to create a cacti user and a cacti database before to make PSQL read this file to init the DB (because all tables in the file have cacti user as owner).

My next step now would be to investigate cacti source code to update it (if I can...) for use with PostgreSQL instead of MySQL :p

if some of you guys are interested...

Cheers

[hahnn]

OK. I see Cacti is using ADODB for database interface. But it's a very old version from 2004 :-/

I've updated it with latest prod version of ADODB (v5.20.3), and I'm currently in the process of reviewing every SQL request to adapt them to PostgreSQL...

I've already a PostgreSQL "Cacti" running at home