Postgres runs as a microservice on the container-style architecture on CoreOS. UpGuard uses the continuous
archiving method of backup by ensuring that PostgreSQL maintains a write ahead log (WAL) in the
sub-directory inside of the
$PG_DATA directory. The existence of these WAL files help to bring the system
back to a current state from a file system backup in conjunction with a replay of the backed-up WAL files.
Normally, should the database file directory be destroyed or corrupted, restarting the CoreOS appliance will automatically restore the database from the latest file system level backup along with the WAL files on booting up.
Downloading Nightly Backup Files
We have provided a set of Windows and Unix/Linux scripts for running a scheduled download of the nightly backups for your use in the respective sections below. The Linux script can be run with a crontab task as specified in the comments, or if you’re on Windows, a Scheduled Task can be run for the Powershell script.
If you wish to do so manually, the endpoint for accessing the backups can be found on your appliance URL as follows:
https://<appliance IP or hostname>/backups
Should you wish to access the backups endpoint to retrieve the file system level backup file, please contact your UpGuard technical account manager. Username and password authentication will be required for access to your backup files for securing your data.
Linux Download Script
In the event that you wish to perform a Point-in-Time recovery of your database due to an incident, please contact the UpGuard support team at firstname.lastname@example.org to schedule a remote session with us to better assist you.