Configuring incremental backup

Last Updated : Jun 17, 2022 |

About this task

You can run an immediate incremental backup and view a list of incremental backups.

Warning:

You should schedule backups during low traffic times or less busy as they can use resources on the database.

Procedure

  1. Log in to the Cluster Control Manager (CCM) console as the customer user.
  2. Switch to being the root user by entering the command su.
  3. To run the Analytics Administration script, use the following command:

    ccm release orca analytics

  4. Select Database by pressing the corresponding number.
  5. To select the Database backup option, enter the corresponding number.
  6. To take an incremental backup of the database, select the Incremental backups option by entering the corresponding number.
  7. To select the Reset Baseline for Incremental Backups option, enter the corresponding number.

    When you reset the baseline for Incremental backup, CCM takes a full pgBackRest backup on which the future Incremental backups will be based on.

    Note:

    You must run Reset Baseline for Incremental Backups before running the Incremental backup.

  8. To select the Run an Incremental backups option, enter the corresponding number.

    Run this option if you want to manually run an ad-hoc Incremental backup.

  9. In the Proceed to run an incremental backup option, type y.

    Entering n cancels the operation.

    An incremental backup is completed. The backup file is compressed in .gz file format and stored on NFS.

  10. Return to the previous page by entering b.
  11. Quit the current page by entering q.
  12. Return to the main menu by entering m.
  13. To view the list of the incremental database backups, select the List incremental backups option by entering the corresponding number.

    The page displays the list of incremental backups. The latest backup is listed at the bottom of the list with its timestamp.

  14. Return to the previous page by entering b.
  15. Quit the current page by entering q.
  16. Return to the main menu by entering m.