Service Overview
PostgreSQL (DBaaS) is an open source relational database management system (RDBMS). Samsung Cloud Platform provides an environment that can automate PostgreSQL installation through a web-based console and perform 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 content of the Active server changes, it is synchronously replicated to the Standby server, and up to five read‑only servers called Replicas are provided for read‑load balancing and disaster recovery (DR). Additionally, to prepare for issues with the DB server or data, it offers an automatic backup function at user‑specified times, enabling data recovery to a desired point in time.
Provided Features
PostgreSQL (DBaaS) provides the following features.
- Auto Provisioning (Auto Provisioning): It is possible to install and configure the Database (DB) via UI, and it provides an Active-standby redundancy configuration built on storage replication. In case of an Active server failure, 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, restart is possible if there is an issue with the DB or to apply configuration values. When configured for high availability (HA), the user can directly perform node switching between Active-Standby via Switch-over.
- Backup and Recovery: Provides a data backup function based on its own backup commands. The backup time window and storage organization can be set by the user, and additional fees are incurred based on backup size. It also provides a recovery function for backed-up data, so when the user performs a recovery, a separate DB is created and the recovery proceeds to the point in time selected by the user (backup save point, user-specified point). If the user restores to a specified point, the recovery point can be set to 5 minutes, 10 minutes, 30 minutes, or 1 hour before the stored backup file and archive file.
- Version Management: Provides version upgrade (Minor) functionality due to some feature improvements and security patches. Whether to perform a backup for the version upgrade can be selected by the user, and if a backup is performed, data is backed up before applying the patch, then the DB engine is updated.
- Replica configuration: For read load balancing and disaster recovery (DR), up to 5 Read Replicas can be configured in the same/different region.
- Audit Settings: Supports audit (Audit) functionality for major activities within the database.
- Parameter Management: Performance improvement and security-related DB configuration parameters can be modified.
- Service Status Query: Retrieve the final status of the current DB service.
- Monitoring: CPU, memory, DB performance monitoring information can be checked through the Cloud Monitoring service.
- DB User Management: Retrieve and manage 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.
- Archive Management: You can set the retention period of Archive files (1 day~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: Synchronize data in real time with the operating database, and support migration using the Replication method without service interruption.
Components
PostgreSQL (DBaaS) provides pre-validated engine versions and various server types according to the open source support policy. Users can select and use them according to the scale of the service they want to configure.
Engine Version
The engine versions supported by PostgreSQL (DBaaS) are as follows.
Technical support can be used until the supplier’s EoTS (End of Technical Service) date, and the EOS date when new creation is stopped 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/
| Provided Version | EOS Date(Samsung Cloud Platform New Creation Stop Date) | EoTS Date(Community Technical Support End Date) |
|---|---|---|
| 14.17 | 2026-06 (scheduled) | 2026-11-12 |
| 14.18 | 2026-06 (scheduled) | 2026-11-12 |
| 15.12 | 2027-06 (scheduled) | 2027-11-11 |
| 15.13 | 2027-06 (scheduled) | 2027-11-11 |
| 16.8 | 2028-06 (scheduled) | 2028-11-09 |
| 16.9 | 2028-06 (scheduled) | 2028-11-09 |
Server Type
The server types supported by PostgreSQL (DBaaS) are as follows.
For detailed information about the server types provided by PostgreSQL(DBaaS), see PostgreSQL(DBaaS) server type.
Standard db1v2m4
Category
Example
Detailed description
Server Type
Standard
Provided Server Types- Standard: Standard specifications (vCPU, Memory) configuration commonly used
- High Capacity: Large-capacity server specifications of 24 vCores or more
Server specifications
db1
Provided server specifications- db1: Standard specifications (vCPU, Memory) configuration commonly used
- dbh2: Large-scale server specifications
- Provides servers with 24 vCores or more
Server specifications
v2
Number of vCores- v2: 2 virtual cores
Server Specifications
m4
Memory Capacity- m4: 4GB Memory
Table. PostgreSQL (DBaaS) server type components
# Preliminary Service
This is a list of services that must be pre-configured before creating the service. For details, please refer to the guide provided for each service and prepare in advance.<br>
Service Category
Service
Detailed Description
Networking
VPC
A service that provides an isolated virtual network in a cloud environment
Table. PostgreSQL(DBaaS) Pre-service