The page has been translated by Gen AI.

Managing DB Service

Users can manage PostgreSQL(DBaaS) through the Samsung Cloud Platform Console.

Managing Parameters

Provides functionality to easily view and modify database configuration parameters.

Viewing Parameters

Follow these steps to view configuration parameters.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource for which you want to view and modify parameters. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the More button and click the Parameter Management button. The Parameter Management popup window will open.
  5. In the Parameter Management popup window, click the View button. The View Notification popup window will open.
  6. When the View Notification popup window opens, click the Confirm button. Viewing may take some time.

Modifying Parameters

Follow these steps to modify configuration parameters.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource for which you want to view and modify parameters. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the More button and click the Parameter Management button. The Parameter Management popup window will open.
  5. In the Parameter Management popup window, click the View button. The View Notification popup window will open.
  6. When the View Notification popup window opens, click the Confirm button. Viewing may take some time.
  7. If modification is needed, click the Modify button and enter the modification in the custom value area of the Parameter to be modified.
  8. When input is complete, click the Complete button.

Managing DB Users

Provides management functionality to view DB user information and change status information.

Viewing DB Users

Follow these steps to view DB users.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource for which you want to view DB users. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the More button and click the DB User Management button. You will move to the DB User Management page.
  5. On the DB User Management page, click the View button. Viewing may take some time.

Changing DB User Status

Follow these steps to change the status of viewed DB users.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource for which you want to modify DB users. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the More button and click the DB User Management button. You will move to the DB User Management page.
  5. On the DB User Management page, click the View button. Viewing may take some time.
  6. If modification is needed, click the Modify button and change the status area value or enter remarks.
  7. When input is complete, click the Complete button.

Managing DB Access Control

Provides IP-based DB user access control management functionality. Users can directly specify IPs that can access the database, allowing access only from permitted IPs.

Notice
Perform DB user viewing before setting DB access control. For DB user viewing, please refer to Managing DB Users.

Viewing DB Access Control

Follow these steps to view DB users with IP access control set.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource for which you want to manage access control. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the More button and click the DB Access Control Management button. You will move to the DB Access Control Management page.
  5. On the DB Access Control Management page, click the View button. Viewing may take some time.

Adding DB Access Control

Follow these steps to add IP access control.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource for which you want to add IP access control. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the More button and click the DB Access Control Management button. You will move to the DB Access Control Management page.
  5. On the DB Access Control Management page, click the View button. Viewing may take some time.
  6. When viewing is complete, click the Add button. The Add DB Access Control popup window will open.
  7. In the Add DB Access Control popup window, select the DB user name and enter the IP Address.
  8. When input is complete, click the Complete button.

Deleting DB Access Control

Follow these steps to delete IP access control.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource for which you want to delete IP access control. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the More button and click the DB Access Control Management button. You will move to the DB Access Control Management page.
  5. On the DB Access Control Management page, click the View button. Viewing may take some time.
  6. When viewing is complete, click the Delete button. The Delete popup window will open.
  7. In the Delete popup window, click the Confirm button.

Managing Archive

Provides functionality to set Archive mode and Archive Log retention period, allowing users to flexibly configure Archive log management policies according to their operating environment. Additionally, provides functionality to manually delete Archive logs, enabling users to organize unnecessary log data and effectively manage system resources.

Notice
When creating a service, the default setting is Archive mode enabled with a retention period of 3 days.

Setting Archive Mode

Follow these steps to set Archive mode.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource for which you want to set Archive mode. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the More button and click the Archive Settings Management button. You will move to the Archive Settings Management page.
  5. On the Archive Settings Management page, click the View button. Viewing may take some time.
  6. Click the Modify button and select usage and retention period.
  7. When modification is complete, click the Complete button.

Deleting Archive Files

Follow these steps to delete Archive files.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource for which you want to set Archive mode. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the More button and click the Archive Settings Management button. You will move to the Archive Settings Management page.
  5. On the Archive Settings Management page, click Delete All Archive if you want to delete all Archive files, or click Delete Backed Up Archive if you want to delete only backed up Archive files.

Modifying Audit Settings

You can change the Audit log storage settings for PostgreSQL(DBaaS).

Follow these steps to change the Audit log storage settings for PostgreSQL(DBaaS).

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource for which you want to view the service status. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the Modify icon in Audit Settings at the bottom of the detailed information. The Modify Audit Settings popup window will open.
  5. In the Modify Audit Settings popup window, modify the usage and then click the Confirm button.
    • Selecting Use sets the Audit log function. Setting Audit logs may degrade DB performance.
    • Disabling Use deletes the Audit log storage file. Please back up the Audit log file separately before disabling use.

Exporting DB Log

Supports exporting audit(Audit) log data that requires long-term retention to Object Storage. Users can directly set the log type to be saved, the destination Bucket to export to, and the cycle for exporting logs. Logs are copied and stored to the specified Object Storage according to the set criteria. Additionally, to efficiently manage disk space, provides an option to automatically delete original log files while exporting logs to Object Storage. Using this option allows you to effectively secure storage capacity while safely storing necessary log data for long-term retention.

