The page has been translated by Gen AI.

Managing DB Services

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

Managing Parameters

It provides a feature to easily view and modify database configuration parameters.

Viewing Parameters

To view configuration parameters, follow these steps:

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
  3. Click the resource you want to view and modify parameters on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
  4. Click the More button and then click the Parameter Management button. The Parameter Management popup window opens.
  5. Click the View button in the Parameter Management popup window. The View Notification popup window opens.
  6. When the View Notification popup window opens, click the OK button. It takes some time to view.

Modifying Parameters

To modify configuration parameters, follow these steps:

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
  3. Click the resource you want to view and modify parameters on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
  4. Click the More button and then click the Parameter Management button. The Parameter Management popup window opens.
  5. Click the View button in the Parameter Management popup window. The View Notification popup window opens.
  6. When the View Notification popup window opens, click the OK button. It takes some time to view.
  7. If modification is required, click the Modify button and enter the modification details in the custom value area of the parameter to be modified.
  8. When the input is complete, click the Save button.

Managing DB Users

It provides a management feature that allows you to view DB user information and change status information.

Viewing DB Users

To view DB users, follow these steps:

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
  3. Click the resource you want to view DB users on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
  4. Click the More button and then click the DB User Management button. It moves to the DB User Management page.
  5. Click the View button on the DB User Management page. It takes some time to view.

Changing DB User Status

To change the status of the viewed DB user, follow these steps:

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
  3. Click the resource you want to modify DB users on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
  4. Click the More button and then click the DB User Management button. It moves to the DB User Management page.
  5. Click the View button on the DB User Management page. It takes some time to view.
  6. If modification is required, click the Modify button and change the status value or enter notes.
  7. When the input is complete, click the Save button.

Managing DB Access Control

It provides an IP-based DB user access control management feature. Users can directly specify the IP that can access the database, allowing only allowed IPs to access.

Notice
Before setting DB access control, perform DB user inquiry. For DB user inquiry, refer to Managing DB Users.

Viewing DB Access Control

To view DB users with IP access control set, follow these steps:

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
  3. Click the resource you want to manage access control on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
  4. Click the More button and then click the DB Access Control Management button. It moves to the DB Access Control Management page.
  5. Click the View button on the DB Access Control Management page. It takes some time to view.

Adding DB Access Control

To add IP access control, follow these steps:

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
  3. Click the resource you want to add IP access control on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
  4. Click the More button and then click the DB Access Control Management button. It moves to the DB Access Control Management page.
  5. Click the View button on the DB Access Control Management page. It takes some time to view.
  6. When the view is complete, click the Add button. The DB Access Control Add popup window opens.
  7. In the DB Access Control Add popup window, select the DB user name and enter the IP address.
  8. When the input is complete, click the Save button.

Deleting DB Access Control

To delete IP access control, follow these steps:

  1. All Services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves 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. It moves to the PostgreSQL(DBaaS) details page.
  4. Click the More button and then click the DB Access Control Management button. It moves to the DB Access Control Management page.
  5. On the DB Access Control Management page, click the Inquire button. It takes some time to inquire.
  6. Once the inquiry is complete, click the Delete button. The Delete pop-up window opens.
  7. In the Delete pop-up window, click the Confirm button.

Managing Archive

It provides functions to set Archive mode and Archive log retention period, allowing users to flexibly set Archive log management policies according to their operating environment. Additionally, it provides a function to manually delete Archive logs, allowing users to clean up unnecessary log data and effectively manage system resources.

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

Setting Archive Mode

To set Archive mode, follow these steps:

  1. All Services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
  3. On the PostgreSQL(DBaaS) list page, click the resource for which you want to set Archive mode. It moves to the PostgreSQL(DBaaS) details page.
  4. Click the More button and then click the Archive Settings Management button. It moves to the Archive Settings Management page.
  5. On the Archive Settings Management page, click the Inquire button. It takes some time to inquire.
  6. Click the Modify button and select the usage and retention period.
  7. Once the modification is complete, click the Save button.

Deleting Archive Files

To delete Archive files, follow these steps:

  1. All Services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
  3. On the PostgreSQL(DBaaS) list page, click the resource for which you want to set Archive mode. It moves to the PostgreSQL(DBaaS) details page.
  4. Click the More button and then click the Archive Settings Management button. It moves to the Archive Settings Management page.
  5. On the Archive Settings Management page, click the Delete All Archives button to delete all Archive files, or click the Delete Backed-up Archives button to delete only backed-up Archive files.

Exporting DB Logs

It supports exporting audit logs that require long-term storage to Object Storage. Users can directly set the type of log to be stored, the target Bucket, and the frequency of log export. According to the set criteria, it copies the logs to the specified Object Storage for storage. Additionally, to efficiently manage disk space, it provides an option to automatically delete the original log files when exporting logs to Object Storage. By utilizing this option, users can effectively secure storage capacity while safely storing necessary log data for long-term storage.

