💻 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

Moved from Zalando Psql to CNPG a while ago. And I gotta say. I'm never looking back.

My numerous mistakes in my homelab has been just restore database from S3.

I wish I did this sooner🫶

#homelab #cnpg #kubernetes #zalando

Running CNPG now for 1.5 months. Previously this project used Azure Flexible Servers, which

- imho is a very-hard-to-monitor blackbox
- contrary to the name is not very flexible when you want to install extensions
- generates high OpEx (the customer paid almost 1000 euros/month)
- adds 20-50 ms of latency to every roundtrip

CNPG is an improvement in every direction. The hard pard was understanding how it works, besides that, no problems. 10/10, would recommend.

#kubernetes #cnpg #postgres

Yo back in town 👋

Really need to figure out those pesky cnpg issues, it makes no sense to have dangling Postgres pods not being able to start again for similarly no reason

Now the question, is it cnpg or my s3 setup the issue 🤔

#homelab #selfhosted #selfhosting #s3 #cnpg #cloudnative #postgres

If you use CNPG to run postgres and your applications employ a connection pool like HikariCP, make sure to set:

smartShutdownTimeout: 0

Otherwise, everytime you make a change to your cluster instances you get 2-3 minutes of instance downtime. And since regular changes will usually not trigger a database failover, this also means 2-3 minutes of application downtime.

#kubernetes #cnpg #postgres

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

#DOAG2025 Conference was a blast!
Some pictures from my talk about Proxmox (for my company laptop: nested virtualized under Hyper-V), Oracle26ai, PostgreSQL, Patroni and CNPG on virtualized K8s, virtualized using Prometheus and Grafana.

Slides in English, presented in German (to download and read or view online - esp. if you weren't able to attend, because it was the last slot).

#proxmox #oracle #26ai #postgresql #postgres #enterprisedb #cnpg #k8s #LearnK8s #prometheus #grafana #observability