OpenEverest vs Trusted Postgres Architect

OpenEverest is a free, open-source platform for provisioning and managing databases, storage, and LLMs on Kubernetes. Teams can create database instances through the UI, API, or CLI, choosing topologies, versions, and presets. The listed workloads include MySQL, MariaDB, MongoDB, PostgreSQL, ClickHouse, Microsoft SQL Server, TiDB, and Valkey; its FAQ also names Apache Cassandra and KServe. Users can scale by adding nodes, shards, or replicas and adjusting CPU, memory, and storage. The platform supports scheduled backups to S3-compatible storage, point-in-time recovery, and cloning an instance from a backup. It can send metrics to an existing observability stack without requiring a particular monitoring tool. Built-in protections include TLS, generated credentials, and role-based access control. A guided interface covers storage classes, pod scheduling, external access, and database engine parameters. OpenEverest can run on Kubernetes in public or private clouds, on bare metal, or on-premises. Its components are available under Apache 2.0. Version 1 is current; version 2 is a developer preview that is not feature-complete or intended for production.

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.