Notice
  • To use the DB Log export function, Object Storage creation is required. Refer to the Object Storage User Guide for Object Storage creation.
  • Be sure to check the expiration date of the authentication key. If the authentication key expires, logs will not be stored in the Bucket.
  • Be cautious not to expose authentication key information to the outside.

Setting DB Log Export Mode

To set DB Log export mode, follow these steps:

  1. All Services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
  3. On the PostgreSQL(DBaaS) list page, click the resource for which you want to export DB logs. It moves to the PostgreSQL(DBaaS) details page.
  4. Click the More button and then click the DB Log Export button. It moves to the DB Log Export page.
  5. On the DB Log Export page, click the Register button. It moves to the DB Log Export Registration page.
  6. On the DB Log Export Registration page, enter the corresponding information and click the Save button.
CategoryRequired
Detailed Description
Log TypeRequiredType of log to be stored
Storage Bucket NameRequiredName of the Object Storage Bucket to store
Authentication Key > Access KeyRequiredAccess key to access the Object Storage to store
Authentication Key > Secret KeyRequiredSecret key to access the Object Storage to store
File Creation CycleRequiredCycle to create files in Object Storage
Original Log DeletionOptionalWhether to delete the original log when exporting to Object Storage
Table. PostgreSQL(DBaaS) Migration Configuration Items

Managing DB Log Export

To modify, cancel, or immediately export DB log settings, follow these steps:

  1. All Services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves 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. It moves to the PostgreSQL(DBaaS) details page.
  4. Click the More button and then click the DB Log Export button. It moves to the DB Log Export page.
  5. On the DB Log Export page, click the More button for the log type you want to manage, and then click the Immediate Export, Modify, or Cancel button.
    • Immediate Export: Exports the selected log to the Object Storage Bucket set earlier.
    • Modify: Modifies the DB log export mode setting.
    • Cancel: Cancels the DB log export mode setting.

Upgrading DB Version

It provides a version upgrade function due to some feature improvements and security patches. Only minor version upgrades are supported within the same major version.

Caution
  • Please perform version upgrades after checking the service status through service status synchronization.
  • Please set up backups before performing version upgrades. If backups are not set up, some data may not be recoverable in case of problems during updates.
  • In DBs with Replicas configured, the Master DB version cannot be higher than the Replica version. Please check the Replica version first and perform version upgrades if necessary.
  • Backed-up data will be automatically deleted after version upgrade completion.

To upgrade the version, follow these steps:

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
  3. On the PostgreSQL(DBaaS) list page, click the resource to upgrade the version. It moves to the PostgreSQL(DBaaS) details page.
  4. Click the Modify button in the image/version item. The Version Upgrade popup window opens.
  5. In the Version Upgrade popup window, select the version to modify and whether to set backup, and then click the Confirm button.
  6. In the Version Upgrade Notification popup window, click the Confirm button.

Configuring Migration

It provides a migration function that synchronizes with the operating database in real-time and replicates in a replication manner without interrupting the service.

Notice
For a detailed migration configuration guide, please refer to Architecture Center > Migration Guide > Database Migration Procedure and Considerations.

To configure migration, follow these steps:

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
  3. On the PostgreSQL(DBaaS) list page, click the resource to migrate. It moves to the PostgreSQL(DBaaS) details page.
  4. Click the More button and then click the Configure Migration button. The Configure Migration popup window opens.
  5. In the Configure Migration popup window, check the instructions and click the Confirm button. It moves to the Configure Migration page.
  6. On the Configure Migration page, enter the corresponding information and click the Connect Check button.
  7. When the connection is complete, click the Complete button.
ClassificationRequired
Detailed Description
Source DB Database NameRequiredDatabase name of the source DB that is the migration target
Source DB IPRequiredIP of the source DB that is the migration target
Source DB PortRequiredPort of the source DB that is the migration target
Source DB User NameRequiredUser name of the source DB that is the migration target
Source DB PasswordRequiredPassword of the source DB that is the migration target
Table. PostgreSQL(DBaaS) Migration Configuration Items

The configured migration cluster can be promoted to a master cluster.

Caution
When promoting to master, synchronization with the source DB that is the migration target will be terminated.

To promote the migration cluster to master, follow these steps:

  1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
  2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
  3. On the PostgreSQL(DBaaS) list page, click the resource to promote to master. It moves to the PostgreSQL(DBaaS) details page.
  4. Click the More button and then click the Promote to Master button. The Promote to Master Notification popup window opens.
  5. In the Promote to Master Notification popup window, click the Confirm button.
How-to guides
DB Backup and Recovery