autobase

For those interested in this I also recommend autobase, a set of ansible roles for a highly available postgres cluster on hetzner or other clouds: https://github.com/autobase-tech/autobase

autobase[1] is the one I can think of [1] https://github.com/autobase-tech/autobase

Just use Autobase for PostgreSQL https://github.com/vitabaks/autobase automates the deployment and management of highly available PostgreSQL clusters in production environments. This solution is tailored for use on dedicated physical servers, virtual machines, and within both on-premises and cloud-based infrastructures.

Take a look at https://github.com/vitabaks/autobase In case you want to self host but also have something that takes care of all that extra work for you

Fun fact: psql has a syntax through which one can use a form of prepared statements to avoid exploding when the password contains sql-sensitive characters[1]: https://www.postgresql.org/docs/17/app-psql.html#APP-PSQL-OP... and https://www.postgresql.org/docs/17/app-psql.html#APP-PSQL-IN... although regrettably it is not compatible with the "-c" invocation for some terrible reason, thus requiring the SQL to actually come from stdin: psql --set newpass="bobby';--drop table" <<'FOO' ALTER USER postgres WITH PASSWORD :'newpass'; FOO 1: https://github.com/vitabaks/autobase/blob/e93fbe0c667c18a24e...

You'll probably like this: https://github.com/vitabaks/postgresql_cluster

Creating a robust database cluster is often fraught with challenges. A manual deployment process can be fraught with risks, particularly for those who lack extensive experience. Even minor errors in configuration can drastically affect your database's performance and stability. Recognizing this intricacy, many businesses choose to use cloud-based managed databases. These services offer convenience but not without limitations. These drawbacks can include being tied to a specific cloud provider and limited direct access to the database server for adjustments. These constraints can hinder your ability to tune your system and perform thorough performance analyses. In response to these challenges, we've developed a project to make this process easier and more efficient. This project uses automation to streamline the deployment of High-Availabi

If not Kubernetes, check out this: https://github.com/vitabaks/postgresql_cluster – it's Postgres + patroni + pgBouncer + WAL-G or pgBackRest + Netdata + more, managed by Ansible. If you do want to use Kubernetes, then check out: - StackGres.io - https://github.com/zalando/postgres-operator - https://blog.flant.com/comparing-kubernetes-operators-for-po...