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.
-
Go to the KakaoCloud Console > Data Store > PostgreSQL.
-
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 detailsEngine 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.
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.
-
Go to the KakaoCloud Console > Data Store > PostgreSQL.
-
In the Instance group menu, select the PostgreSQL instance group where you want to create a backup.
-
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 detailsType Currently, only manual backups are supported
- Automatic backup support is plannedBackup size Size of the backup Created at Date and time of backup creation Created by User who created the backup -
In the Create backup popup, enter the necessary information and click the [Create] button.
-
Check the saved backup file in the Backup menu.
Delete backup
You can delete backups that are no longer needed.
Once a backup is deleted, it is permanently removed and cannot be recovered.
- Go to the KakaoCloud Console > Data Store > PostgreSQL.
- In the Instance group menu, select the PostgreSQL instance group where the backup is located.
- In the Backup menu, click the [More options] icon for the backup you want to delete and select Delete.
- 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.
A new instance group can be created only if the backup status is Available.
-
Go to the KakaoCloud Console > Data Store > PostgreSQL.
-
In the Instance group menu, select the PostgreSQL instance group with the backup you want to restore.
-
In the Backup tab, click the [More options] icon for the desired backup and select Restore.
-
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 restorationBasic settings Instance group name Name of the new PostgreSQL instance group
- Cannot use a name that already exists in the same projectDescription (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-AZSingle (Primary only) Creates only a primary instance
- Only single-AZ is supportedPostgreSQL settings Engine version The PostgreSQL version is selected automatically
14.14
is providedPrimary 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 |
- ID cannot be changed during restore.
For more information on instance groups, see Instance group.