Amazon RDS VS Patroni

Database configuration - we had to modify the database configuration. This is very difficult in various database providers (like RDS) and may even not be possible. This is also not very uniform between various DB engines (like PostgreSQL and MySQL). - Source: dev.to / about 1 month ago

Amazon Database Migration Service might initially seem like a perfect tool for a smooth and straightforward migration to RDS. However, our overall experience using it turned out to be closer to an open beta product rather than a production-ready tool for dealing with a critical asset of any company, which is its data. Nevertheless, with the extra adjustments, we made it work for almost all our needs. - Source: dev.to / about 1 month ago

RDS - 750 hours per month of db.t2.micro, db.t3.micro, or db.t4g.micro, 20GB of General Purpose (SSD) storage, 20GB of storage backups. - Source: dev.to / 3 months ago

It's easy to get "database managers" and "managed databases" confused, for obvious reasons. Managed databases are a different product to database managers entirely: they are a service that hosts and maintains your database servers for you, so that you only have to worry about the data inside them. Managed databases are a great way to outsource some of your infrastructure overhead if you don't want to host database... - Source: dev.to / 3 months ago

The app can use a local PostgreSQL and has no issues using a cloud service like Amazon RDS. - Source: dev.to / 5 months ago

We have been using stolon + consul for years without issue in our swarm environments. It may also be possible with patroni. Source: 11 months ago

One of the solutions which made it pretty simple for us to run postgresql in a ha environment (mostly in k8s, but works standalone as well) is zalandos patroni: https://github.com/zalando/patroni (docker image: https://github.com/zalando/spilo) we've also tried other operators which were easier to get started, but they failed miserably (crunchyrolls operator is... - Source: Hacker News / 11 months ago

Hello. I am currently using this docker-compose model from Zalando repository. It does not include PgBouncer in its architecture by default. I've been trying to find a containerized implementation involving Patroni, HAProxy, Etcd and PgBouncer. I didn't find anything solid so far. Source: about 1 year ago

General purpose: Patroni - Set up your own etcd + HAProxy + Patroni + Postgres components and it'll generally manage itself after that. Source: about 1 year ago

I don't have a great answer for you except that it sounds like you are trying to create your own version of patroni. Is there a good reason to not just use patroni? Source: over 1 year ago