Thread: PostgreSQL Management and monitoring tool
Hi guys.
I’m migrating a few databases to PG 14 and was wondering that it would be very nice to have a tool to help me monitor and manage my databases. I found Awide and it looks really great, but it would cost me around $800 monthly.
Do you guys know by any chance a similar solution cheaper or even open source?
Thanks!
Lucas
On Thu, Jan 27, 2022 at 02:28:17PM +1300, Lucas wrote:
> Hi guys.
>
> I’m migrating a few databases to PG 14 and was wondering that it would be very
> nice to have a tool to help me monitor and manage my databases. I found Awide
> and it looks really great, but it would cost me around $800 monthly.
>
> Do you guys know by any chance a similar solution cheaper or even open source?
Uh, this should help:
https://wiki.postgresql.org/wiki/Monitoring
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
On 27/01/2022, at 3:00 PM, Bruce Momjian <bruce@momjian.us> wrote:On Thu, Jan 27, 2022 at 02:28:17PM +1300, Lucas wrote:Hi guys.
I’m migrating a few databases to PG 14 and was wondering that it would be very
nice to have a tool to help me monitor and manage my databases. I found Awide
and it looks really great, but it would cost me around $800 monthly.
Do you guys know by any chance a similar solution cheaper or even open source?
Uh, this should help:
https://wiki.postgresql.org/wiki/Monitoring
Thanks… But I was just hoping that someone would share their solution in a more depth way…
For example: Having Zabbix to monitor the database is nice, but it does not allow you to manage Replication, backups and more from the web, like awide.io does. Maybe there isn’t even a solution like that open source….
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
On 1/26/22 20:24, Lucas wrote:
I wonder what $800/month gets you from say PostgreSQL Experts et al. Perhaps at some point your left with the pieces you need and no more $10K/year.On 27/01/2022, at 3:00 PM, Bruce Momjian <bruce@momjian.us> wrote:On Thu, Jan 27, 2022 at 02:28:17PM +1300, Lucas wrote:Hi guys.
I’m migrating a few databases to PG 14 and was wondering that it would be very
nice to have a tool to help me monitor and manage my databases. I found Awide
and it looks really great, but it would cost me around $800 monthly.
Do you guys know by any chance a similar solution cheaper or even open source?
Uh, this should help:
https://wiki.postgresql.org/wiki/MonitoringThanks… But I was just hoping that someone would share their solution in a more depth way…For example: Having Zabbix to monitor the database is nice, but it does not allow you to manage Replication, backups and more from the web, like awide.io does. Maybe there isn’t even a solution like that open source….
On 27/01/2022, at 5:01 PM, Rob Sargent <robjsargent@gmail.com> wrote:On 1/26/22 20:24, Lucas wrote:I wonder what $800/month gets you from say PostgreSQL Experts et al. Perhaps at some point your left with the pieces you need and no more $10K/year.On 27/01/2022, at 3:00 PM, Bruce Momjian <bruce@momjian.us> wrote:On Thu, Jan 27, 2022 at 02:28:17PM +1300, Lucas wrote:Hi guys.
I’m migrating a few databases to PG 14 and was wondering that it would be very
nice to have a tool to help me monitor and manage my databases. I found Awide
and it looks really great, but it would cost me around $800 monthly.
Do you guys know by any chance a similar solution cheaper or even open source?
Uh, this should help:
https://wiki.postgresql.org/wiki/MonitoringThanks… But I was just hoping that someone would share their solution in a more depth way…For example: Having Zabbix to monitor the database is nice, but it does not allow you to manage Replication, backups and more from the web, like awide.io does. Maybe there isn’t even a solution like that open source….
I’m not looking for a 3rd party consultancy company to monitor my database or to do any DBA work… I’m simply asking if anybody knows of any PostgreSQL monitoring tool similar to awide.io that is open source? That you have used in the past and could share your thoughts, pros and cons?
I know https://wiki.postgresql.org/wiki/Monitoring provides a list of monitoring tools, but I want to hear from you guys. What you use, why and if you would do it differently if you had the chance.
On 1/26/22 22:24, Lucas wrote:
Thanks… But I was just hoping that someone would share their solution in a more depth way…For example: Having Zabbix to monitor the database is nice, but it does not allow you to manage Replication, backups and more from the web, like awide.io does. Maybe there isn’t even a solution like that open source….
You can try with Oracle Enterprise Manager. Basic installation is free of charge and so is Postgres plugin. Of course, you'll need a fairly large box housing Oracle 19c EE and Weblogic application server, both parts of the OEM. Also, you don't know what is an adventure until you try upgrading OEM. It's things like that that make life interesting. As for the backups, my advice is to purchase Commvault, it has a nice GUI, can do storage snapshot backups and has great support.
Disclosure:
I used to work for Commvault Systems until May 2019, for 7 years.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com
On Thu, Jan 27, 2022 at 8:24 AM Lucas <root@sud0.nz> wrote:
On 27/01/2022, at 3:00 PM, Bruce Momjian <bruce@momjian.us> wrote:On Thu, Jan 27, 2022 at 02:28:17PM +1300, Lucas wrote:Hi guys.
I’m migrating a few databases to PG 14 and was wondering that it would be very
nice to have a tool to help me monitor and manage my databases. I found Awide
and it looks really great, but it would cost me around $800 monthly.
Do you guys know by any chance a similar solution cheaper or even open source?
Uh, this should help:
https://wiki.postgresql.org/wiki/MonitoringThanks… But I was just hoping that someone would share their solution in a more depth way…For example: Having Zabbix to monitor the database is nice, but it does not allow you to manage Replication, backups and more from the web, like awide.io does. Maybe there isn’t even a solution like that open source….
Have you looked at PMM: https://pmmdemo.percona.com/graph?
Not a whole lot of management, but some pretty neat monitoring features including query analytics. And it is open source.
Disclaimer: Percona is my employer
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.