A naukri.com initiative
Dev
1w
67
Image Credit: Dev
Streaming PostgreSQL Backups with pgrwl: Now with Time & Count-Based Retention!
- pgrwl, a cloud-native WAL receiver and backup agent for PostgreSQL, has released a new feature for streaming basebackups with automated retention.
- The new feature includes time and count-based retention policies for managing backups.
- pgrwl can now schedule basebackups, stream backups to remote storage, and enforce retention policies like retaining a certain number of backups or backups for a specific duration.
- This new feature simplifies PostgreSQL cluster backup management without the need for external scripts or schedulers.
- pgrwl performs streaming basebackups using the replication protocol, optional compression, and encryption, uploading backups directly to remote storage during the process.
- This design reduces time-to-storage and aligns well with Kubernetes-native workflows.
- After each successful backup, pgrwl automatically lists, sorts, and deletes old backups based on the defined retention policy.
- The tool is especially useful for Kubernetes environments, providing streaming basebackups, WAL receiver capabilities, pluggable storage options, compression/encryption functionalities, and seamless integration with Kubernetes.
- This tool aims to address challenges faced by teams managing PostgreSQL in containerized environments, offering a reliable backup solution with observability and retention management.
- Interested users can try out pgrwl through the GitHub repository and provide feedback or contribute to the project.
- pgrwl simplifies backup management for PostgreSQL in cloud-native environments by introducing streaming basebackups and automated retention policies.
- The tool allows scheduling basebackups, streaming backups directly to remote storage, and enforcing retention policies for backup management.
- pgrwl performs streaming basebackups using replication protocols, compression, and encryption, reducing time-to-storage and integrating well with Kubernetes workflows.
- After each backup, pgrwl automatically handles retention by listing, sorting, and deleting old backups based on defined policies.
- The tool is beneficial for Kubernetes environments, offering features like WAL receivers, pluggable storage options, compression, encryption, and seamless Kubernetes integration.
- pgrwl aims to alleviate backup challenges for PostgreSQL in containerized environments with its reliable backup solution and retention management features.
- Users can access pgrwl through the GitHub repository to test the tool and provide feedback or contribute to its development.
Read Full Article
4 Likes
For uninterrupted reading, download the app