EPAS(DBaaS) Creation Guide

• 1: Connection
• 2: Managing
• 3: Read Replica
• 4: DB Backup and Recovery
• 5: Extension use

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

1. Create VPC

   Create a VPC to host the EPAS(DBaaS) and Bastion host.

2. Create Subnet

   Create a subnet within the VPC for the EPAS(DBaaS) and Bastion host.

3. Allocate Public IP

   Allocate a public IP for the Bastion host to allow external access.

4. Create and Attach Internet Gateway

   Create an Internet Gateway and attach it to the VPC to enable internet access.

5. Configure Security Group

   Configure the security group to allow access to the EPAS(DBaaS) from the Bastion host.

6. Create Virtual Server (Bastion Host)

   Create a Virtual Server to serve as the Bastion host.

7. Connect to EPAS(DBaaS) using pgAdmin

   Use pgAdmin to connect to the EPAS(DBaaS) through the Bastion host.

Detailed Connection Steps

1. Create VPC

1. Click All Services > Network > VPC menu.
2. Click the Create button.
3. Enter the VPC name and CIDR block.
4. Click the Confirm button.

2. Create Subnet

1. Click All Services > Network > Subnet menu.
2. Click the Create button.
3. Select the VPC created in step 1.
4. Enter the subnet name and CIDR block.
5. Click the Confirm button.

3. Allocate Public IP

1. Click All Services > Network > Public IP menu.
2. Click the Allocate button.
3. Select the VPC and subnet created in steps 1 and 2.
4. Click the Confirm button.

4. Create and Attach Internet Gateway

1. Click All Services > Network > Internet Gateway menu.
2. Click the Create button.
3. Select the VPC created in step 1.
4. Click the Confirm button.

5. Configure Security Group

1. Click All Services > Network > Security Group menu.
2. Click the Create button.
3. Enter the security group name and description.
4. Add inbound rules to allow access from the Bastion host to the EPAS(DBaaS) port.
5. Click the Confirm button.

6. Create Virtual Server (Bastion Host)

1. Click All Services > Compute > Virtual Server menu.
2. Click the Create button.
3. Select the VPC and subnet created in steps 1 and 2.
4. Select the public IP allocated in step 3.
5. Select the security group configured in step 5.
6. Click the Confirm button.

7. Connect to EPAS(DBaaS) using pgAdmin

1. Install pgAdmin on your local machine.
2. Open pgAdmin and create a new server connection.
3. 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
4. Click the Connect button to connect to the EPAS(DBaaS).

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:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource you want to manage. You will be directed to the EPAS(DBaaS) Detail page.
4. Click the DB User Management button. The DB User Management popup will appear.
5. Click the Create button. The Create DB User popup will appear.
6. Enter the user name, password, and privileges, then click the Confirm button.

Modifying DB User

To modify a database user, follow these steps:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource you want to manage. You will be directed to the EPAS(DBaaS) Detail page.
4. Click the DB User Management button. The DB User Management popup will appear.
5. Click the Modify button next to the user you want to modify. The Modify DB User popup will appear.
6. Modify the user information and click the Confirm button.

Deleting DB User

To delete a database user, follow these steps:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource you want to manage. You will be directed to the EPAS(DBaaS) Detail page.
4. Click the DB User Management button. The DB User Management popup will appear.
5. Click the Delete button next to the user you want to delete. The Delete DB User popup will appear.
6. 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:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource you want to manage. You will be directed to the EPAS(DBaaS) Detail page.
4. Click the IP Access Control button. The IP Access Control popup will appear.
5. Enter the IP address or CIDR block and click the Add button.
6. Click the Confirm button to save the settings.

Modifying IP Access Control

To modify IP access control, follow these steps:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource you want to manage. You will be directed to the EPAS(DBaaS) Detail page.
4. Click the IP Access Control button. The IP Access Control popup will appear.
5. Click the x button next to the IP address you want to delete.
6. 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:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource you want to manage. You will be directed to the EPAS(DBaaS) Detail page.
4. Click the Archive button. The Archive popup will appear.
5. Enable or disable archive and configure the settings.
6. 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:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource you want to manage. You will be directed to the EPAS(DBaaS) Detail page.
4. Click the DB Log Export button. The DB Log Export popup will appear.
5. 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:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource you want to upgrade. You will be directed to the EPAS(DBaaS) Detail page.
4. Click the Minor Version Upgrade button. The Minor Version Upgrade popup will appear.
5. 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:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource you want to migrate. You will be directed to the EPAS(DBaaS) Detail page.
4. Click the Migration button. The Migration popup will appear.
5. Enter the source database connection information and migration settings.
6. 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:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) List page, click the resource you want to upgrade. You will be directed to the EPAS(DBaaS) Detail page.
4. Click the OS Kernel Upgrade button. The OS Kernel Upgrade popup will appear.
5. Review the upgrade information and click the Confirm button.

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:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. 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.
4. Click the Create Read Replica button. The Create Read Replica popup will appear.
5. Enter the following information:
   • Replica Name: Name of the read replica
   • Server Type: Server type for the replica
   • Storage: Storage configuration for the replica
6. 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:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. 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.
4. Click the Modify button. The Modify Read Replica popup will appear.
5. 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:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. 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.
4. Click the Promote button. The Promote Read Replica popup will appear.
5. 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:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. 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.
4. Click the Delete button. The Delete Read Replica popup will appear.
5. Click the Confirm button to delete the read replica.

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:

To set up backup, follow these steps:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. 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.
4. Click the Modify button in the Backup section. The Backup Settings popup will appear.
5. 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:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. 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.
4. Click the Backup History button. The Backup History popup will appear.
5. 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:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. 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.
4. Click the Backup History button. The Backup History popup will appear.
5. 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:

1. Click All Services > Database > EPAS(DBaaS) menu. You will be directed to the Service Home page for EPAS(DBaaS).
2. On the Service Home page, click the EPAS(DBaaS) menu. You will be directed to the EPAS(DBaaS) List page.
3. On the EPAS(DBaaS) Resource list page, click the resource you want to recover. You will be directed to the EPAS(DBaaS) Detail page.
4. Click the Database Recovery button. You will be directed to the Database Recovery page.
5. After entering the corresponding information in the Database Recovery Configuration section, click the Complete button.

   Item	Required	Detailed 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

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.

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.