> Expert > Backup and Restore Agents > Databases > PostgreSQL

Backup

What Gets Backed Up

Dump Based Backup

  • PostgreSQL system databases

  • PostgreSQL user databases

File System Based Backup

  • PostgreSQL databases (data and logs)

  • Log files

What Does Not Get Backed Up

Use the File System Agent to back up the below mentioned components

  • PostgreSQL application files

  • Operating system data.

Note

If TDE or Always Encrypted are enabled, then the following rules apply:

  • Backups are not affected.

  • If you have a storage policy that uses deduplication, then the deduplication ratio is low or non-existent.

  • If the restore destination is a different client or instance, then the database administrator must back up the encryption key, and present it to the destination instance.

Procedure

  1. From the CommCell Browser, navigate to Client Computers |<Client> | PostgreSQL | <Instance> | DumpBasedBackupSet.

    Right-click the default subclient and click Backup.

    Backup6

  2. Click Full as backup type and then click Immediate.

  3. Click OK.

    backup2

  4. You can track the progress of the job from the Job Controller window of the CommCell console.

    backup3

  5. Once the job is complete, view the job details from the Backup History. Right-click the Subclient and select Backup History.

    backup4

  6. Click OK.

    imagesklzzwxh:0003ackupklzzwxh:0004nix_allklzzwxh:0005ackup_history_filter.png

  7. You can view the following details about the job by right-clicking the job:

    • Items that failed during the job

    • Items that succeeded during the job

    • Details of the job

    • Events of the job

    • Log files of the job

    • Media associated with the job

    backup5

Loading...