Today's #adventuresInSelfHosting, I was having trouble with #cloudnativePG where I'd always have n-1 pods stable and they'd constantly restart between the replicas in a massive loop, then eventually switch with the primary and continue the process. So, I set the instance count to 3 so there'd at least be one stable read replica at a time.

I finally found out what was wrong. I have my #cnpg cluster in the postgresql-system namespace and I happened to see that I had an operator running in the default cnpg-system namespace. I don't know how long it had been there, so both it and the one in my namespace were both competing for the state. Deleting and cleaning up that old cluster brought immediate stability.

I also realized that I wasn't overriding the default #php configuration for #pixelfed, so when I uploaded an image taking on my phone, the web server would restart. I bumped the php memory up to 1GB for now. For the expected userbase for the upcoming #keyboardvagabond #fediverse space, this should be fine.

Right now the services are running well, but I need to do more testing and get mastodon into an "interesting" state for new visitors. Pixelfed seems the hardest for me in terms of getting content onto the server so that it doesn't look barren.

The todo list for now is:

  • comprehensive testing
  • get hcaptcha working on all services, or find an alternative
  • add the community block list to pixelfed
  • make pixelfed look interesting (any tips would be greatly appreciated!)
  • get bookwyrm running
  • create an intro landing website for www subdomain
  • get the #soonTM mascot in there! I'm super excited for what comes out of that
  • set up mastodon SSO/OAuth

It's getting close! The services are essentially ready, just not necessarily turned on for signups until I'm ready for a pre-launch or full launch. I want to make sure things are in a good state.

But with the 2 node #kubernetes #cluster, I think things should be good!
By then end, it should look like:

We’re back for the September cohort of the CNCF’s LFX Mentorship Program—this time with 3 exciting CloudNativePG projects and a call for new mentees:
🌟 Our proposed projects:
🔧 Refresh cnpg-i-hello-world (plugin dev)
🔥 Chaos testing for fault tolerance
📚 Rebuild multi-version docs with Docusaurus

📅 Apply by August 12
💻 Info: https://cloudnative-pg.io/blog/2025-term3-lfx-cncf-mentorship/
#PostgreSQL #Kubernetes #CNCF #LFXMentorship #OpenSource #CloudNativePG #DevOps

CloudNativePG part of LFX Mentorship again - sign up as a mentee!

We have proposed 3 projects for the September cohort of the CNCF’s LFX Mentorship program, and we’re looking for mentees to sign up and receive a stipend for their work.

CloudNativePG - PostgreSQL Operator for Kubernetes

Moved the last #PostgreSQL cluster from Crunchy Postgres to #CloudNativePG.💪

This was the final step in the long overdue migration from #RKE to #RKE2.

What at ride but went pretty smoothly to be honest!🥳

#kubernetes #homelab #diy

Had to downgrade Immich back to a pre 1.133 (here 1.132.3) because of the problem with the pgvector.rs to VectorChord migration on CloudNativePG...

This time, it seems quite complex, and will need more proper time allocated...

#homelab #selfhosted #immich #cloudnativepg #cnpg #postgres

Det funkar! Det funkar! CloudNative PG backups i MinIO S3-compatible object storage.

#Selfhosted #Selfhosting #Kubernetes #K8s #MinIO #ObjectStorage #CloudNativePG #CNPG

Wohooo! Trodde jag fuckat upp #CloudNativePG-db:n för min #FreshRSS-deployment, men det var tydligen bara någon webhook som var kvar från förr när jag hade Longhorn. Den stoppade CNPG podden från att starta.

Hade inte varit någon enorm förlust, men next up blir att fixa backups för CNPG. Nu har jag iallafall [väldigt snart] en ny fin #Miniflux deployment att migrera mina #RSS:er till.

#Kubernetes #K8s

Första stateful applikationen live i #Kubernetes-klustret! #FreshRSS med CNPG för att hantera databasen. Får bli lite hackigt med uppsättningen av första användaren bara, för att den inte ska nollställa lösenordet. Eller så lagrar jag adminanvändarens lösenord i en secret kanske.

Tappar lite plugins som jag inte löst än. Enklaste sättet att få in dem är antagligen bara att göra en egen image antar jag.

#PostgreSQL #CloudNativePG #CNPG #selfhosted #selfhosting #homelab

Updating my CloudNativePG Clusters to postgresql:17.5 broke wal archiving to my Ceph S3 Object Store. Here's a new blog post describing the fix:

https://www.beyondwatts.com/posts/debugging-barman-xamzcontentsha256mismatch-error-after-upgrading-to-postgresql175/

#homelab #cloudnativepg

beyondwatts | Debugging Barman XAmzContentSHA256Mismatch error after upgrading to postgresql:17.5

In an effort to keep my home cluster up to date, I upgraded CloudNativePG to v1.26 and the associated database clusters to cloudnative-pg/postgresql:17.5. All seemed ok with the upgrade until a couple of days later when the cluster primary instance PVCs started to run out of space. wal archiving had stopped working with the error message:

beyondwatts

Great new v1.26 release of CloudNative-PG out, providing scalable and highly available Postgres on Kubernetes.

https://cloudnative-pg.io/releases/cloudnative-pg-1-26.0-released/

Glad to see the in-place upgrades and extensions. Intrigued about the backup plugins, as I'm interested in integrated logical backups (pg_dump).

Check it out!

#Kubernetes #DataOnKubernetes #cloudnativepg #cnpg

CloudNativePG 1.26.0 and 1.25.2 Released!

The CloudNativePG community is excited to announce version 1.26.0, featuring powerful new capabilities for PostgreSQL on Kubernetes, alongside the maintenance release 1.25.2. This release also includes 1.24.4, the final patch for the now-retired 1.24.x series.

CloudNativePG - PostgreSQL Operator for Kubernetes

Migrating all of my CloudNativePG cluster's s3 backup endpoints was... Weirdly easy

We'll see during the night if everything goes well and only green is to be reported tomorrow morning

#Homelab #selfhosted #s3 #psql #cloudnativepg #kubernetes #k3s