Skip to content

On-demand and scheduled backups

Initiate an immediate backup for hands-on control, or schedule one if you prefer the automated reliability of scheduled backups.

Create on-demand backups

On-demand backups give you immediate control over when and what data to back up. One-time backups can be particularly useful when you need to safeguard critical information before making significant changes to your database.

Important

There are few limitations to consider when working with PostgreSQL’s on-demand backups. For detailed information, refer to the limitations section.

To create a backup now:

  1. Go to Settings > Backup Storages and check that you have an available S3-compatible location for storing backups. Otherwise, create a backup location so Everest can store backup artifacts for the database.
  2. Go to the Databases view and select the database which you want to back up.
  3. Navigate to the Backups tab and click Create backup > Now.
  4. In the Create Backup pop-up, change the default backup name if required, select an available backup location, and then click Create.

Schedule a backup

Schedule a backup when you want your backups to occur automatically at predetermined intervals. This automation reduces the risk of human error and ensures that your data is consistently backed up without requiring your constant intervention.

Important

There are few limitations to consider when working with PostgreSQL’s scheduled backups. For detailed information, refer to the limitations section.

To configure a backup schedule:

  1. Go to Settings > Backup Storages and check that you have an available AWS S3-compatible location for storing backups. Otherwise, create a backup location so Everest can store backup artifacts for the database.
  2. Go to the Databases view and select the database which you want to back up.
  3. Navigate to the Backups tab and click Create backup > Schedule.
  4. Change the default backup name if required, and configure the frequency and start time for the backups.

    Important

    Make sure that the schedule you specify here does not create overlapping jobs or overhead on the production environment. Also, check that your specified schedule does not overlap with production hours.

  5. Click Create. All scheduled backups for the current DB will be listed at the top so you can review the schedules that are currently generating backup artifacts.

Edit a scheduled backup

To edit a schedule that is currently generating backup artifacts:

  1. Go to the Databases view and select the DB for which backups have been scheduled.
  2. Select the Backups tab and expand the Schedule box.
  3. Select the schedule you want to update, click the ellipsis and select Edit.
  4. Update the schedule and click Save.

Next step

Enable PITR Restore backups

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.