search

opserver / Opserver

Stack Exchange's Monitoring System
https://opserver.github.io/Opserver/
MIT License
4.5k stars 827 forks source link

Any plans about PostgreSQL? #321

Open ZedZipDev opened 6 years ago

ZedZipDev commented 6 years ago

Is it possible to implement PostgreSQL servers monitoring?

NickCraver commented 5 years ago

Possible? Yep. No plans from my side though, as I don't have the time or any production PostgreSQL servers to test against and verify anything. If the community wants to, more than happy to discuss it...but there's significant effort in doing so.

gortok commented 5 years ago

@NickCraver I'd like to at least attempt to create Postgres support in OpServer; is there a specific set of code you can point me to that would help me understand 'the basics' that Opserver needs to make that happen?

NickCraver commented 5 years ago

@gortok Given the views, counters, and DMV-based nature of SQL Server, it's basically all of the SQL code. It'd be a very large undertaking (and probably duplication) to add Postgres (or MySql). The overall approach may just not even work, I'm not familiar enough with monitoring on those platforms to say either way.

You can find the SQL polling code here: https://github.com/opserver/Opserver/tree/master/Opserver.Core/Data/SQL And most of the UI here: https://github.com/opserver/Opserver/tree/master/Opserver/Views/SQL

gortok commented 5 years ago

@NickCraver my first goal would be to get the simplest amount of instrumentation in place, and extend that as we go. If you don’t expect like-in-kind support out of the gate then this is the plan. What are your thoughts on this plan? Do you want a mature fork or something alpha-ish and iterate on it?

NickCraver commented 5 years ago

@gortok I'd take a stab with a fork at the moment...you're going to see me going nuts converting this to AspNetCore at night for the next little bit here :)

gortok commented 5 years ago

Well then I may want to wait since .NET Core compat is at the top of my requirements. :)