pg_back
A PostgreSQL backup tool that dumps databases, globals, and configuration in flexible formats with encryption and cloud upload support.
What is pg_back?
pg_back is a comprehensive backup utility for PostgreSQL that extends beyond basic pg_dumpall functionality. It provides a unified way to dump databases, roles, tablespaces, and server configuration, addressing limitations in native PostgreSQL tools. The tool aims to be a robust, feature-rich alternative to manual pg_dump/pg_dumpall scripts, emphasizing flexibility, security, and integration with modern storage backends.
Database administrators and DevOps engineers managing PostgreSQL instances who need automated, secure, and flexible backup solutions. It's particularly useful for teams requiring integration with cloud storage, encryption, and complex purge policies.
Developers choose pg_back over native tools because it offers concurrent database dumps, multiple output formats per database, built-in encryption with age, and direct upload to various cloud storage providers (S3, GCS, Azure, B2, SFTP). It also provides advanced features like hot standby support, pre/post hooks, and configurable purge policies not available in standard PostgreSQL utilities.
Overview
Simple backup tool for PostgreSQL
Use Cases
Best For
- Automating PostgreSQL backups with concurrent dumps and multiple output formats.
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
