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