Overview

Service Overview

PostgreSQL (DBaaS) is an open-source relational database management system (RDBMS). Samsung Cloud Platform provides an environment that automates PostgreSQL installation through a web-based console and performs management functions for operation.

PostgreSQL(DBaaS) is designed as a high‑availability architecture that performs storage‑based data replication and minimizes failover time. To prevent data loss, when the contents of the Active server change, they are synchronously replicated to the Standby server, and up to five read‑only Replica servers for read load balancing and disaster recovery (DR) are provided. Additionally, to prepare for potential issues with the DB server or data, we provide an automatic backup feature at user-specified times, enabling data recovery at the desired point in time.

Provided features

PostgreSQL(DBaaS) provides the following features.

• Auto Provisioning: UI allows installation and configuration of Database (DB), and provides an Active-standby redundancy configuration built on storage replication. * When the active server fails, it automatically fails over to standby.
• Operation Control Management: Provides a function to control the status of running servers. * In addition to start and stop, a restart is possible if there is a DB issue or to apply configuration changes. * When high availability (HA) is configured, the node transition of Active‑Standby can be performed directly by the user through a switch‑over.
• Backup and Recovery: Provides data backup functionality based on its own backup commands. * Backup time windows and storage locations can be configured by the user, and additional fees may be incurred based on the backup size. * It also provides a recovery function for backed‑up data, and when the user initiates a recovery, a separate database is created, and the recovery proceeds to the point in time selected by the user (backup creation time, user‑specified time). * When restoring to a user-specified point in time, the restore point can be set up to 5 minutes, 10 minutes, 30 minutes, or 1 hour before the stored backup and archive files.
• Version Management: We provide Minor version upgrade functionality due to some feature improvements and security patches.
• Replica configuration: For load balancing of read traffic and disaster recovery (DR), up to five Read Replicas can be configured in the same or different regions.
• Audit Settings: Supports audit (Audit) functionality for key activities within the database.
• Parameter management: It is possible to modify DB configuration parameters related to performance improvement and security.
• Service Status Query: Retrieves the final status of the current DB service.
• Monitoring: CPU, memory, performance monitoring information can be viewed through Cloud Monitoring and Servicewatch.
• DB User Management: View and manage the DB account (user) information registered in the DB.
• DB Access Control Management: Based on DB accounts registered in the DB, you can register and revoke allowed IPs for access.
• Archive Management: You can set the retention period for Archive files (1~35 days) on the DB server and configure the Archive mode (On/Off).
• DB Log Export: You can export stored logs to the user’s Object Storage through Audit settings.
• Migration: Synchronizes data in real time with the operational database and supports migration using replication without service interruption.
• OS kernel upgrade: You can upgrade the OS Kernel to apply some feature improvements and security patches.

Components

PostgreSQL(DBaaS) provides pre‑validated engine versions and various server types according to its open‑source support policy. Users can select and use it according to the scale of the service they wish to configure.

Engine version

The engine versions supported by PostgreSQL (DBaaS) are as follows.

Technical support is available until the supplier’s EoTS (End of Technical Service) date, and the EOS date when new creation is halted is set to six months before the EoTS date.

Since the EOS and EoTS dates may change according to the supplier’s policy, please refer to the supplier’s license management policy page for details.

• PostgreSQL: https://www.postgresql.org/support/versioning/

Server type

The server types supported by PostgreSQL (DBaaS) are as follows.

For detailed information about the server types offered by PostgreSQL(DBaaS), see PostgreSQL(DBaaS) 서버 타입.

Standard db1v2m4

Preceding Service

This is a list of services that must be pre‑configured before creating the service. Please refer to the guide provided for each service and prepare in advance.