▲ | JimBlackwood 13 hours ago | |
Not OP, but: Barman on the host with a cronjob for physical backups and as archive/restore command for wal archiving and point in time recovery. Another cronjob for logical backups. They all ship to some external location (S3/SFTP) for storage. I like the above since it adds minimal complexity, uses mainly native postgres commands and gives pretty good reliability (in our setup, we’d lose the last few minutes of data in the absolute worst case). |