Notice
  • To use the DB Log Export function, Object Storage creation is required. For Object Storage creation, please refer to the Object Storage User Guide.
  • Please check the expiration date of the authentication key. If the authentication key expires, logs will not be saved to the Bucket.
  • Please be careful not to expose authentication key information externally.

Setting DB Log Export Mode

Follow these steps to set DB Log export mode.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource for which you want to export DB Log. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the More button and click the DB Log Export button. You will move to the DB Log Export page.
  5. On the DB Log Export page, click the Register button. You will move to the Register DB Log Export page.
  6. On the Register DB Log Export page, enter the corresponding information and then click the Complete button.
    CategoryRequired
    Detailed Description
    Log TypeRequiredLog type to save
    Storage Bucket NameRequiredObject Storage Bucket name to save
    Authentication Key > Access keyRequiredAccess key to access the Object Storage to save
    Authentication Key > Secret keyRequiredSecret key to access the Object Storage to save
    File Creation CycleRequiredCycle for creating files in Object Storage
    Delete Original LogOptionalWhether to delete original logs while exporting to Object Storage
    Table. PostgreSQL(DBaaS) DB Log Export Configuration Items

Managing DB Log Export

Follow these steps to modify, cancel, or immediately export DB Log export settings.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource for which you want to manage DB Log export. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the More button and click the DB Log Export button. You will move to the DB Log Export page.
  5. On the DB Log Export page, click the More button according to the log type you want to manage and click the Immediate Export, Modify, or Cancel button.
    • Immediate Export: The selected log is exported to the Bucket of the previously set Object Storage.
    • Modify: Modifies the DB Log export mode settings.
    • Cancel: Cancels the DB Log export mode settings.

Upgrading Minor Version

Provides version upgrade functionality for some feature improvements and security patches. Only Minor version upgrades within the same Major version are supported.

Caution
  • Please check the service status first through service status synchronization before performing version upgrade.
  • Please proceed with version upgrade after setting up backup. If backup is not set, some data may not be recoverable when problems occur during update.
  • In DBs with Replica configured, the Master DB version cannot be higher than the Replica version. Please check the Replica version first and perform version upgrade if necessary.
  • Backed up data is automatically deleted after version upgrade is complete.

Follow these steps to upgrade Minor Version.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource to upgrade the version. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the Modify button in the Image version item. The Version Upgrade popup window will open.
  5. In the Version Upgrade popup window, select the modified version and backup setting, then click the Confirm button.
  6. In the Version Upgrade Notification popup window, click the Confirm button.

Configuring Migration

Provides Migration functionality that replicates in real-time while synchronizing with the operating database, without service interruption, using Replication method.

Notice
For detailed Migration configuration guide, please refer to Architecture Center > Migration Guide.

Follow these steps to configure Migration.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource to migrate. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the More button and click the Migration Configuration button. The Migration Configuration popup window will open.
  5. In the Migration Configuration popup window, check the instructions and click the Confirm button. You will move to the Migration Configuration page.
  6. On the Migration Configuration page, enter the corresponding information and then click the Connection Check button.
  7. When connection is complete, click the Complete button.
    CategoryRequired
    Detailed Description
    Source DB Database NameRequiredDatabase name of the Source DB to be migrated
    Source DB IPRequiredIP of the Source DB to be migrated
    Source DB PortRequiredPort of the Source DB to be migrated
    Source DB UsernameRequiredUsername of the Source DB to be migrated
    Source DB PasswordRequiredPassword of the Source DB to be migrated
    Table. PostgreSQL(DBaaS) Migration Configuration Items

Promoting Migration Cluster to Master Cluster

You can promote a configured Migration Cluster to Master Cluster.

Caution
When promoting to Master, synchronization with the Source DB to be migrated is stopped.

Follow these steps to promote Migration Cluster to Master.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource to promote to Master. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the More button and click the Master Promotion button. The Master Promotion Notification popup window will open.
  5. In the Master Promotion Notification popup window, click the Confirm button.

Upgrading OS Kernel

You can upgrade the OS Kernel to improve operating database functionality and apply security patches.

Caution
  • Service is interrupted during OS upgrade.
  • Upgrade time may vary depending on the version, and if upgrade fails, it will revert to the previous configuration.
  • Cannot recover to the previous OS after upgrade is complete.

Follow these steps to upgrade OS Kernel.

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS)’s Service Home page.
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. You will move to the PostgreSQL(DBaaS) List page.
  3. On the PostgreSQL(DBaaS) List page, click the resource to upgrade OS Kernel. You will move to the PostgreSQL(DBaaS) Detail page.
  4. Click the More button and click the OS(Kernel) Upgrade button. The OS(Kernel) Upgrade Notification popup window will open.
  5. In the OS(Kernel) Upgrade Notification popup window, check the instructions and click the Confirm button.
How-to guides
DB Backup and Restore