-
How to restore backups of PostgreSQL from S3 using Barman and barman-cloud-backup
In my previous post, I showed how to automate backups of a PostgreSQL database to S3 using Barman and barman-cloud-backup. Step 1: verify hardware architecture and PostgreSQL version For a successful restore, Barman requires that the hardware architecture and PostgreSQL version are both identical. You can verify these with some simple terminal commands: Run these…
-
How to automate backups of a PostgreSQL server using Barman/barman-cloud-backup to S3
I was surprised not to find many up to date instructions on this. I have a few basic requirements: After a bit of playing around, I decided to use Barman for the backups – it’s significantly easier to configure and use than pgBackRest and has native support for backing up to S3, point-in-time restore, and…