Backup

Available in VPC

In Backup, you can check the backup information configured per server for safe storage of cache data for users using Cloud DB for PostgreSQL. Also, when the cache data is damaged due to a failure, you can perform restoration using the backup file that was in storage. To use the backup and restoration, it is recommended to first understand the basic execution rules for the backup provided by Cloud DB for PostgreSQL. The basic backup execution rules are as follows:

• Backup execution methods
  • Performed daily, once a day
  • Select between automatic settings and user-defined settings
    • Automatic settings: backups are performed within 15 minutes from 00:00
    • User-defined settings: backups are performed within 15 minutes from the time selected by the user
    • Exceptional situations
      • Backup is performed within 30 minutes from the DB creation
      • When DB settings change, the backup is performed up to 5 minutes after the backup time
• Backup file
  • Retention period: can be stored up to 30 days according to the user settings
  • Storage location: a separate data storage (Storage contracts are made according to the backup file size)

Backup page

The basics of using the backup are as follows:

Check backup settings list

You can check the backup settings list per PostgreSQL server in operation. The following describes how to check the backup settings list.

1. From NAVER Cloud Platform console, Click the Services > Database > Cloud DB for PostgreSQL menus in that order.
2. Click the Backup menu.
3. When the backup settings list appears, check the required information.
   
   • DB service name: service name specified by user
   • Backup retention period: maximum number of days for the backup file to be stored in data storage
   • Backup start time: the time that the daily backup is performed ("AUTO" if set to automatic)
   • Backup data size: size of the completed backup file
   • Latest backup date: date for the latest backup that was performed
   • View details: details and restoration of the backup file list created per server, saved to Object Storage

Check backup file list per server

The following describes how to check the backup file list created for each server after completing the backup:

1. From NAVER Cloud Platform console, Click the Services > Database > Cloud DB for PostgreSQL menus in that order.
2. Click the Backup menu.
3. Click the [Details] button from View details of the backup settings row you want to check the details for.
4. Check the details for the backup file.
   
   • Backup date: date that the backup was performed
   • Backup start time: time when the backup was started
   • Backup completion time: time when the backup was completed
   • Elapsed time: time it took for the backup to be completed
   • Backup file size: size of the created backup file upon completion of backup (MB)
   • Archived WAL file size: size of the archived WAL file created upon completion of backup (MB)
   • Capacity expected to be required for restoration: size of the expected disk size if the server is to be recovered with the backup file

Restoration

Cloud DB for PostgreSQL provides a service that enables you to restore lost data using backup files, and create PostgreSQL servers easily and quickly. It allows the user to restore the data up to the desired time within the range available for recovery. The following describes how to restore it.

1. From NAVER Cloud Platform console, Click the Services > Database > Cloud DB for PostgreSQL menus in that order.
2. Click the Backup menu.
3. Click the [Details] button of the backup settings row you want to restore.
4. Click the [Point-in-time restoration] button.
   
5. When the Point-in-time recovery pop-up window appears, check or enter the required information for restoration.
   
   • Available DB restoration time: range of time available for restoration (up to 7 days)
   • DB restoration time: the point in time to restore to
   • Subnet: subnet to be used by the server to be restored (cannot select)
   • DB server type: PostgreSQL server type to be restored
   • DB server name: PostgreSQL server name to be restored
   • DB service name: PostgreSQL service name to be restored
6. Click the [Restore] button.
7. Click the [OK] button.
8. Click the PostgreSQL server menu.
9. Check the status of the server being restored.
   • Creating: status in which the PostgreSQL is being created (restored) with the information entered by the user
   • Configuring: status in which the PostgreSQL server is being configured after being created (restored) with the information entered by the user
   • Running: status in which the creation (restoration) and configuration of the PostgreSQL server has been completed with the information entered by user, and access to PostgreSQL from the application servers is available

Store in Object Storage

In Cloud DB for PostgreSQL, you can store the created backup files in Object Storage and use them when performing backup. The following describes how to save a stored backup file to Object Storage:

1. From NAVER Cloud Platform console, Click the Services > Database > Cloud DB for PostgreSQL menus in that order.
2. Click the Backup menu.
3. Click the [See details] button of the backup settings row for the backup file you want to save to Object Storage.
4. Press the [Send to Object Storage] button.
   
5. When the Send to Object Storage pop-up window appears, click and select the bucket you want to save into.
   
6. Press the [Send to Object Storage] button.
7. Click the [OK] button.