#cnpg — Public Fediverse posts

@plossra_a organise chaque année les Rencontres régionales du Logiciel libre à Lyon.
Le 12 mai prochain, Dalibo sera aux côtés des autres #Enl , passez donc nous voir !

Notre collègue Pierrick animera aussi une petite #conférence sur #CloudNativePG.

Inscription gratuite : https://www.rpll.fr/inscription-visiteurs-2026

#RPLL2026
#PostgreSQL #SGBD #DBA
#CNPG #kubernetes
#opensource

Join our upcoming free webinar to learn about the key open source technologies you can use in your stack for a streamlined developer experience.

Our senior director of engineering Matthew Mols and our solutions engineer Paul Rothrock will discuss "Taking #PostgreSQL on #Kubernetes to new heights with Spock, pgEdge Helm, & #CloudNativePG", both how it works & demo'ing it live.

📌 Register to attend this 4/14 @ 11AM EST: https://us02web.zoom.us/webinar/register/WN_G1FtqK8fSe-DF3asizQ0xw

#programming #k8s #cncf #cnpg #postgres #sql #tech

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

💻 TECH : comment exécuter des ordres #SQL dès la création d'un Cluster #PostgreSQL ?

Réponse dans ce 11e article consacré à #CloudNativePG => https://dali.bo/202603_cnpg

#SGBD #CNPG #kubernetes
#opensource

Some time this weekend, we'll be upgrading the #Mastodon #PostgreSQL cluster on #MSTDNDK. The cluster is being managed by #CloudNativePG and upgrades have been successfully tested on multiple other clusters - even upgrades directly from version 15 to 18.

While this is an incredibly smooth and easy process, major upgrades requires that #CNPG takes down the whole database cluster, meaning https://mstdn.dk will be unavailable for a period of time. Exactly how long is unknown, since we've never actually done this before with clusters of this size.

I'll keep you posted and give you fair warning 🙂

Le 8 avril prochain à Paris, nous vous proposons un #workshop dédié à l'opérateur #CloudNativePG.
Réservez vite votre place, premier arrivé, premier servi ! => https://dali.bo/202603_wkp-cnpg

#CNPG #PostgreSQL #Kubernetes
#formation #DBA #SGBD

💻 TECH : nouvel d'article de notre série consacrée à l'opérateur #CloudNativePG ! 📝

Découvrez-en un peu plus sur la synergie entre celui-ci et les ressources natives de #Kubernetes !
Pierrick vous montre comment l'opérateur protège votre instance primaire en cas de drain d'un nœud Kubernetes => https://dali.bo/202602_cnpg

#PostgreSQL #SGBD #DBA
#opensource
#CNPG

Le 3 février prochain, notre équipe tech et commerciale sera aux Cloud Native Days France.
Elle pourra parler, entre autres, de notre offre de support de #CloudNativePG.

Si vous êtes dans le coin… 😊

Toutes les infos utiles ici : https://www.cloudnativedays.fr/

#PostgreSQL #SGBD
#CNPG #kubernetes
#opensource

Today, trying to get the k3s cluster back to a working and smooth sailing state...

It has been somewhat unstable since the moving, and with little time to take care of it, outages were around every corner

Turns out, CNPG wasn't clearing out WAL on local replicas, inflating local disk usage, making them unavailable for scheduling...

Now that I understand why everything goes down, it is time to setup ntfy and link with with alertmanager+prometheus to get proper insights on the cluster in realtime

Now, back to rebuilding all Longhorn volumes because of those random outages *sight*

But underlining the importance of having good backups ! Because no data was lost, despite random downtimes

#k3s #devops #kubernetes #prometheus #alertmanager #cluster #cnpg #wal #postgres #psql #ntfy #longhorn #volume #backups #homelab #selfhosted

Having recently experienced a rather horrible #Kubernetes crash, I'm looking for #backup solutions. We're good with PostgreSQL since we're using #CNPG with remote transaction logs to an offsite #S3 bucket. I need something for volumes and maybe Kubernetes resources. #Longhorn offers S3 backups for it's own volumes, but for other #CSI like local #OpenEBS, maybe #Velero? Thoughts?

https://velero.io/

Great productivity tonight !

Upgraded Immich from 1.132.1 to 1.135.3
Migrated its database from pgvector.rs to VectorChord
Upgraded to VectorChord 0.4.3 from 0.3.0

That was actually relatively easy once I started taking my time and reading the migration documentation

Now everything is healthy and up to date, let's see how those performance improvements translate to realworld applications

#immich #selfhosted #homelab #kubernetes #vectorchord #pgvector #psql #cnpg #rtfm

So yesterday about this time, I was #poolside somewhere in #Türkiye or #Turkey if you will, when our fearless moderator @leeleedee notified me that https://mstdn.dk was down. The root cause was the rack mounted Synology RS1221+ NAS in my basement, serving as the S3 backup backend for the #CNPG (Cloud Native Postgres) which was failing to get back online after a reboot. When I arrived home today, all it took was a hard reset, and everything is running fine again. This really shouldn't happen, so I'll put it through some rigorous testing in the coming days.

#CloudNativePG : Julian présente la fonctionnalité qui permet d'y installer des #plugins à partir d'un exemple concret =>
https://dali.bo/202503_cloudnativepg-6

#PostgreSQL #SGBD #DBA
#opensource #logicielsLibres
#CNPG
@CloudNativePG

Déployer #PostgreSQL dans un cluster #Kubernetes : que faire en cas de saturation de l'espace disque ? 💥
Dans sa série dédiée à l'opérateur #CloudNativePG, Pierrick vous propose une solution => https://dali.bo/202503_cloudnativepg-5

#SGBD #DBA
#opensource #logicielsLibres
#cnpg CloudNativePG
#pg_bench

Lancer une bouée à un éléphant est tout un art !
Cette semaine, Pierrick évoque différentes méthodes de #sauvegarde d'instance #PostgreSQL avec #cloudNativePG => https://dali.bo/202502_cloudnativepg-4

#SGBD #DBA
#opensource #logicielsLibres
#cnpg @cloudnativepg
#pg_dump #PITR #backup #barman_cloud

Notre série dédiée à #cloudNativePG continue !
Cette fois, Julian présente des solutions de stockage et de performance =>
https://dali.bo/202502_cloudnativepg-3

#PostgreSQL #SGBD
#opensource #logicielsLibres
#cloud #CNPG
CloudNativePG
#longhorn #pgbench