Manage backup

Backups are managed at the PostgreSQL instance group level and can be performed without stopping the instance group.

View backup list

You can check the list of backups created in the PostgreSQL instance group of the project.

1. Navigate to the KakaoCloud Console > Data Store > PostgreSQL menu.

2. Click the Backup menu.

   Item	Description
   Name	Name of the backup
   Instance group name	Name of the instance group associated with the backup
   Status	Current backup status - See Backup lifecycle and status values for details
   Engine version	PostgreSQL engine version that can be restored from the backup
   Backup size	Size of the backup
   Default storage size	Default storage size for restoration
   Created at	Date the backup was created
   [More]	Restore, Delete

Create manual backup

You can create backups manually in the PostgreSQL service.

info

Backups can only be created when the instance group status is Available, Primary-Available, or Error, and the instance status is Running.
- See Backup lifecycle and status values for details.

1. Navigate to the KakaoCloud Console > Data Store > PostgreSQL menu.

2. Select the PostgreSQL instance group to back up from the Instance Group menu.

3. Click the Backup menu and then click the [Create backup] button.

   Item	Description
   Name	Name of the backup entered during creation
   Status	Backup status - See Backup lifecycle and status values for details
   Type	Currently, only manual backup is available - Automated backup support is planned
   Backup size	Size of the backup
   Creation time	Time the backup was created
   Created by	User who created the backup

4. Enter the required information in the Create backup popup and click the [Create] button.

5. Verify the backup file in the Backup menu.

Delete backup

You can delete backups that are no longer needed.

caution

When a backup is deleted, it is permanently removed, and the deletion cannot be undone.

1. Navigate to the KakaoCloud Console > Data Store > PostgreSQL menu.
2. Select the PostgreSQL instance group to delete the backup from the Instance Group menu.
3. In the Backup tab, click the [More] icon for the backup to delete and select Delete.
4. Enter the required information in the Delete backup popup and click the [Delete] button.

Restore

The restore function in the PostgreSQL service allows you to create a new instance group using a backup. A backup must already exist for the instance group to be restored.

info

• A new instance group can be created through restoration only if the backup status is Available.
  
• The instance type of the new instance group must be the same as or higher than the type of the backed-up instance group.
  
• The storage size of the new instance group must be the same as or larger than the storage size of the backed-up instance group.

1. Navigate to the KakaoCloud Console > Data Store > PostgreSQL menu.

2. Select the PostgreSQL instance group to use the backup from the Instance Group menu.

3. In the Backup tab, click the [More] icon for the backup to restore and select Restore.

4. Enter the required information in the popup and click the [Create] button.

   Item	Category	Description
   Restoration info	Instance group name	Basic information of the selected backup file - Includes the instance group name, backup file name, instance group storage size, and backup creation date.
   Basic settings	Instance group name	Name of the PostgreSQL instance group - Must be unique within the same project
   	Description (optional)	Additional description for the instance group (up to 100 characters)
   Instance availability	High availability	Create primary and multiple standby instances - Single AZ or Multi-AZ
   	Single	Create only a single primary instance - Single AZ only
   PostgreSQL settings	Engine version	Automatically selected PostgreSQL database version 14.14 available
   	Primary port	Port for communicating with the PostgreSQL primary instance (range: 1024–65535, default: 5432)
   	Standby port	Port for communicating with the PostgreSQL standby instance (required for high availability, range: 1024–65535, default: 5433)
   	ID	ID of the PostgreSQL database user account - Example: admin * Reserved account names (root, postgres, rewind, replication, orafce_set_umask, plprofiler) cannot be used
   	Password	Initial password for the PostgreSQL database user account - Format: 8–16 characters, no spaces, /, ', ", @ characters ⚠️ Passwords can be changed after the database is running. Modified passwords cannot be retrieved.
   Instance type		Select the instance type for configuring database computing resources - See Instance types for details
   Default storage	SSD	Configure volume type and size for the database - Volume type: Only SSD is supported for now. More types will be supported in the future. - Volume size: 100 GB–16,384 GB * Minimum size may vary by instance type.
   Log storage	SSD	Storage used for database logs (cannot be changed after creation) - Volume type: Only SSD is supported for now. More types will be supported in the future. - Volume size: 100 GB–16,384 GB * Minimum size may vary by instance type.
   Network settings	Multi-AZ options	Options available for high availability; specify subnets and the number of instances to create in each AZ.
   	VPC	Select the network where the PostgreSQL instance database will be deployed
   	Subnet and instance count	Select the subnets for creating primary and standby instances, and specify the number of instances to create - Maximum 6 instances per instance group - At least two instances are recommended for redundancy in the primary subnet.
   	Security group	Create a new security group or select an existing one to apply to the instance group - Multiple selections allowed

info

For more details about instance groups, see Instance groups.