PostgreSQL Management and monitoring tool

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 <http://awide.io/&gt; does. Maybe there isn’t even a solution like that open source….

On 1/26/22 20:24, Lucas 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/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 <http://awide.io&gt; does. Maybe there isn’t even a
solution like that open source….

I wonder what $800/month gets you from say PostgreSQL Experts et al.
<https://www.postgresql.org/support/professional_support/northamerica/&gt; 
Perhaps at some point your left with the pieces you need and no more
$10K/year.

On 27/01/2022, at 5:01 PM, Rob Sargent <robjsargent@gmail.com> wrote:

On 1/26/22 20:24, Lucas wrote:

On 27/01/2022, at 3:00 PM, Bruce Momjian <bruce@momjian.us <mailto: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 <https://wiki.postgresql.org/wiki/Monitoring&gt;

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 <http://awide.io/&gt; does. Maybe there isn’t even a solution like that open source….

I wonder what $800/month gets you from say PostgreSQL Experts et al. <https://www.postgresql.org/support/professional_support/northamerica/&gt; Perhaps at some point your left with the pieces you need and no more $10K/year.

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 <https://wiki.postgresql.org/wiki/Monitoring&gt; 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 <http://awide.io&gt; 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/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….

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