Overview

Service Overview

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

PostgreSQL(DBaaS) is designed as a high availability architecture considering storage-based data replication and failover time minimization. To prevent data loss, when the content of the Active server changes, it is synchronously replicated to the Standby server. Read-only servers called Replica for read load distribution and disaster recovery (DR) are provided up to 5. Additionally, in preparation for problems with the DB server or data, it provides automatic backup at a time specified by the user, supporting data recovery at a desired point in time.

Provided Features

PostgreSQL(DBaaS) provides the following features.

• Auto Provisioning: Database (DB) installation and configuration via UI, providing Active-Standby redundancy configuration based on storage replication. Automatic failover to Standby when Active server fails.
• Operation Control Management: Provides function to control running server status. Start, stop, and restart possible for DB issues or to reflect configuration values. For HA configuration, users can directly perform Active-Standby node switching through Switch-over.
• Backup and Recovery: Provides data backup function based on own backup commands. Backup time period and retention period can be set by user, and additional charges are incurred depending on backup capacity. Also provides recovery function for backed up data, where user performs recovery and separate DB is created, recovery proceeds to point in time selected by user (backup storage point, user-specified point). When recovering to user-specified point, recovery point can be set up to 5 minutes/10 minutes/30 minutes/1 hour before current time based on stored backup files and archive files.
• Version Management: Provides version upgrade (Minor) function for some feature improvements and security patches. User can select whether to perform backup according to version upgrade, and if performing backup, backs up data before patch execution then performs DB engine update.
• Replica Configuration: Can configure up to 5 Read Replicas in same/different regions for read load distribution and disaster recovery (DR).
• Audit Settings: Supports audit function for major activities in database.
• Parameter Management: Can modify DB configuration parameters for performance improvement and security.
• Service Status Check: Checks final status of current DB service.
• Monitoring: Can check CPU, memory, DB performance monitoring information through Cloud Monitoring service.
• DB User Management: Manages DB account (user) information registered in DB.
• DB Access Control Management: Can register and cancel access-allowed IPs based on DB accounts registered in DB.
• Archive Management: Can set Archive file retention period (1~35 days) and Archive mode (On/Off) in DB server.
• DB Log Export: Can export logs stored through Audit settings to user’s Object Storage.
• Migration: Supports migration using replication method by synchronizing data with operating database in real time without service interruption.
• OS Kernel Upgrade: Can upgrade OS Kernel for some feature improvements and security patch application.

Components

PostgreSQL(DBaaS) provides pre-verified engine versions and various server types according to open source support policy. Users can select and use according to the service scale they want to configure.

Engine Versions

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 stops is set to 6 months before the EoTS date.

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

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

Server Type

Server types supported by PostgreSQL(DBaaS) are as follows.

For details on server types provided by PostgreSQL(DBaaS), see PostgreSQL(DBaaS) Server Type.

Standard db1v2m4

Prerequisite Services

List of services that must be configured in advance before creating this service. For details, please prepare in advance by referring to the guide provided for each service.