#cnpg — Public Fediverse posts

FORMATION : le catalogue Dalibo s'enrichit ! 🤓
Voici 2 nouvelles formations conçues par nos collègues #DBA et #dev :
✅ CNPG1, ou comment utiliser #PostgreSQL dans #Kubernetes avec #CloudNativePG
✅ DEV1, ou s'initier au langage #SQL

=> https://dali.bo/202609_nouvelles_formations

#SGBD #CNPG
#opensource #logicielsLibres
#formation
#devops

REPLAY : en mai dernier, Pierrick intervenait aux #RPLL pour présenter CloudNativePG, l'opérateur Kubernetes pour PostgreSQL
=> https://dali.bo/202608_conf_rpll_cnpg

Merci au @plossra_a pour ce partage !

#PostgreSQL #sgbd #dba
#CNPG #CloudNativePG
#Kubernetes #K8S
#opensource
#conference

RELEASE : voici un nouvel outil basé sur #pgBackRest, pour sauvegarder les instances #PostgreSQL déployés avec #CloudNativePG !

Deux de ses développeurs vous en parlent => https://blog.dalibo.com/2026/06/25/plugin-pgbackrest.html

🇬🇧 => *Here is the announcement of our experimental CloudNativePG plugin to backup PostgreSQL instances with pgBackRest!*

#SGBD #CNPG #DBA
#kubernetes
#opensource

Kubernetes для баз данных? CloudNativePG делает PostgreSQL по-настоящему Cloud-Native

Практический разбор: запускаем PostgreSQL в Kubernetes с высокой доступностью, автоматическим failover и декларативным управлением - через один YAML-файл. В лес CNPG

https://habr.com/ru/articles/1039452/

#kubernetes #CNPG #postgresql #devops #инфраструктура #database #k8s #k8s_operator #базы_данных #cloudnative

In case you were looking for a step-by-step guide for setting up a #CloudNativePG replica cluster using the #Barman Cloud Plugin for backups and WAL archiving... look no further: https://www.enterprisedb.com/blog/deployment-postgresql-replica-cluster-barman-cloud-plugin-cloudnativepg-part-1 #PostgreSQL #Kubernetes #CNPG

@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

WEW #MASTODON ON CLOUDNATIVE-PG! FINALLY OFF #BITNAMI at least for #postgres. #cnpg

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

The Cloud Native Computing Foundation is putting on a flagship conference that's bringing together the #DevCommunity in #Amsterdam, Netherlands today through the 26th. That's four days of keynotes, breakouts, and a solutions showcase for the #OpenSource and #CloudNative communities.

Will you be attending? So will we! 👋

Stop by our booth (Kiosk 1263) and be sure to enter to win a 16GB RTX 5060TI while you're there 🔥

Event info: https://events.linuxfoundation.org/kubecon-cloudnativecon-europe/

#cncf #cnpg #k8s #kubecon #netherlands

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

Attending #KubeCon / #CloudNativeCon this 23-26 March in Amsterdam? We'll be there at Kiosk 1263, where you'll be welcome to enter to win a RTX 5060TI 16GB. 🎉

When you stop by, ask our team about running highly available #PostgreSQL on #Kubernetes with CloudNativePG (or even building production-worthy AI applications on such a setup!) if it's relevant to you. We'd love to help. ✨

Hope to see you there 🐘

#amsterdam #netherlands #programming #germany #deutschland #aidev #k8s #cnpg #cloudnative

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

KubeCon + CloudNativeCon Europe 2026 is coming up fast... March 23-26 is just around the corner. Have you registered yet? ➡️ https://events.linuxfoundation.org/kubecon-cloudnativecon-europe/

We are proud sponsors of the event. Come by Kiosk #1263 to 👋 and learn about our support for enterprise PostgreSQL infrastructure using #CloudNativePG.

💬 Be sure to ask us about pgEdge Enterprise Postgres for Kubernetes or our AI Toolkit - see you soon ✨

#amsterdam #netherlands #cnpg #kubernetes #k8s #kubecon #cloudnativecon #cloudnative #dba

💻 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

Turns out, I wasn't used to have proper GitOps...

But reverting the ansible playbook to a previous commit actually fixed all my issues (of uptime) in literal seconds...

Now back to bringing those cnpg clusters back up and running

#gitops #kubernetes #k3s #homelab #selfhosted #selfhosting #cnpg #postgres #cluster #uptime

@nixCraft I was working hard on getting #nextcloud to work in my #kubernetes cluster. It was a massive pain in the backside because the container does a bunch of horrendous rsync shenanigans when it initialise. This so bad that it chockes up the NFS storage provider AND the server. It basically shafted my whole cluster everytime I tried deploying Nextcloufq Only way out was using object storage and I decided on Garage on top of ZFS dataset. Now my #cnpg DBs do back-ups to that as well, two birds with one stone!

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

