#throwback PostgreSQL on Kubernetes made practical ☸️ Vojtěch Mareš introduces CloudNativePG and shows how to run highly available Postgres on k8s—almost like a managed service. Real production lessons from SaaS and enterprise setups.
▶️ Watch now! https://www.youtube.com/watch?v=ODWBtOXbm6k&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=5
#PostgreSQL #PGDay #PPDD #Kubernetes #CloudNativePG
First time blogging in nearly six years. I was surprised how much digging I had to do to figure out how to migrate from postgres-operator to @CloudNativePG, and since I feel like #cloudnativepg is good enough that people *should* consider migrating, I wanted to make it easier for others.
https://shawnwilsher.com/2026/01/migrating-from-zalados-postgres-operator-to-cloudnativepg/
We've been running #CloudNativePG at Brella for months now. Honestly? Haven't missed Cloud SQL once.
Failover works, backups work, PgBouncer's built in. It's just #Postgres - no black box nonsense.
Pleasanterをk3s+Rancher+Longhorn+CNPGで構築してみる 〜絶対に落ちない社内システムを目指して〜
https://qiita.com/YoheiZuho/items/4f44d104b1be9d19f93c?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items
Get the flexibility of scaling #PostgreSQL from any point - even a single-primary node - up to multiple nodes across multiple regions.
Our #OpenSource components give you write-anywhere, read-anywhere active-active capabilities with pure #Postgres, and our variety of deployment options mean you can leverage containers (including #Docker compose or #Helm charts with #CloudNativePG), virtual machines, & bare metal to do it.
Learn more: https://www.pgedge.com/get-started
Now, you can use open-source pgEdge components designed for high-availability & multi-master replication combined with #CloudNativePG for cloud-native #PostgreSQL orchestration.
Our goal was to make it easy for developers to adopt powerful open-source and vendor lock-in free solutions.
How are you currently managing your Postgres deployments on Kubernetes? 💬
Find the full video on YouTube: https://www.youtube.com/watch?v=r442LvNxaoE
#postgres #kubernetes #cloudnative #devops #opensource #database #devcommunity
Today I set up #k8s in my MacBook using #orbstack. Used #traefik for ingress and #cloudnativepg as persistent for #keycloak. Now I can start my POC with multiple IDPs/user federation and organizations
Как и зачем мы написали собственное опенсорс-решение для бэкапов CloudNativePG в Stackland
Всем привет! В этой статье поговорим про бэкапы PostgreSQL в Kubernetes через призму самого популярного опенсорс-оператора для этой СУБД — CloudNativePG. Мы расскажем о том, как внедрение нового решения на основе WAL-G позволило ускорить резервное копирование и восстановление больших баз данных и поделимся своим опытом доработки CloudNativePG. На связи Иван Архипов, ведущий разработчик в команде платформы данных в Yandex Cloud, и я приглашаю под кат всех, кому интересна эксплуатация PostgreSQL в Kubernetes!
https://habr.com/ru/companies/yandex_cloud_and_infra/articles/971408/
Сколько производительности съедает Kubernetes: сравниваю native PostgreSQL и CloudNativePG в Yandex Cloud
В этой статье я руками сравнил производительность PostgreSQL на «голой» VM в Yandex Cloud и в кластере CloudNativePG в Kubernetes. Один и тот же конфиг, одинаковые ресурсы, fio и pgbench, несколько типов хранилищ — и просадка до ~40% при работе через cnpg. Разбираемся, где теряются TPS: на диске, в сети или в оболочке k8s, показываем все цифры в таблицах и схемах прохождения запроса «до VM» и «до Pod’а» — и в конце честно отвечаем, стоит ли игра свеч.
https://habr.com/ru/articles/967626/
#postgres #cloudnativepg #pgbench #kubernetes #perfomance #yandexcloud
Need an open-source approach to deploying distributed #PostgreSQL on #Kubernetes? Paul Rothrock covers deploying 100% open source pgEdge extensions with #CloudNativePG using Helm here: https://www.youtube.com/watch?v=r442LvNxaoE
If you have questions, you're welcome to talk live with our engineers and ask questions during a (free) live demo next week, November 20 @ 1PM EST. Register anytime: https://us02web.zoom.us/webinar/register/WN_CLL5Y6nbSCGrEPSGuyMunA#/registration
#programming #devops #dataengineering #postgres #k8s #helm #containerization #softwarearchitecture
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
Monitoring is slowly getting up and running.. now if only I knew how to read all that! ;-)
🌐 Upcoming Webinar: Distributed Postgres on Kubernetes
Mission-critical applications demand always-on infrastructure — but relying on a single cloud region or provider puts you at risk. In our next webinar, learn how CloudNativePG + Spock + pgEdge help you deploy PostgreSQL across Kubernetes clusters for true multi-cloud resilience.
🗓️ Reserve your spot: https://us02web.zoom.us/webinar/register/WN_CLL5Y6nbSCGrEPSGuyMunA
#Postgres #Kubernetes #CloudNativePG #DistributedPostgres #OpenSource #Webinar #pgEdge #PostgreSQL #LearnToCode
💡 Want to join the discussion about our newest announcement?
Tell us any feedback you have about using pgEdge with CNPG, whether it's the developer experience or thoughts on the collaboration in general, on the HackerNews announcement thread, anytime:
💬 https://news.ycombinator.com/item?id=45823632
#programming #cloud #cloudnativepg #devops #dataengineering @CloudNativePG
🌕 數位社會遷移至 Hetzner：雲端開銷節省 76% 並擴增三倍容量
➤ 精打細算，雲端優化：從 AWS/DigitalOcean 轉向 Hetzner 的實戰經驗
✤ https://digitalsociety.coop/posts/migrating-to-hetzner-cloud/
本文記錄了 DigitalSociety 如何將其雲端基礎架構從 AWS 和 DigitalOcean 遷移至 Hetzner 的過程，成功將每月的雲端開銷大幅降低 76%，同時將運算容量擴增了三倍。作者詳細闡述了遷移前的架構、面臨的成本壓力，以及選擇 Hetzner 的原因。文章也技術性地剖析了新的技術堆疊，包括 Hetzner 的硬體、Talos Linux 作為操作系統、CloudNativePG 管理 PostgreSQL，以及 Ingress NGINX Controller 等，並說明瞭如何透過 Terraform 和 GitHub
#雲端遷移 #Hetzner #AWS #DigitalOcean #Kubernetes #CloudNativePG #Talos Linux
It gets even better. I've now applied compression to all of my CNPG database clusters, and the transfers produced for the CNPG backup bucket went from around 280 kB/s to 2.56 kB/s.
Okay, just enabled bzip2 compression for the uploads of the WALs and base backups. The WAL files are around 16MB for my Masto database cluster, for example. Now they're between 200kB and 700kB. And at least in my metrics I can't see any considerable increase in CPU usage. Good tradeoff. The only thing is that restore is slower, but I'm lucky to not have to do restores too often.
It would be nice if I could configure something like a "restore precision", where I could say: For one week, I want "any point in time", but for the other three weeks, I only need to be able to restore daily. But it doesn't seem to work like that.
And it's not like I'm running out of storage any time soon. So the first step will be to just flip on WAL compression before backup and see what that does.
2/2
Initial analysis shows that the size of the CNPG backups comes purely from the WALs. I've got a retention period of 30d configured, and the way CNPG works, that allows me to restore to any point in time within that interval. But that also means a hell of a lot of data being stored. For example, my piddly Bookwyrm database has 96GB worth of backups already.
1/2
New blog post: https://blog.mei-home.net/posts/cnpg-image-updates/
This one is a short report about my experience updating to CloudNativePG's new Postgres operand images and a few major Postgres version updates.
