This is the multi-page printable view of this section. Click here to print.
EPAS(DBaaS)
- 1: Overview
- 1.1: Server Type
- 1.2: Monitoring Metrics
- 2: EPAS(DBaaS) Creation Guide
- 2.1: Connection
- 2.2: Managing
- 2.3: Read Replica
- 2.4: DB Backup and Recovery
- 2.5: Extension use
- 3: API Reference
- 4: CLI Reference
- 5: Release Notes
1 - Overview
EPAS (EnterpriseDB Postgres Advanced Server) is Oracle-compatible RDBMS based on PostgreSQL. Samsung Cloud Platform provides EPAS Database as a Service (DBaaS) allowing you to use EPAS without separate installation and management.
EPAS(DBaaS) Service
Service Overview
EPAS(DBaaS) is a fully managed database service that provides an easy-to-use environment for creating, configuring, and managing EPAS databases. You can focus on application development and business logic without worrying about database installation, patching, backup, and recovery.
Service Architecture
EPAS(DBaaS) consists of the following components:
- Database Cluster: A cluster of one or more database servers that provides high availability and load balancing
- Storage: Block storage for storing database data, archives, and backups
- Network: VPC-based network configuration for secure data transmission
- Monitoring: Integrated monitoring and alarming through ServiceWatch
Service Features
EPAS(DBaaS) provides the following features:
- Auto Provisioning: Automatically provision database servers with just a few clicks without manual installation
- Operation Control: Easily start, stop, and restart database servers
- Backup and Recovery: Automated backup and point-in-time recovery for data protection
- Version Management: Support for multiple EPAS versions with easy upgrades
- Replica: Create read replicas for scaling read operations
- Audit: Database audit logging for compliance and security
- Parameter: Database parameter management for performance tuning
- Monitoring: Real-time monitoring and alerting for database health
- User Management: Database user and permission management
- Access Control: IP-based access control for enhanced security
- Archive: Archive management for long-term data retention
- Log Export: Database log export for analysis and troubleshooting
- Migration: Easy migration from on-premises or other cloud databases
- OS Kernel Upgrade: Automated OS kernel upgrades for security and performance
Engine Versions
EPAS(DBaaS) supports the following EPAS versions:
- EPAS 14.17
- EPAS 15.11
- EPAS 16.4
- EPAS 17.6
Server Types
EPAS(DBaaS) provides the following server types:
- Standard: Standard specifications for general workloads
- High Capacity: Large capacity servers with 24+ vCPU for high-performance workloads
Prerequisites
To use EPAS(DBaaS), you must have a VPC configured in your project. For more information on creating a VPC, see VPC Creation Guide.
1.1 - Server Type
EPAS(DBaaS) Server Type
EPAS(DBaaS) provides server types with various combinations of CPU, Memory, Network Bandwidth, and more. When creating an EPAS(DBaaS), the Database Engine is installed according to the selected server type based on the intended use.
The server types supported by EPAS(DBaaS) are as follows:
Standard db1v2m4
Classification | Example | Detailed Description |
|---|---|---|
| Server Type | Standard | Classification of provided server types
|
| Server Specification | db1 | Classification of provided server types and generations
|
| Server Specification | v2 | Number of vCores
|
| Server Specification | m4 | Memory capacity
|
db1 Server Type
The db1 server type of EPAS(DBaaS) is provided with standard specifications (vCPU, Memory) and is suitable for various database workloads.
- Up to 3.3Ghz Intel 3rd generation (Ice Lake) Xeon Gold 6342 Processor
- Supports up to 16 vCPUs and 256 GB of memory
- Up to 12.5 Gbps networking speed
| Classification | Server Type | vCPU | Memory | Network Bandwidth |
|---|---|---|---|---|
| Standard | db1v2m4 | 2 vCore | 4 GB | Up to 10 Gbps |
| Standard | db1v2m8 | 2 vCore | 8 GB | Up to 10 Gbps |
| Standard | db1v2m16 | 2 vCore | 16 GB | Up to 10 Gbps |
| Standard | db1v2m24 | 2 vCore | 24 GB | Up to 10 Gbps |
| Standard | db1v2m32 | 2 vCore | 32 GB | Up to 10 Gbps |
| Standard | db1v4m8 | 4 vCore | 8 GB | Up to 10 Gbps |
| Standard | db1v4m16 | 4 vCore | 16 GB | Up to 10 Gbps |
| Standard | db1v4m32 | 4 vCore | 32 GB | Up to 10 Gbps |
| Standard | db1v4m48 | 4 vCore | 48 GB | Up to 10 Gbps |
| Standard | db1v4m64 | 4 vCore | 64 GB | Up to 10 Gbps |
| Standard | db1v6m12 | 6 vCore | 12 GB | Up to 10 Gbps |
| Standard | db1v6m24 | 6 vCore | 24 GB | Up to 10 Gbps |
| Standard | db1v6m48 | 6 vCore | 48 GB | Up to 10 Gbps |
| Standard | db1v6m72 | 6 vCore | 72 GB | Up to 10 Gbps |
| Standard | db1v6m96 | 6 vCore | 96 GB | Up to 10 Gbps |
| Standard | db1v8m16 | 8 vCore | 16 GB | Up to 10 Gbps |
| Standard | db1v8m32 | 8 vCore | 32 GB | Up to 10 Gbps |
| Standard | db1v8m64 | 8 vCore | 64 GB | Up to 10 Gbps |
| Standard | db1v8m96 | 8 vCore | 96 GB | Up to 10 Gbps |
| Standard | db1v8m128 | 8 vCore | 128 GB | Up to 10 Gbps |
| Standard | db1v10m20 | 10 vCore | 20 GB | Up to 10 Gbps |
| Standard | db1v10m40 | 10 vCore | 40 GB | Up to 10 Gbps |
| Standard | db1v10m80 | 10 vCore | 80 GB | Up to 10 Gbps |
| Standard | db1v10m120 | 10 vCore | 120 GB | Up to 10 Gbps |
| Standard | db1v10m160 | 10 vCore | 160 GB | Up to 10 Gbps |
| Standard | db1v12m24 | 12 vCore | 24 GB | Up to 12.5 Gbps |
| Standard | db1v12m48 | 12 vCore | 48 GB | Up to 12.5 Gbps |
| Standard | db1v12m96 | 12 vCore | 96 GB | Up to 12.5 Gbps |
| Standard | db1v12m144 | 12 vCore | 144 GB | Up to 12.5 Gbps |
| Standard | db1v12m192 | 12 vCore | 192 GB | Up to 12.5 Gbps |
| Standard | db1v14m28 | 14 vCore | 28 GB | Up to 12.5 Gbps |
| Standard | db1v14m56 | 14 vCore | 56 GB | Up to 12.5 Gbps |
| Standard | db1v14m112 | 14 vCore | 112 GB | Up to 12.5 Gbps |
| Standard | db1v14m168 | 14 vCore | 168 GB | Up to 12.5 Gbps |
| Standard | db1v14m224 | 14 vCore | 224 GB | Up to 12.5 Gbps |
| Standard | db1v16m32 | 16 vCore | 32 GB | Up to 12.5 Gbps |
| Standard | db1v16m64 | 16 vCore | 64 GB | Up to 12.5 Gbps |
| Standard | db1v16m128 | 16 vCore | 128 GB | Up to 12.5 Gbps |
| Standard | db1v16m192 | 16 vCore | 192 GB | Up to 12.5 Gbps |
| Standard | db1v16m256 | 16 vCore | 256 GB | Up to 12.5 Gbps |
dbh2 Server Type
The dbh2 server type of EPAS(DBaaS) is provided with high-capacity server specifications and is suitable for large-scale data processing database workloads.
- Up to 3.2GHz Intel 4th generation (Sapphire Rapids) Xeon Gold 6448H Processor
- Supports up to 128 vCPUs and 1,536 GB of memory
- Up to 25Gbps networking speed
| Classification | Server Type | vCPU | Memory | Network Bandwidth |
|---|---|---|---|---|
| High Capacity | dbh2v24m48 | 24 vCore | 48 GB | Up to 25 Gbps |
| High Capacity | dbh2v24m96 | 24 vCore | 96 GB | Up to 25 Gbps |
| High Capacity | dbh2v24m192 | 24 vCore | 192 GB | Up to 25 Gbps |
| High Capacity | dbh2v24m288 | 24 vCore | 288 GB | Up to 25 Gbps |
| High Capacity | dbh2v32m64 | 32 vCore | 64 GB | Up to 25 Gbps |
| High Capacity | dbh2v32m128 | 32 vCore | 128 GB | Up to 25 Gbps |
| High Capacity | dbh2v32m256 | 32 vCore | 256 GB | Up to 25 Gbps |
| High Capacity | dbh2v32m384 | 32 vCore | 384 GB | Up to 25 Gbps |
| High Capacity | dbh2v48m192 | 48 vCore | 192 GB | Up to 25 Gbps |
| High Capacity | dbh2v48m576 | 48 vCore | 576 GB | Up to 25 Gbps |
| High Capacity | dbh2v64m256 | 64 vCore | 256 GB | Up to 25 Gbps |
| High Capacity | dbh2v64m768 | 64 vCore | 768 GB | Up to 25 Gbps |
| High Capacity | dbh2v72m288 | 72 vCore | 288 GB | Up to 25 Gbps |
| High Capacity | dbh2v72m864 | 72 vCore | 864 GB | Up to 25 Gbps |
| High Capacity | dbh2v96m384 | 96 vCore | 384 GB | Up to 25 Gbps |
| High Capacity | dbh2v96m1152 | 96 vCore | 1152 GB | Up to 25 Gbps |
| High Capacity | dbh2v128m512 | 128 vCore | 512 GB | Up to 25 Gbps |
| High Capacity | dbh2v128m1536 | 128 vCore | 1536 GB | Up to 25 Gbps |
1.2 - Monitoring Metrics
EPAS(DBaaS) Monitoring Metrics
The table below shows the performance monitoring metrics of EPAS (DBaaS) that can be checked through Cloud Monitoring. For detailed usage of Cloud Monitoring, refer to the Cloud Monitoring guide.
EPAS(DBaaS) server monitoring metrics refer to the Virtual Server Monitoring Metrics guide.
| Performance Item | Detailed Description | Unit |
|---|---|---|
| Active Locks [Access Exclusive] | Access Exclusive Locks count | cnt |
| Active Locks [Access Share] | Access Share Lock count | cnt |
| Active Locks | Active Locks count | cnt |
| Active Locks [Total] | Active Locks total count | cnt |
| Active Sessions | Number of Sessions in Active state | cnt |
| Active Sessions [Total] | Total number of Sessions in Active state | cnt |
| Apply Lag Time | Apply lag time | min |
| Check No Replication | Check No Replication value | cnt |
| Check Replication | Check Replication Status value | status |
| Connection Usage | DB connection usage rate(%) | % |
| Connection Usage [Total] | DB connection count usage rate(%) | % |
| DB Age Max | Database age (frozen XID) value | age |
| Exclusive Locks | Exclusive Locks count | cnt |
| Idle In Transaction Sessions | Number of sessions in idle in transaction state | cnt |
| Idle In Transaction Sessions [Total] | Idle in transaction state Session total count | cnt |
| Idle Sessions | Number of idle sessions | cnt |
| Idle Sessions [Total] | Total number of idle sessions | cnt |
| Row Exclusive Locks | Row Exclusive Locks count | cnt |
| Row Share Locks | Row Share Locks count | cnt |
| Share Locks | Share Locks count | cnt |
| Share Row Exclusive Locks | Share Row Exclusive Locks count | cnt |
| Share Update Exclusive Locks | Share Update Exclusive Locks count | cnt |
| Slowqueries | Number of SQL queries running for a long time (5 minutes or more) | cnt |
| Tablespace Used | Table space size | bytes |
| Tablespace Used [Total] | Table space size | bytes |
| Tablespace Used Bytes [MB] | File system directory usage (MB) | MB |
| Tablespaces [Total] | File system directory usage (MB) | MB |
| Transaction Time Max [Long] | Long-running Transaction time (minutes) | min |
| Transaction Time Max Total [Long] | Long-running Transaction time (minutes) | min |
| Wait Locks | Number of waiting lock sessions (by DB) | cnt |
| Wait Locks [Long Total] | Long duration (300 seconds) Lock waiting session count | cnt |
| Wait Locks [Long] | Number of Sessions waiting due to lock occurrence | cnt |
| Wait Locks [Total] | Total number of sessions waiting due to lock occurrence | cnt |
| Waiting Sessions | Number of Sessions in Waiting state | cnt |
| Waiting Sessions [Total] | Total number of Sessions in Waiting state | cnt |
2 - EPAS(DBaaS) Creation Guide
EPAS(DBaaS) Creation
You can easily create an EPAS database instance with just a few clicks through the Samsung Cloud Platform Console.
To create an EPAS(DBaaS) service, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the Create button. The Create EPAS(DBaaS) page will appear.
- On the Create EPAS(DBaaS) page, enter the required information in each section and click the Complete button.
| Section | Required | Description |
|---|---|---|
| Image | Required | Select the image and version
|
| Service Information | Required | Enter service information
|
| Database Configuration | Required | Configure database settings
|
| User Management | Optional | User management settings
|
| Backup Settings | Optional | Backup settings
|
| Audit Log | Optional | Audit log settings
|
| ServiceWatch | Optional | ServiceWatch settings
|
| Parameter | Optional | Database parameter settings
|
| Encoding | Optional | Encoding settings
|
| Locale | Optional | Locale settings
|
| Timezone | Optional | Timezone settings
|
| Tags | Optional | Add tags
|
EPAS(DBaaS) Resource Management
Operation Control
You can control the operation status of EPAS(DBaaS) resources.
- When stopping a resource, the database instance stops and data is not lost.
- When starting a stopped resource, the database instance restarts and data is preserved.
- When restarting a resource, the database instance restarts and data is preserved.
To control the operation status, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource you want to control. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Start, Stop, or Restart button to control the operation status.
Service Status Synchronization
You can synchronize the service status displayed in the console with the actual service status.
To synchronize the service status, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the Refresh button to synchronize the service status.
Server Type Change
You can change the server type of an EPAS(DBaaS) resource.
To change the server type, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource you want to modify. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Server Type Change button. The Server Type Change popup will appear.
- Select the new server type and click the Confirm button.
Storage Addition
You can add additional storage to an EPAS(DBaaS) resource.
To add storage, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource you want to modify. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Storage Addition button. The Storage Addition popup will appear.
- Select the storage purpose, type, and capacity, then click the Confirm button.
Storage Expansion
You can expand the storage capacity of an EPAS(DBaaS) resource.
To expand storage, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource you want to modify. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Storage Expansion button. The Storage Expansion popup will appear.
- Enter the new storage capacity and click the Confirm button.
EPAS(DBaaS) Termination
You can terminate an EPAS(DBaaS) resource.
- Terminating a resource will permanently delete all data and cannot be recovered.
- Please make sure to backup important data before terminating.
To terminate an EPAS(DBaaS) resource, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource you want to terminate. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Terminate button. The Terminate popup will appear.
- Enter the service name to confirm and click the Confirm button.
2.1 - Connection
This section explains how to connect to EPAS(DBaaS) using pgAdmin.
Connection Scenario
The scenario involves connecting to EPAS(DBaaS) through a Bastion host in a VPC environment.
Prerequisites
- VPC created
- Subnet created
- Public IP allocated
- Internet Gateway created and attached
- Security Group configured
- Virtual Server (Bastion host) created
- EPAS(DBaaS) created
Connection Steps
Create VPC
Create a VPC to host the EPAS(DBaaS) and Bastion host.
Create Subnet
Create a subnet within the VPC for the EPAS(DBaaS) and Bastion host.
Allocate Public IP
Allocate a public IP for the Bastion host to allow external access.
Create and Attach Internet Gateway
Create an Internet Gateway and attach it to the VPC to enable internet access.
Configure Security Group
Configure the security group to allow access to the EPAS(DBaaS) from the Bastion host.
Create Virtual Server (Bastion Host)
Create a Virtual Server to serve as the Bastion host.
Connect to EPAS(DBaaS) using pgAdmin
Use pgAdmin to connect to the EPAS(DBaaS) through the Bastion host.
Detailed Connection Steps
1. Create VPC
- Click All Services > Network > VPC menu.
- Click the Create button.
- Enter the VPC name and CIDR block.
- Click the Confirm button.
2. Create Subnet
- Click All Services > Network > Subnet menu.
- Click the Create button.
- Select the VPC created in step 1.
- Enter the subnet name and CIDR block.
- Click the Confirm button.
3. Allocate Public IP
- Click All Services > Network > Public IP menu.
- Click the Allocate button.
- Select the VPC and subnet created in steps 1 and 2.
- Click the Confirm button.
4. Create and Attach Internet Gateway
- Click All Services > Network > Internet Gateway menu.
- Click the Create button.
- Select the VPC created in step 1.
- Click the Confirm button.
5. Configure Security Group
- Click All Services > Network > Security Group menu.
- Click the Create button.
- Enter the security group name and description.
- Add inbound rules to allow access from the Bastion host to the EPAS(DBaaS) port.
- Click the Confirm button.
6. Create Virtual Server (Bastion Host)
- Click All Services > Compute > Virtual Server menu.
- Click the Create button.
- Select the VPC and subnet created in steps 1 and 2.
- Select the public IP allocated in step 3.
- Select the security group configured in step 5.
- Click the Confirm button.
7. Connect to EPAS(DBaaS) using pgAdmin
- Install pgAdmin on your local machine.
- Open pgAdmin and create a new server connection.
- Enter the connection information:
- Host: EPAS(DBaaS) private IP address
- Port: EPAS(DBaaS) port number (default: 5432)
- Database: Database name
- Username: Database username
- Password: Database password
- Click the Connect button to connect to the EPAS(DBaaS).
2.2 - Managing
This section explains how to manage EPAS(DBaaS) resources.
DB User Management
You can manage database users for EPAS(DBaaS).
Creating DB User
To create a database user, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource you want to manage. You will be directed to the EPAS(DBaaS) Detail page.
- Click the DB User Management button. The DB User Management popup will appear.
- Click the Create button. The Create DB User popup will appear.
- Enter the user name, password, and privileges, then click the Confirm button.
Modifying DB User
To modify a database user, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource you want to manage. You will be directed to the EPAS(DBaaS) Detail page.
- Click the DB User Management button. The DB User Management popup will appear.
- Click the Modify button next to the user you want to modify. The Modify DB User popup will appear.
- Modify the user information and click the Confirm button.
Deleting DB User
To delete a database user, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource you want to manage. You will be directed to the EPAS(DBaaS) Detail page.
- Click the DB User Management button. The DB User Management popup will appear.
- Click the Delete button next to the user you want to delete. The Delete DB User popup will appear.
- Click the Confirm button to delete the user.
DB Access Control Management
You can manage access control for EPAS(DBaaS).
Setting IP Access Control
To set IP access control, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource you want to manage. You will be directed to the EPAS(DBaaS) Detail page.
- Click the IP Access Control button. The IP Access Control popup will appear.
- Enter the IP address or CIDR block and click the Add button.
- Click the Confirm button to save the settings.
Modifying IP Access Control
To modify IP access control, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource you want to manage. You will be directed to the EPAS(DBaaS) Detail page.
- Click the IP Access Control button. The IP Access Control popup will appear.
- Click the x button next to the IP address you want to delete.
- Click the Confirm button to save the settings.
Archive Management
You can manage archive settings for EPAS(DBaaS).
Setting Archive
To set archive, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource you want to manage. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Archive button. The Archive popup will appear.
- Enable or disable archive and configure the settings.
- Click the Confirm button to save the settings.
DB Log Export
You can export database logs for EPAS(DBaaS).
Exporting DB Log
To export database logs, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource you want to manage. You will be directed to the EPAS(DBaaS) Detail page.
- Click the DB Log Export button. The DB Log Export popup will appear.
- Select the log type and date range, then click the Export button.
Minor Version Upgrade
You can upgrade the minor version of EPAS(DBaaS).
Upgrading Minor Version
To upgrade the minor version, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource you want to upgrade. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Minor Version Upgrade button. The Minor Version Upgrade popup will appear.
- Select the target version and click the Confirm button.
Migration Configuration
You can configure migration for EPAS(DBaaS).
Setting Migration
To set migration, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource you want to migrate. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Migration button. The Migration popup will appear.
- Enter the source database connection information and migration settings.
- Click the Confirm button to start the migration.
OS Kernel Upgrade
You can upgrade the OS kernel for EPAS(DBaaS).
Upgrading OS Kernel
To upgrade the OS kernel, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource you want to upgrade. You will be directed to the EPAS(DBaaS) Detail page.
- Click the OS Kernel Upgrade button. The OS Kernel Upgrade popup will appear.
- Review the upgrade information and click the Confirm button.
2.3 - Read Replica
This section explains how to configure read replicas for EPAS(DBaaS).
Creating Read Replica
You can create read replicas to scale read operations and improve performance.
To create a read replica, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the primary database resource you want to create a replica for. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Create Read Replica button. The Create Read Replica popup will appear.
- Enter the following information:
- Replica Name: Name of the read replica
- Server Type: Server type for the replica
- Storage: Storage configuration for the replica
- Click the Confirm button to create the read replica.
Configuring Read Replica
You can configure the settings of a read replica.
Modifying Read Replica
To modify a read replica, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the read replica resource you want to modify. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Modify button. The Modify Read Replica popup will appear.
- Modify the settings and click the Confirm button.
Promoting Read Replica
You can promote a read replica to a standalone primary database.
To promote a read replica, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the read replica resource you want to promote. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Promote button. The Promote Read Replica popup will appear.
- Review the promotion information and click the Confirm button to promote the replica.
Deleting Read Replica
You can delete a read replica.
To delete a read replica, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the read replica resource you want to delete. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Delete button. The Delete Read Replica popup will appear.
- Click the Confirm button to delete the read replica.
2.4 - DB Backup and Recovery
Users can configure backups for EPAS(DBaaS) through the Samsung Cloud Platform Console and recover using the backed up files.
EPAS(DBaaS) Backup
To ensure users’ data is safely stored, EPAS(DBaaS) provides data backup functionality based on its own backup commands. Additionally, you can verify whether backups were performed normally through the backup history feature and delete backed up files.
Setting Backup
For information on how to set up backups for EPAS(DBaaS), see EPAS(DBaaS) Creation Guide.
To modify the backup settings of a created resource, follow these steps:
- For stable backup, it is recommended to add separate BACKUP storage or sufficiently expand the storage capacity. In particular, if the backup target data exceeds 100 GB and there are many data changes, please secure additional storage equivalent to approximately 60% of the data capacity. For information on adding and expanding storage, see EPAS(DBaaS) Storage Addition and EPAS(DBaaS) Storage Expansion guides.
- If backup is set, backup will be performed at the specified time after the set time, and additional charges will be incurred depending on the backup capacity.
- If the backup setting is changed to Not Set, backup execution will immediately stop, and stored backup data will be deleted and can no longer be used.
To set up backup, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource for which you want to set up backup. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Modify button in the Backup section. The Backup Settings popup will appear.
- To set up backup, click Enable in the Backup Settings popup, select the retention period, backup start time, and archive backup cycle, then click the Confirm button.
- To stop backup settings, uncheck Enable in the Backup Settings popup and click the Confirm button.
Checking Backup History
To view backup history, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource for which you want to check backup history. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Backup History button. The Backup History popup will appear.
- In the Backup History popup, you can check the backup status, version, backup start date/time, backup completion date/time, and capacity.
Deleting Backup Files
To delete backup history, follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) List page, click the resource for which you want to check backup history. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Backup History button. The Backup History popup will appear.
- In the Backup History popup, check the file you want to delete and click the Delete button.
EPAS(DBaaS) Recovery
If recovery using backup files is required due to failure or data loss, you can recover based on a specific point in time through the recovery function. When EPAS(DBaaS) recovery is performed, a new server is created with the OS image at the time of initial provisioning, the DB is installed with the version at that backup point, and recovery proceeds with the DB configuration information and data.
To recover EPAS(DBaaS), follow these steps:
- Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
- On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
- On the EPAS(DBaaS) Resource list page, click the resource you want to recover. You will be directed to the EPAS(DBaaS) Detail page.
- Click the Database Recovery button. You will be directed to the Database Recovery page.
- After entering the corresponding information in the Database Recovery Configuration section, click the Complete button.
Item RequiredDetailed Description Recovery Type Required Set the point in time the user wants to recover - Backup Point (Recommended): Recovery based on backup files. Select from the list of backup file points displayed in the list
- User-Specified Point: Recover to a point desired by the user within the range of points where backup is possible. The recoverable period can recover from the first backup start time to 1 hour/30 minutes/10 minutes/5 minutes before the current time depending on the Archive backup cycle setting value. Select the date and time you want to backup
Server Name Prefix Required Recovered DB server name - Enter 3~16 characters starting with lowercase English letters and using lowercase letters, numbers, and special characters (
-)
- Actual server name is created with a postfix like 001, 002 based on the server name
Cluster Name Required Recovered DB cluster name - Enter 3~20 characters using English letters
- Cluster is a unit that groups multiple servers
Service Type > Server Type Required Recovered DB server type - Standard: Standard specifications generally used
- High Capacity: Large capacity servers with 24vCore or more
Service Type > Planned Compute Optional Status of resources with Planned Compute set - In Use: Number of resources in use among resources with Planned Compute set
- Set: Number of resources with Planned Compute set
- Coverage Preview: Amount applied by Planned Compute for each resource
- Create Planned Compute Service: Move to Planned Compute service application page
- For details, see Applying for Planned Compute
Service Type > Block Storage Required Block Storage settings used by recovered DB - Basic OS: Area where DB engine is installed
- DATA: Storage area for table data and archive files
- Applied identically with the Storage type set in the original cluster
- Enter capacity in multiples of 8 in the range of 16~5,120
- Additional: DATA, Archive, TEMP, Backup data storage area
- Applied identically with the Storage type set in the original cluster
- In recovered DB, only DATA, TEMP, Archive purposes can be added
- Select Use and then enter the storage purpose and capacity
- Click + button to add storage, x button to delete
- Capacity can be entered in multiples of 8 in the range of 16~5,120, and up to 9 can be created
Database Username Required Database username - Applied identically with the username set in the original cluster
Database Port Number Required Database port number - Applied identically with the port number set in the original cluster
IP Access Control Optional Service access policy settings - Sets access policy for IPs entered on the page, so separate Security Group policy settings are not required
- Enter in IP format (e.g.,
192.168.10.1) or CIDR format (e.g.,192.168.10.0/24,192.168.10.1/32) and click the Add button
- To delete an entered IP, click the x button next to the entered IP
Maintenance Window Optional DB maintenance window - If you select Use, set the day of week, start time, and duration
- It is recommended to set a maintenance window for stable DB management. Patch operations proceed at the set time and service interruption occurs
- If set to Not Use, Samsung SDS is not responsible for problems caused by not applying patches
Tags Optional Add tags - Click the Add Tag button and then enter or select Key, Value values
Table. EPAS(DBaaS) Recovery Configuration Items
2.5 - Extension use
EPAS(DBaaS) Extension usage
The list of Extensions that can be installed in the current database can be checked with the following SQL sentence.
SQL> select * from pg_available_extensions;
In EPAS(DBaaS), the items that are installed additionally, excluding the default Extensions included in each version, are as follows.
| Extension Name | Description |
|---|---|
| pg_cron | a scheduler that allows job scheduling with cron syntax within the database |
| pgvector | Vector data type and similarity search, etc. AI vector operation function provided |
| postgis | GIS (Geographic Information System) provides spatial object storage and spatial query functionality |
In addition to the above items, if additional Extension installation is required, please refer to Support Center > Inquiry for inquiries.
- Once your inquiry is received, we will review and proceed with the installation. Please note that some Extensions may not work properly during Replica configuration and recovery.
3 - API Reference
4 - CLI Reference
5 - Release Notes
- Added disaster recovery replica function
- Added OS upgrade function
- Added DB user management function
- Added Archive management function
- Added audit log export function
- Added backup notification function
- Added migration function
- Added 2nd generation server
- Launched EPAS(DBaaS) service