Our latest blog shows how to set up multi-master replication using pgEdge Enterprise Postgres, Spock, and CloudNativePG — creating a resilient, fully distributed PostgreSQL architecture that runs seamlessly on Kubernetes.

💡 High availability. Low latency. 100% open source.

👉 Read the full blog: https://www.pgedge.com/blog/multi-master-replication-using-pgedge-enterprise-postgres-with-spock-and-cloudnativepg

#programming #kubernetes #k8s #devops #cloudops #cnpg #cloudnativepg #postgresql #postgres #developers

@CloudNativePG:

👉 The only #PostgreSQL operator governed by a vendor-neutral community
👉 The only Postgres operator submitted to the #CNCF Sandbox
👉 The most popular Postgres operator on @github

For these reasons, and others (like it's Kubernetes-native approach and cloud-neutrality) we've chosen to support #CNPG to facilitate highly available, scalable #Postgres deployments on #Kubernetes with a developer-friendly deployment process.

Miss the announcement? 📖 https://www.pgedge.com/blog/pgedge-cloudnativepg-simplifying-distributed-postgres-on-kubernetes

#foss

🎉 Exciting news! As of today, we now support new container images (and an updated #Helm chart) that are built for compatibility with @CloudNativePG.

#CNPG is an open source K8s operator that automates the lifecycle of #PostgreSQL clusters using native K8s resources, recently accepted as a #CNCF Sandbox project and now the community standard for running #Postgres natively on #Kubernetes.

🐘 Read the blog: https://www.pgedge.com/blog/pgedge-cloudnativepg-simplifying-distributed-postgres-on-kubernetes

#coding #opensource #foss #oss #developers #programming #devops

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/

Next up was the update of the Grafana CNPG cluster from 16.2 to 17.6. Yet again, like for the harbor cluster, the minor update from 16.2 to 16.10 has worked, but the update from 16.10 to 17.6 has failed. The primary came up again without issue, but the secondary is failing with timeline divergence again.

I don't think I will keep CNPG in the long run. It doesn't seem to actually give me anything positive.

#HomeLab #CNPG

Just for the fun of it, today's thing to do while riding a Deutsche Bahn train: Continuing to migrate to CNPG's new Postgres images for the remainder of my clusters.

#HomeLab #CNPG

Ok I fudged up

Trying to recover the cluster as it stands, I deleted the forgejo db to recover it from the backups...

Thing is, I forgot to configure the backups when migrating from gitea, woops

Result, I managed to salvage some about-to-be-deleted filesystem from a node, and now I'm trying to restart the node momentarily to export a dump... FML

#homelab #selfhosted #cluster #k3s #cnpg #postgres #database #backup #recovery #filesystem #mistake

That's why I debug in prod /s

Found out a new issue with the k3s cluster, some of my pods started getting `Evicted` because of `DiskPressure`

But why ? There is plenty of disk space available ? All of my data is stored on secondary drives, so they shouldn't even clog the main disk !

Turns out, yes, all the big data is stored on secondary disks, but not my databases... Including their backups !

Some of my machines have ~30Gb of root space and an additional ~500Gb for big storage, so those little roots are getting filled up quite quickly (6 months) with those dbs...

Oh well, down to writing a new StorageClass for that effect I guess

#selfhosted #homelab #production #debug #kubernetes #k3s #cnpg #postgres #db #database #storage #linux #container

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.

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

Cluster rebuild project

Ok so the databases for the last two services have been shrunk* by removing their current backup targets and forcing a checkpoint.

The #Sharkey db is 25gb currently, I should look if there are ways to shrink it.

I still need to figure out exactly what is happening with backups that cause the db to grow like that. Something isn't being released properly

Also the Ceph dashboard ingress are shit, not quite shore why but I'm able to expose the service via a load balancer and that works


#Kubernetes #Homelab #Ceph #CNPG #Postgres

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

2e article dédié à #cloudnativepg 🚢 🐘

Cette fois, Pierrick aborde les services, le déploiement de #pgAdmin4 dans #kubernetes, et le rôle des labels => https://dali.bo/202501_cloudnativepg-2

#PostgreSQL #SGBD
#opensource #logicielsLibres
#cloud #CNPG

Currently on my regular service update again, and I saw a nice update in CloudNativePG: https://github.com/cloudnative-pg/cloudnative-pg/pull/4404

It's a new feature which will safely stop a cluster when the WAL files cannot be written due to disk space exhaustion. I had that problem when I set up my first cluster. It was throwing some quite hard to understand error messages.

#HomeLab #CNPG