Manage backup

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

View backup list

You can view the list of backups created in a PostgreSQL instance group within the project.

1. Go to the KakaoCloud Console > Data Store > PostgreSQL.

2. Click the Backup menu.

   Manual backup tab

   Item	Description
   Name	Name of the backup
   Instance group name	The name of the instance group associated with the backup
   Status	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
   Base storage size	Default storage size used during restoration
   Created at	Date when the backup was created
   [More options]	Restore, Delete

Create manual backup

You can manually create backups 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.
- For more information, see Backup lifecycle and status values.

1. Go to the KakaoCloud Console > Data Store > PostgreSQL.

2. In the Instance group menu, select the PostgreSQL instance group where you want to create a backup.

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

   Item	Description
   Name	Backup name entered during creation
   Status	Backup status - See Backup lifecycle and status values for details
   Type	Currently, only manual backups are supported - Automatic backup support is planned
   Backup size	Size of the backup
   Created at	Date and time of backup creation
   Created by	User who created the backup

4. In the Create backup popup, enter the necessary information and click the [Create] button.

5. Check the saved backup file in the Backup menu.

Delete backup

You can delete backups that are no longer needed.

caution

Once a backup is deleted, it is permanently removed and cannot be recovered.

1. Go to the KakaoCloud Console > Data Store > PostgreSQL.
2. In the Instance group menu, select the PostgreSQL instance group where the backup is located.
3. In the Backup menu, click the [More options] icon for the backup you want to delete and select Delete.
4. In the Delete backup popup, enter the required information and click the [Delete] button.

Restore

Using the restore feature in PostgreSQL, you can create a new instance group based on a previously backed-up instance group. Note that a backup must exist before initiating a restore.

info

A new instance group can be created only if the backup status is Available.

1. Go to the KakaoCloud Console > Data Store > PostgreSQL.

2. In the Instance group menu, select the PostgreSQL instance group with the backup you want to restore.

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

4. Enter the necessary information and click the [Restore] button.

   Item	Category	Description
   Restore info	Instance group name	Displays basic information from the selected backup file - Includes instance group name, backup file name, storage size, and backup creation date - This information will be used as the basis for restoration
   Basic settings	Instance group name	Name of the new PostgreSQL instance group - Cannot use a name that already exists in the same project
   	Description (optional)	Optional description for the instance group (up to 100 characters)
   Instance availability	High availability (Primary + Standby)	Creates a primary instance and multiple standby instances - Available in single-AZ or multi-AZ
   	Single (Primary only)	Creates only a primary instance - Only single-AZ is supported
   PostgreSQL settings	Engine version	The PostgreSQL version is selected automatically 14.14, 14.17 is provided
   	Primary port	Communication port for the primary PostgreSQL instance (range: 1024–65535) - Default: 5432
   	Standby port	Communication port for standby PostgreSQL instance (range: 1024–65535), required when high availability is selected - Default: 5433
   	ID	ID of the PostgreSQL database user account

   • ID cannot be changed during restore.
     
   • Reserved IDs (root, postgres, rewind, replication, orafce_set_umask, plprofiler) are not allowed.
     
   • See Instance group user accounts for permission details. | | | Password | Initial password for the PostgreSQL database user account
     
   • Length: 8–16 characters
     
   • Cannot contain spaces or the characters /, ', ", @
     
     ⚠️ Password can be changed after database is up and running
     ⚠️ Modified passwords cannot be retrieved after change | | Instance type | | Select the instance type for computing resources
     - See Instance types for more details | | Base storage | SSD | Configure storage type and size for the database volume
     - Type: Only SSD is supported currently (more types to be added)
     - Size: 100 GB to 16,384 GB
     
   • Minimum size may vary depending on instance type | | Log storage | SSD | Storage used for log data. Type cannot be changed after creation.
     - Type: Only SSD supported currently
     - Size: 100 GB to 16,384 GB
     
   • Minimum size may vary depending on instance type | | Network settings | Multi-AZ option | Option available when high availability is selected; specify subnet and number of instances per AZ | | | VPC | Select the network (VPC) for the PostgreSQL instance | | | Subnet & instance count | Specify subnets and the number of instances for primary and standby
     - Up to 6 instances per instance group
     - At least 2 standby instances are recommended for redundancy | | | Security group | Create or select existing security groups to apply to the instance group
     - Multiple selections allowed |

info

For more information on instance groups, see Instance group.