Oracle Enterprise Manager vs Trusted Postgres Architect

Oracle Enterprise Manager 24ai manages Oracle Database and Engineered Systems across data centers and cloud environments. It supports real-time and historical database diagnostics, tuning, issue analysis, change validation and automated migrations. Teams can monitor Oracle and non-Oracle technologies, configure static or adaptive threshold alerts, and manage incidents and notifications. It covers Oracle Exadata and Zero Data Loss Recovery Appliance, as well as Oracle applications, WebLogic Server on Kubernetes and third-party middleware. Database management spans on-premises systems, OCI, AWS, Azure and Google Cloud. Security tools support fleet assessments, sensitive-data discovery, compliance tracking, secure-configuration audits and automated remediation. Dynamic Runbooks can guide troubleshooting with notes, charts, SQL or operating-system commands; an Enterprise Manager app can display metric data in Grafana. The platform can run on premises or through OCI Marketplace. Enterprise Manager 24ai requires Oracle Database. Base features are included with an Oracle software license or support contract; some packs and options require separate appropriate licenses. Oracle does not state a plan price on the product page.

Trusted Postgres Architect (TPA) is a free, Ansible-based tool for deploying and managing Postgres clusters using EDB recommendations. Users describe cluster topology and configuration in declarative YAML. TPA can provision AWS EC2 instances and Docker containers, or use existing servers and virtual machines when connection details are supplied. It installs and configures Postgres and related components, including replication and backups; architecture-dependent components can include PGD, Barman, PgBouncer, repmgr, and Postgres extensions. TPA can run tests specific to the cluster architecture and platform, apply configuration changes, perform switchovers, and carry out documented zero-downtime minor-version upgrades. Its configuration documentation lists PostgreSQL, EDB Postgres Extended, and EDB Postgres Advanced Server versions 13 through 18. The tool supports self-hosted Linux deployments and offers STIG and CIS configuration options, though these do not guarantee that a cluster meets those standards. TPA does not support major-version Postgres upgrades through the `tpaexec upgrade` command. Users can extend it with custom Ansible commands, tests, and deployment hook scripts.