pgBackRest, a reliable backup and restore solution for PostgreSQL, shipped as a complete backup host with an encrypted repository and a scheduled backup chain.
pgBackRest is a reliable backup and restore solution for PostgreSQL, built for databases of any size. It takes full, differential and incremental backups, archives write ahead log continuously, compresses and encrypts everything it stores, verifies what it has written, and restores a cluster to a chosen point in time. It replaces hand rolled dump scripts with a tested, parallel, checksum verified backup chain that can be proven rather than assumed.
This image is a complete PostgreSQL backup host rather than a bare binary: a PostgreSQL server, pgBackRest configured against it, an encrypted repository on a dedicated volume, and a working schedule of full, differential and incremental backups with periodic verification. The same appliance can be repointed at a remote PostgreSQL server, or at object storage such as Azure Blob or S3, by editing configuration alone.
cloudimg ships a backup host that has already proven itself. On the first boot of every instance the PostgreSQL superuser password and the repository encryption passphrase are generated uniquely for that machine and written to a file only the root user can read, the backup stanza is created for that machine, and an initial full backup is taken and verified, so the instance is protecting data before anyone logs in. Nothing is baked in: the image carries no password, no repository passphrase and no backup data at all. The database listens on the loopback interface only, so no database port is exposed to the network, and the sole inbound port is SSH. The repository lives on its own dedicated volume so backup growth can never fill the operating system disk. A self test ships in the image that takes a backup, destroys a table and restores it, so the restore path can be proven on demand rather than trusted. The base is fully patched with unattended security updates enabled, and every deployment is paired with a step by step deploy guide and backed by 24/7 cloudimg support.