# Optimizing Databases on Kubernetes: Kubernetes Backup and Recovery with CNPG and ZFS Snapshots

DevFeed: [Optimizing Databases on Kubernetes: Kubernetes Backup and Recovery with CNPG and ZFS Snapshots](<https://devfeed.tech/articles/optimizing-databases-on-kubernetes-kubernetes-backup-and-recovery-with-cnpg-and-zfs-snapshots-22280.md>)

Original publisher: [Read original article](<https://www.ardanlabs.com/blog/2025/01/optimizing-databases-on-kubernetes-ep5-kubernetes-backup-and-recovery-with-cnpg-and-zfs-snapshots.html>)

Published: 2024-12-30T00:00:00Z

Content type: tutorial

Language: en

Sources: [William Kennedy](<https://devfeed.tech/sources/william-kennedy.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [Database](<https://devfeed.tech/topics/database.md>), [Automation](<https://devfeed.tech/topics/automation.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Compression](<https://devfeed.tech/topics/compression.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>)

Tags: [automation](<https://devfeed.tech/tags/automation.md>), [backup](<https://devfeed.tech/tags/backup.md>), [cloud-block-storage-benchmarking](<https://devfeed.tech/tags/cloud-block-storage-benchmarking.md>), [compression](<https://devfeed.tech/tags/compression.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [kubernetes-database-performance](<https://devfeed.tech/tags/kubernetes-database-performance.md>), [kubernetes-database-throughput](<https://devfeed.tech/tags/kubernetes-database-throughput.md>), [kubernetes-local-storage-pros-and-cons](<https://devfeed.tech/tags/kubernetes-local-storage-pros-and-cons.md>), [kubernetes-production-grade-storage](<https://devfeed.tech/tags/kubernetes-production-grade-storage.md>), [kubernetes-storage-benchmarking](<https://devfeed.tech/tags/kubernetes-storage-benchmarking.md>), [kubernetes-storage-efficiency](<https://devfeed.tech/tags/kubernetes-storage-efficiency.md>), [kubernetes-storage-trade-offs](<https://devfeed.tech/tags/kubernetes-storage-trade-offs.md>), [kubernetes-zfs-advantages](<https://devfeed.tech/tags/kubernetes-zfs-advantages.md>), [optimizing-postgresql-on-kubernetes](<https://devfeed.tech/tags/optimizing-postgresql-on-kubernetes.md>), [pgbench-kubernetes-testing](<https://devfeed.tech/tags/pgbench-kubernetes-testing.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [provisioning](<https://devfeed.tech/tags/provisioning.md>), [rancher-local-path-performance](<https://devfeed.tech/tags/rancher-local-path-performance.md>), [recovery](<https://devfeed.tech/tags/recovery.md>), [replication](<https://devfeed.tech/tags/replication.md>), [s3](<https://devfeed.tech/tags/s3.md>), [snapshots](<https://devfeed.tech/tags/snapshots.md>), [zfs-compression-benefits](<https://devfeed.tech/tags/zfs-compression-benefits.md>), [zfs-lz4-compression](<https://devfeed.tech/tags/zfs-lz4-compression.md>), [zfs-vs-cloud-storage](<https://devfeed.tech/tags/zfs-vs-cloud-storage.md>)

## AI overview

This final episode in the Optimizing Databases on Kubernetes series demonstrates PostgreSQL backup and recovery with CNPG and ZFS snapshots. It covers WAL shipping to S3-compatible object stores, automated backups, point-in-time recovery, and rapid database cloning using compressed ZFS snapshots.

## Source excerpt

Introduction: In the final episode of the Optimizing Databases on Kubernetes series, Jérôme Petazzoni dives into advanced backup and recovery techniques for PostgreSQL, showcasing how CNPG (Cloud Native PostgreSQL) and ZFS snapshots ensure durability and fast recovery in production environments. This episode focuses on safeguarding data with comprehensive backup strategies, point-in-time recovery, and rapid database cloning, while leveraging ZFS's efficiency for optimized storage performance. Comprehensive Backup Strategies: Exploring backups with CNPG, including write-ahead logs (WAL) and volume snapshots.