cacti on Postgresql

Anything that you think should be in Cacti.

Moderators: Developers, Moderators

DarcyB

cacti on Postgresql

Post by DarcyB »

I'm wondering how receptive A) the developers B) the community is on the idea of having postgresql supported as a backend RDBMS for cacti? I already have better than 75% of the port done. Feed back on the collective take on things would be welcome.
ECWingman

Re: cacti on Postgresql

Post by ECWingman »

I am very interested in such a solution.
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Darcy,

Please send me a Personal Note with respect to your desires and what you have done with the code base to provide the support articulated in this thread. I would also like to port to MSSql and Oracle and I am very interested in what you have already done with respect to Postgresql.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
kaare
Posts: 1
Joined: Wed Jan 12, 2005 3:47 am

Re: cacti on Postgresql

Post by kaare »

DarcyB wrote:I'm wondering how receptive A) the developers B) the community is on the idea of having postgresql supported as a backend RDBMS for cacti? I already have better than 75% of the port done. Feed back on the collective take on things would be welcome.
Any progress with this ?
chadd
Cacti User
Posts: 382
Joined: Thu Mar 24, 2005 3:53 pm
Location: Ocoee, Florida

any progress on postgresql support?

Post by chadd »

I am very interested as well.
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

For the user interface and cmd.php it is a no brainer. From a Cactid perspective, it's a little more involved. :)

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
mjaz
Posts: 9
Joined: Mon Apr 18, 2005 7:33 am

Post by mjaz »

I would also be very interested to see cacti running with a postgresql backend. is there any update on the port? and what about future cacti releases? will a postgresql version of those be avalible as well?

Mark
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Post by rony »

Multiple database support is planned for future release of cacti. The next release will not include it, but will be closer to being able to support it. Full multiple database support is planned for later version in 0.9.
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
sharpone
Posts: 12
Joined: Fri May 06, 2005 6:15 pm

MSSQL

Post by sharpone »

I am also interested in mssql support. Would this be accomplished through an odbc? How much of the app will work with mssql already?
User avatar
Justeco
Posts: 5
Joined: Mon Sep 12, 2005 7:27 pm

Yes Please!

Post by Justeco »

I use PostgreSQL for everything and would like to be able to use it for Cacti as well. I dislike needing MySQL for anything.
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Post by rony »

Bummer... Current version of cacti only supports mysql.

The second or third release of 0.9.x cacti will support multiple databases. We currently antispate supporting the following databases with cmd.php polling only:

mySQL
PostgreSQL
MSSQL
Oracle

It is undecided at this point if cactid will support the other database formats.
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

Cactid will, just need more free Cacti time ;) PostgreSQL will be the easiest.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
User avatar
inetquestion
Cacti User
Posts: 67
Joined: Wed Feb 01, 2006 11:13 am
Location: Charlotte NC

Post by inetquestion »

Many mentions of a .9 version which will do lots of cool stuff with regard to supported databases. Are there any tentative dates on when this will be coming out? Given that this thread is quite old I would hope its days away. :)
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Post by rony »

Good question, no solid answer.

:(
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
pwo
Posts: 1
Joined: Fri Sep 07, 2007 5:30 pm
Location: Oberhaching, germany
Contact:

cacti and postgresql

Post by pwo »

Definitely would love to see support of postgresql as a database backend for cacti.

Cheers
--pwo

--
Peter W. Osel
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests