search

dwyl / learn-postgresql

🐘 Learn how to use PostgreSQL and Structured Query Language (SQL) to store and query your relational data. 🔍
212 stars 23 forks source link

postgresql-cluster.org - Automated database platform for PostgreSQL® #114

Open nelsonic opened 1 week ago

nelsonic commented 1 week ago

Following the Fly.io Postgres fiasco https://github.com/dwyl/auth/issues/325#issuecomment-1792297886 we are back to the drawing board when it comes to Postgres. 🔍 💭

We took a look at Managed Postgres on DigitalOcean https://github.com/dwyl/learn-devops/issues/90 and for a simple app that doesn't have many records/updates it would be fine but the moment you need to scale to a decent size and speed, the costs get out-of-hand compared to self-managing ... https://github.com/dwyl/learn-devops/issues/90#issuecomment-2241488297

Sooooo ... this is what I'm considering: run https://postgresql-cluster.org on Hetzner https://github.com/dwyl/learn-devops/issues/97

image

Using 3 VMs in 3 data centres; eu-central (fsn1), us-west (hil) and ap-southeast (sin): https://github.com/dwyl/learn-devops/issues/97#issuecomment-2471660337

asntc commented 2 days ago

We had a brief hiccup where we couldn't make progress ... 🧱 Opened an issue: https://github.com/vitabaks/postgresql_cluster/issues/811 and got a reply super quick! 🏎️ This gives us confidence that the project is maintained and we are making a good choice to use it. 🤞