Had to do a maintenance on Immich, postgres cluster got disconnected from the operator (somehow?) and wouldn't scale past 1 replica anymore...

And we don't like single points of failure here

So first, descheduling the Immich pod, to avoid weird writes between last backup and actual DB shutdown

Triggering a manual backup

Deleting cluster

Recovering cluster from last backup

Woops, the shared library object name got renamed from vectorchord 0.3 to 0.4.3, now it's "vchord.so" instead of "vectors.so"

Quick fix and boom, everything comes back up

Restoring Argo auto sync and the cluster is all back up, distributed and shining

When Backups, DevOps and GitOps come back in a smooth and clear motion ⭐

#postgresql #postgres #cnpg #psql #selfhosted #selfhosting #homelab #k3s #kubernetes #linux #opensource #immich #vectorchord #backup #devops #argocd #gitops

Join us on Tuesday, April 14th at Noon PDT for "Databases in the Agent Era" with Monica Sarbu! RSVP ASAP!

https://www.meetup.com/postgresql-1/events/313763875/?slug=postgresql-1&eventId=313763875&isFirstPublish=true

@PostgreSQL #PostgreSQL #postgres #meetup

Would you like your company name to be everyone’s new favorite word? Sponsor PgDay Boston, and become a legend!

https://2026.pgdayboston.org/sponsors/

#PostgreSQL #postgres #conference

Early Bird registration for PgDay Boston is open! Register today and get a nice discount!

https://2026.pgdayboston.org/registration/

#PostgreSQL #postgres #conference

RE: https://ruby.social/@onghu/116266845165747064

Accompanying batch files are available now on GitHub for people using a portable #PostgreSQL installation on #Windows: https://github.com/mohits/pg-portable-launch-scripts

#programming #database

30 days until PGConf.DE 2026.

PostgreSQL is 30 years old this year.

https://2026.pgconf.de/

#PGConfDE #Essen #PostgreSQL

How to Install #Directus on #AlmaLinux #VPS

Here's a step-by-step guide detailing how to install Directus on AlmaLinux VPS.
What is Directus?
Directus is an open-source #headless #CMS and data platform that allows you to manage and interact with your database through a RESTful API or GraphQL API. It provides a modern, ...
Continued 👉 https://blog.radwebhosting.com/install-directus-on-almalinux-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #nodejs #selfhosted #letsencrypt #cmsapps #npm #selfhosting #postgresql #opensource #contentmanagement #vpsguide #installguide

How to Install #Directus on #AlmaLinux #VPS

Here's a step-by-step guide detailing how to install Directus on AlmaLinux VPS.
What is Directus?
Directus is an open-source #headless #CMS and data platform that allows you to manage and interact with your database through a RESTful API or GraphQL API. It provides a modern, ...
Continued 👉 https://blog.radwebhosting.com/install-directus-on-almalinux-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #selfhosted #opensource #selfhosting #vpsguide #installguide #postgresql #cmsapps #letsencrypt #contentmanagement #npm #nodejs

Absolutely thrilled that Suresh found "PostgreSQL Mistakes and How to Avoid Them" a useful learning resource! 🚀🐘

For anyone interested in the book version, you can grab a copy from @ManningPublications here: https://hubs.la/Q03Nc0hv0 📖

#PostgreSQL #Postgres #Books #Database

He creado un canal en Rumble con las partes del tutorial #PostgreSQL y el lenguaje #SQL:

https://rumble.com/c/c-4781052

Suscríbete a mi canal.

#bbdd #Programacion #SiguemeYTeSigo #Followback

Nota: imagen generada con IA.