The page has been translated by Gen AI.

DB Backup and Recovery

The user can set up a backup of PostgreSQL(DBaaS) through the Samsung Cloud Platform Console and restore it with the backed-up file.

PostgreSQL(DBaaS) backup

PostgreSQL(DBaaS) provides a data backup feature based on its own backup command, and also provides an optimized backup environment for data protection and management through backup history checking and backup file deletion functions.

Setting up backup

The method of setting up a backup of PostgreSQL(DBaaS) is described in PostgreSQL(DBaaS) creation guide.

To modify the backup settings of the generated resource, follow these steps.

Caution
  • For stable backup, it is recommended to add a separate BACKUP storage or to sufficiently expand the storage capacity. Especially when the backup target data exceeds 100 GB and there are many data changes, please secure additional storage equivalent to about 60% of the data capacity. For storage addition and expansion methods, refer to the PostgreSQL(DBaaS) Add Storage, PostgreSQL(DBaaS) Expand Storage guides.
  • If backup is set, backup is performed at the specified time after the set time, and additional fees are incurred depending on the backup capacity.
  • If the backup setting is changed to unset, the backup operation will be stopped immediately, and the saved backup data will be deleted and can no longer be used.

To set up a backup, follow these steps.

  1. All Services > Database > PostgreSQL(DBaaS) menu is clicked. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
  3. PostgreSQL(DBaaS) list page, click the resource to set the backup. It moves to the PostgreSQL(DBaaS) details page.
  4. Click the Edit button of the backup item. The Backup Settings popup window will open.
  5. If you set up a backup, click Use in the Backup Settings popup window, select the retention period, backup start time, and Archive backup cycle, and then click the Confirm button.
    • If you want to stop the backup setting, uncheck Use in the Backup Setting popup window and click the OK button.

Check Backup History

Notice
To set up notifications for backup success and failure, you can set it up through the Notification Manager product. For a detailed usage guide on setting up notification policies, please refer to Creating a Notification Policy.

To view the backup history, follow these steps.

  1. 모든 서비스 > Database > PostgreSQL(DBaaS) menu should be clicked. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
  3. PostgreSQL(DBaaS) list page, click the resource to check the backup history. It moves to the PostgreSQL(DBaaS) details page.
  4. Click the Backup History button. The Backup History popup window will open.
  5. Backup History popup window where you can check the backup status, version, backup start time, backup completion time, and capacity.

Deleting backup files

Caution
Backup files cannot be restored after deletion. Please make sure to confirm if the data is unnecessary before deleting it.

To delete the backup history, follow these steps.

  1. All services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
  3. PostgreSQL(DBaaS) list page, click the resource to check the backup history. It moves to the PostgreSQL(DBaaS) details page.
  4. Click the Backup History button. The Backup History popup window opens.
  5. Backup History popup window, check the file you want to delete, and then click the Delete button.

PostgreSQL(DBaaS) recovery

In the event of a failure or data loss that requires restoration from a backup file, the recovery function can be used to restore to a specific point in time. When performing a PostgreSQL (DBaaS) recovery, a new server is created with the OS image at the initial provisioning time, the DB is installed with the version at the backup point, and the recovery proceeds with the DB configuration information and data.

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

To restore PostgreSQL(DBaaS), follow these steps.

  1. All services > Database > PostgreSQL(DBaaS) menu is clicked. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
  3. PostgreSQL(DBaaS) resource list page, click the resource you want to restore. It moves to the PostgreSQL(DBaaS) detail page.
  4. Database Recovery 버튼을 클릭하세요. Database Recovery 페이지로 이동합니다.
  5. Database Recovery Configuration area, enter the corresponding information, and then click the Complete button.
Classification
Necessity
Detailed Description
Recovery TypeRequiredSet the point in time to recover
  • Backup Point (Recommended): Recover based on the backup file. Select from the list of backup file timestamps displayed in the list
  • Custom Point: Recover to a user-desired point in time within the range where backup is possible. The recoverable period is based on the Archive backup cycle setting value, and can be recovered up to 1 hour/30 minutes/10 minutes/5 minutes before the current time from the initial backup start time. Select the date and time you want to back up
Server name prefixRequiredServer name of the recovery DB
  • Start with lowercase English letters, using lowercase letters, numbers, and special characters (-) to input 3-16 characters
  • A postfix such as 001, 002 is attached based on the server name, and the actual server name is created
Cluster NameRequiredCluster name of the recovery DB
  • Enter in English, 3-20 characters
  • Cluster is a unit that bundles multiple servers
Service Type > Server TypeRequiredServer type where the recovery DB will be installed
  • Standard: Standard specification commonly used
  • High Capacity: High-capacity server with 24vCore or more
Service Type > Planned ComputeSelectionCurrent status of resources with Planned Compute set
  • In Use: Number of resources with Planned Compute set that are in use
  • Settings: Number of resources with Planned Compute set
  • Coverage Preview: Amount applied by Planned Compute for each resource
  • Create Planned Compute Service: Move to the Planned Compute service application page
Service Type > Block StorageRequiredRecovery DB uses Block Storage settings
  • Basic OS: Area where the DB engine is installed
  • DATA: Area for storing table data, archive files, etc.
    • The storage type set in the original cluster is applied identically
    • Capacity can be entered in multiples of 8 in the range of 16 to 5,120
  • Additional: DATA, Archive, TEMP, Backup data storage area
    • The storage type set in the original cluster is applied identically
    • In the recovery DB, only DATA, TEMP, and Archive purposes can be added.
    • After selecting Use, enter the purpose and capacity of the storage
    • To add storage, click the + button, and to delete, click the x button
    • Capacity can be entered in multiples of 8 in the range of 16 to 5,120, and up to 9 can be created
Database usernamerequiredDatabase username set in the original DB
Database Port numberrequiredDatabase Port number set in the original DB
IP Access ControlSelectIP address to access the recovery DB
  • Enter in IP format (e.g., 192.168.10.1) or CIDR format (e.g., 192.168.10.1/32, 192.168.10.1/32) and click the Add button
  • To delete the entered IP, click the x button next to the entered IP
Maintenance periodSelectDB maintenance period
  • Use is selected, set the day of the week, start time, and duration
  • It is recommended to set the maintenance period for stable management of the DB. Patch work is performed at the set time and service interruption occurs
  • If set to unused, Samsung SDS is not responsible for any problems that occur due to non-application of patches.
TagSelectAdd Tag
  • Click the Add Tag button and enter or select Key, Value
Fig. PostgreSQL(DBaaS) Recovery Configuration Items
Managing DB Services
Read Replica Setup