The page has been translated by Gen AI.

DB Backup and Restore

Users can set up PostgreSQL(DBaaS) backup through the Samsung Cloud Platform Console and restore using backed up files.

Backing Up PostgreSQL(DBaaS)

PostgreSQL(DBaaS) provides data backup functionality based on its own backup commands. Additionally, through backup history viewing and backup file deletion functionality, it provides a backup environment optimized for data protection and management.

Setting Up Backup

For PostgreSQL(DBaaS) backup setup method, please refer to Creating PostgreSQL(DBaaS).

Follow these steps to modify backup settings for created resources.

Caution
  • For stable backup, it is recommended to add a separate BACKUP storage or sufficiently increase storage capacity. Especially when backup target data exceeds 100 GB and there are many data changes, please secure additional storage corresponding to approximately 60% of data capacity. For adding and increasing storage, please refer to Adding PostgreSQL(DBaaS) Storage, Expanding PostgreSQL(DBaaS) Storage guides.
  • When backup is set, backup is performed at the specified time after the set time, and additional charges occur depending on backup capacity.
  • When backup setting is changed to Not Set, backup execution stops immediately, and stored backup data is deleted and can no longer be used.

Follow these steps to set up backup.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource to set backup. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the Modify button in the backup item. The Backup Settings popup window will open.
  5. To set backup, click Use in the Backup Settings popup window, select retention period, backup start time, and Archive backup cycle, then click the Confirm button.
    • To stop backup settings, uncheck Use in the Backup Settings popup window and click the Confirm button.

Viewing Backup History

Notice
You can set notifications for backup success and failure through the Notification Manager product. For detailed user guide on notification policy settings, please refer to Creating Notification Policy.

Follow these steps to view backup history.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource to view backup history. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the Backup History button. The Backup History popup window will open.
  5. In the Backup History popup window, you can check backup status, version, backup start datetime, backup completion datetime, and capacity.

Deleting Backup Files

Caution
Backup files cannot be restored after deletion. Please verify that it is unnecessary data before deletion.

Follow these steps to delete backup history.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource to view backup history. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the Backup History button. The Backup History popup window will open.
  5. In the Backup History popup window, check the file to delete and then click the Delete button.

Restoring PostgreSQL(DBaaS)

In case of failure or data loss requiring restoration from backup files, you can restore based on a specific point in time through the restore function. When PostgreSQL(DBaaS) restore is performed, a new server is created with the OS image at the initial provisioning time, DB is installed with the version of that backup time, and restoration proceeds with DB configuration information and data.

Caution
To perform restore, at least the same capacity as the data type Disk capacity is required. If Disk capacity is insufficient, restore may fail.

Follow these steps to restore PostgreSQL(DBaaS).

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) Resource List page, click the resource to restore. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the Database Restore button. You will move to the Database Restore page.
  5. Enter the corresponding information in the Database Restore Configuration area and then click the Complete button.
    Category
    Required
    		Detailed Description
    Restore TypeRequiredSetting the point in time user wants to restore
    • Backup Point(Recommended): Restore based on backup file. Select from the list of backup file time points displayed in the list
    • User-Specified Point: Restore to a point user wants within the backupable time range. The recoverable period can restore from the initial backup start time to 1 hour/30 minutes/10 minutes/5 minutes before current time according to Archive backup cycle setting value. Select the date and time to backup
    Server Name PrefixRequiredServer name of restore DB
    • Enter 3~16 characters starting with lowercase English letters, using lowercase letters, numbers, and special characters(-)
    • Actual server name is created with a postfix like 001, 002 attached based on server name
    Cluster NameRequiredCluster name of restore DB
    • Enter 3 ~ 20 characters using English letters
    • Cluster is a unit that groups multiple servers
    Service Type > Server TypeRequiredServer type where restore DB will be installed
    • Standard: Standard specifications commonly used
    • High Capacity: Large-capacity servers with 24vCore or more
    Service Type > Planned ComputeOptionalStatus of resources with Planned Compute set
    • In Use: Number of resources with Planned Compute set that are currently in use
    • Set: Number of resources with Planned Compute set
    • Coverage Preview: Amount applied by Planned Compute per resource
    Service Type > Block StorageRequiredBlock Storage settings used by restore DB
    • Basic OS: Area where DB engine is installed
    • DATA: Storage area for table data and archive files, etc.
      • Applied identically with Storage type set in original cluster
      • Enter capacity as a multiple of 8 in the range of 16 ~ 5,120
    • Additional: Storage area for DATA, Archive, TEMP, Backup data
      • Applied identically with Storage type set in original cluster
      • Only DATA, TEMP, Archive purposes can be added in restore DB.
      • Select Use and then enter storage purpose and capacity
      • To add storage, click the + button, to delete, click the x button
      • Capacity can be entered as a multiple of 8 in the range of 16 ~ 5,120, and can create up to 9
    Database UsernameRequiredDatabase username set in original DB
    Database Port NumberRequiredDatabase Port number set in original DB
    IP Access ControlOptionalIP address to access restore DB
    • Enter in IP format (example: 192.168.10.1) or CIDR format (example: 192.168.10.1/32, 192.168.10.1/32) and click the Add button
    • To delete entered IP, click the x button next to the entered IP
    Maintenance PeriodOptionalDB maintenance period
    • When Use is selected, set day of week, start time, and duration
    • It is recommended to set a maintenance period for stable DB management. Patching is performed at the set time and service interruption occurs
    • If set to Not Used, Samsung SDS is not responsible for problems caused by unapplied patches.
    TagsOptionalAdd tags
    • Click the Add Tag button and then enter or select Key, Value values
    Table. PostgreSQL(DBaaS) Restore Configuration Items
Managing DB Service
Configuring Read Replica