Skip to main content

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

    ItemDescription
    NameName of the backup
    Instance group nameThe name of the instance group associated with the backup
    StatusBackup status
    - See Backup lifecycle and status values for details
    Engine versionPostgreSQL engine version that can be restored from the backup
    Backup sizeSize of the backup
    Base storage sizeDefault storage size used during restoration
    Created atDate 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.

    ItemDescription
    NameBackup name entered during creation
    StatusBackup status
    - See Backup lifecycle and status values for details
    TypeCurrently, only manual backups are supported
    - Automatic backup support is planned
    Backup sizeSize of the backup
    Created atDate and time of backup creation
    Created byUser 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.

    ItemCategoryDescription
    Restore infoInstance group nameDisplays 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 settingsInstance group nameName 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 availabilityHigh 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 settingsEngine versionThe PostgreSQL version is selected automatically
    14.14 is provided
    Primary portCommunication port for the primary PostgreSQL instance (range: 1024–65535)
    - Default: 5432
    Standby portCommunication port for standby PostgreSQL instance (range: 1024–65535), required when high availability is selected
    - Default: 5433
    IDID 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.