patroni VS beekeeper-studio

Citus doesn't provide fault tolerance. Each shard is a monolithic PostgreSQL. To reduce downtime on failures, you can protect each shard with a standby database. As this is a complex configuration, Patroni can help. For this lab I'll use the Citus+Patroni docker-compose-citus.yml from https://github.com/zalando/patroni.git:

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

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 it's really solid and worked for us for a few years already.

or for k8s their operator: https://github.com/zalando/postgres-operator (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 basically based on the zalando one)

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.

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

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?

git clone https://github.com/zalando/patroni.git cd patroni docker build -t patroni . docker-compose up -d

I actually used Patroni on Openshift in my company. To be update with the latest version we created our helm chart.

If we access a client like PgAdmin or Beekeeper, or accessing its container via bash and checking via CLI, we can see that the table was created successfully:

This tool doesn't let you run SQL queries or create tables. SchemaSpy describes and visualizes an already-created database.

To work directly with SQL, I recommend https://www.beekeeperstudio.io/ or https://dbgate.org/

I use the free “community” edition daily: https://github.com/beekeeper-studio/beekeeper-studio/release...

postgres has some cool tools these days. postico if you are on macos or my personal fav lately has been https://www.beekeeperstudio.io/

Beekeeper Studio is a modern (aesthetic) and lightweight SQL client that supports MySQL, Postgres, SQLite, SQL Server, etc. It is available on Linux, Mac and Windows.

I'm trying to renew my certificate for Beekeeper Studio, 3 years ago it was a simple download, but now it costs 3x the price and they want to ship me a physical device with the private key on it.

`cask "beekeeper-studio"` [link][oss] for anything database