Backing up and restoring the DB

Users can configure backups for PostgreSQL (DBaaS) via the Samsung Cloud Platform Console and restore using the backed‑up files.

PostgreSQL(DBaaS) Backing Up

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

Configure Backup

Refer to PostgreSQL(DBaaS) 생성하기 for how to configure backup settings for PostgreSQL(DBaaS).

To modify the backup settings of a created resource, follow the steps below.

To set up a backup, follow these steps.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. 1. Navigate to the Service Home page of PostgreSQL (DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. 2. PostgreSQL (DBaaS) List Navigate to the page.
3. PostgreSQL(DBaaS) List page, click the resource to set up a backup. 3. PostgreSQL(DBaaS) Details Go to the page.
4. Click the Edit button of the backup item. 4. Backup Settings The popup window opens.
5. When configuring a backup, click Use in the Backup Settings popup, select the retention period, backup start time, and Archive backup interval, then click the Confirm button.
   • If you want to stop the backup setting, uncheck Use in the Backup Settings popup window and authenticate via the logged-in user’s mobile phone.
     Once user authentication is completed, the backup setting is disabled and backup execution stops.

Perform immediate backup

If additional data protection is needed, you can quickly create a backup using the instant backup feature.

To perform an immediate backup, follow these steps.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. 1. Navigate to the Service Home page of PostgreSQL (DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. 2. PostgreSQL(DBaaS) List Navigate to the page.
3. PostgreSQL(DBaaS) List On the PostgreSQL(DBaaS) List page, click the resource to perform an immediate backup. 3. Go to the PostgreSQL(DBaaS) Details page.
4. Click the Immediate Backup button for the backup item. 4. Immediate backup settings popup window opens.
5. Immediate backup setting popup window, click the Confirm button.

Check backup history

To view the backup history, follow these steps.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. 1. Navigate to the Service Home page of PostgreSQL (DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. 2. PostgreSQL(DBaaS) List Navigate to the page.
3. PostgreSQL(DBaaS) List Click the resource to view the backup history on the page. 3. PostgreSQL(DBaaS) Details Go to the page.
4. Backup History Click the button. 4. Backup History The popup window opens.
5. Backup History In the popup window, you can view the backup status, version, backup start time, backup completion time, and size.

Delete backup file

To delete the backup history, follow these steps.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. 1. Navigate to the Service Home page of PostgreSQL (DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. 2. PostgreSQL(DBaaS) List Navigate to the page.
3. On the PostgreSQL (DBaaS) List page, click the resource to view the backup history. 3. PostgreSQL(DBaaS) Details Navigate to the page.
4. Click the Backup History button. 4. Backup History The popup window opens.
5. Backup History In the popup window, check the files you want to delete, then authenticate using the logged-in user’s mobile phone.
   • When user authentication is completed, the backup file will be deleted.

PostgreSQL(DBaaS) Recover

If a failure or data loss requires restoration from a backup file, you can recover using the recovery feature based on a specific point in time. When you perform a PostgreSQL(DBaaS) recovery, a new server is created with the OS image from the initial provisioning point, the database is installed with the version from the backup point, and the recovery proceeds with the database’s configuration information and data.

To restore PostgreSQL(DBaaS), follow the steps below.

1. All Services > Database > PostgreSQL (DBaaS) Click the menu. 1. Navigate to the Service Home page of PostgreSQL (DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. 2. PostgreSQL(DBaaS) List Go to the page.
3. PostgreSQL(DBaaS) Resource On the list page, click the resource you want to recover. 3. PostgreSQL(DBaaS) Details Navigate to the page.
4. Click the Database Recovery button. 4. Database Recovery Navigate to the page.
5. Database Recovery Configuration After entering the relevant information in this area, click the Complete button.

   Category	Required	Detailed description
   Recovery type	Required	Set the point in time the user wants to recover Backup point (recommended): Recover based on the backup file. Select from the list of backup points displayed in the list Custom point: Recover to a user‑desired point within the range of recoverable backup times. The recoverable period depends on the Archive backup interval setting, allowing recovery from the initial backup start time up to 1 hour/30 minutes/10 minutes/5 minutes before the current time. Select the date and time to back up
   Server name prefix	Required	Recovery DB server name Start with a lowercase English letter and use lowercase letters, numbers, and special characters (-) to enter 3 to 16 characters Based on the server name, a postfix such as 001, 002 is appended to generate the actual server name
   Cluster name	Required	Cluster name of the recovery DB Enter using English letters, 3 ~ 20 characters A cluster is a unit that groups multiple servers
   Service Type > Server Type	Required	Server type for the recovery DB installation Standard: standard specifications commonly used High Capacity: large-capacity server with 24vCore or more
   Service Type > Planned Compute	Selection	Status of resources with Planned Compute set In Use: Number of resources with Planned Compute set that are currently in use Configured: Number of resources with Planned Compute set Coverage Preview: Amount applied per resource by Planned Compute Create Planned Compute Service: Go to the Planned Compute service application page For more details, see Planned Compute 신청하기
   Service Type > Block Storage	Required	Block Storage settings used by the recovery DB Basic OS: Area where the DB engine is installed DATA: Storage area for table data, archive files, etc. Applied identically with the storage type set in the original cluster Enter capacity as a multiple of 8 within the range 16 to 5,120 Additional: Storage area for DATA, Archive, TEMP, Backup data Applied identically with the storage type set in the original cluster In the recovery DB, only DATA, TEMP, and Archive purposes can be added After selecting Use, enter the storage purpose and capacity To add storage, click the Add button; to delete, click the x button Capacity can be entered as a multiple of 8 within the range 16 to 5,120, and up to 9 can be created
   Database username	Required	Database username set in the source DB
   Database Port number	Required	Database Port number configured in the source DB
   IP access control	Selection	IP address for accessing the recovery DB Enter in IP format (example: 192.168.10.1) or CIDR format (example: 192.168.10.1/32, 192.168.10.1/32), then click the Add button To delete an entered IP, click the x button next to the entered IP
   Maintenance period	Selection	DB maintenance window If you select Use, set the day, start time, and duration The maintenance window is a feature that allows the user to set the time slot for performing patch operations, and any patch work within that period must be performed directly by the user. We ask you to set a maintenance window for the stable operation of the system, and we are not responsible for any issues arising from not setting it or from not performing tasks within the window.
   tag	Selection

   |
   Table. PostgreSQL (DBaaS) Recovery Configuration Items