How-to guides

• 1: Managing DB Services
• 2: DB Backup and Recovery
• 3: Read Replica Setup
• 4: Connect to DB Server
• 5: Using Extensions

1 - Managing DB Services

Users can manage PostgreSQL (DBaaS) through the Samsung Cloud Platform Console.

Managing Parameters

It provides a feature to easily view and modify database configuration parameters.

Viewing Parameters

To view configuration parameters, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
3. Click the resource you want to view and modify parameters on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the Parameter Management button. The Parameter Management popup window opens.
5. Click the View button in the Parameter Management popup window. The View Notification popup window opens.
6. When the View Notification popup window opens, click the OK button. It takes some time to view.

Modifying Parameters

To modify configuration parameters, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
3. Click the resource you want to view and modify parameters on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the Parameter Management button. The Parameter Management popup window opens.
5. Click the View button in the Parameter Management popup window. The View Notification popup window opens.
6. When the View Notification popup window opens, click the OK button. It takes some time to view.
7. If modification is required, click the Modify button and enter the modification details in the custom value area of the parameter to be modified.
8. When the input is complete, click the Save button.

Managing DB Users

It provides a management feature that allows you to view DB user information and change status information.

Viewing DB Users

To view DB users, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
3. Click the resource you want to view DB users on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the DB User Management button. It moves to the DB User Management page.
5. Click the View button on the DB User Management page. It takes some time to view.

Changing DB User Status

To change the status of the viewed DB user, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
3. Click the resource you want to modify DB users on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the DB User Management button. It moves to the DB User Management page.
5. Click the View button on the DB User Management page. It takes some time to view.
6. If modification is required, click the Modify button and change the status value or enter notes.
7. When the input is complete, click the Save button.

Managing DB Access Control

It provides an IP-based DB user access control management feature. Users can directly specify the IP that can access the database, allowing only allowed IPs to access.

Viewing DB Access Control

To view DB users with IP access control set, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
3. Click the resource you want to manage access control on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the DB Access Control Management button. It moves to the DB Access Control Management page.
5. Click the View button on the DB Access Control Management page. It takes some time to view.

Adding DB Access Control

To add IP access control, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. It moves to the PostgreSQL(DBaaS) List page.
3. Click the resource you want to add IP access control on the PostgreSQL(DBaaS) List page. It moves to the PostgreSQL(DBaaS) Details page.
4. Click the More button and then click the DB Access Control Management button. It moves to the DB Access Control Management page.
5. Click the View button on the DB Access Control Management page. It takes some time to view.
6. When the view is complete, click the Add button. The DB Access Control Add popup window opens.
7. In the DB Access Control Add popup window, select the DB user name and enter the IP address.
8. When the input is complete, click the Save button.

Deleting DB Access Control

To delete IP access control, follow these steps:

1. All Services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. On the PostgreSQL(DBaaS) list page, click the resource for which you want to delete IP access control. It moves to the PostgreSQL(DBaaS) details page.
4. Click the More button and then click the DB Access Control Management button. It moves to the DB Access Control Management page.
5. On the DB Access Control Management page, click the Inquire button. It takes some time to inquire.
6. Once the inquiry is complete, click the Delete button. The Delete pop-up window opens.
7. In the Delete pop-up window, click the Confirm button.

Managing Archive

It provides functions to set Archive mode and Archive log retention period, allowing users to flexibly set Archive log management policies according to their operating environment. Additionally, it provides a function to manually delete Archive logs, allowing users to clean up unnecessary log data and effectively manage system resources.

Setting Archive Mode

To set Archive mode, follow these steps:

1. All Services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. On the PostgreSQL(DBaaS) list page, click the resource for which you want to set Archive mode. It moves to the PostgreSQL(DBaaS) details page.
4. Click the More button and then click the Archive Settings Management button. It moves to the Archive Settings Management page.
5. On the Archive Settings Management page, click the Inquire button. It takes some time to inquire.
6. Click the Modify button and select the usage and retention period.
7. Once the modification is complete, click the Save button.

Deleting Archive Files

To delete Archive files, follow these steps:

1. All Services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. On the PostgreSQL(DBaaS) list page, click the resource for which you want to set Archive mode. It moves to the PostgreSQL(DBaaS) details page.
4. Click the More button and then click the Archive Settings Management button. It moves to the Archive Settings Management page.
5. On the Archive Settings Management page, click the Delete All Archives button to delete all Archive files, or click the Delete Backed-up Archives button to delete only backed-up Archive files.

Exporting DB Logs

It supports exporting audit logs that require long-term storage to Object Storage. Users can directly set the type of log to be stored, the target Bucket, and the frequency of log export. According to the set criteria, it copies the logs to the specified Object Storage for storage. Additionally, to efficiently manage disk space, it provides an option to automatically delete the original log files when exporting logs to Object Storage. By utilizing this option, users can effectively secure storage capacity while safely storing necessary log data for long-term storage.

Setting DB Log Export Mode

To set DB Log export mode, follow these steps:

1. All Services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. On the PostgreSQL(DBaaS) list page, click the resource for which you want to export DB logs. It moves to the PostgreSQL(DBaaS) details page.
4. Click the More button and then click the DB Log Export button. It moves to the DB Log Export page.
5. On the DB Log Export page, click the Register button. It moves to the DB Log Export Registration page.
6. On the DB Log Export Registration page, enter the corresponding information and click the Save button.

Managing DB Log Export

To modify, cancel, or immediately export DB log settings, follow these steps:

1. All Services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. On the PostgreSQL(DBaaS) list page, click the resource for which you want to manage DB log export. It moves to the PostgreSQL(DBaaS) details page.
4. Click the More button and then click the DB Log Export button. It moves to the DB Log Export page.
5. On the DB Log Export page, click the More button for the log type you want to manage, and then click the Immediate Export, Modify, or Cancel button.
   • Immediate Export: Exports the selected log to the Object Storage Bucket set earlier.
   • Modify: Modifies the DB log export mode setting.
   • Cancel: Cancels the DB log export mode setting.

Upgrading DB Version

It provides a version upgrade function due to some feature improvements and security patches. Only minor version upgrades are supported within the same major version.

To upgrade the version, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. On the PostgreSQL(DBaaS) list page, click the resource to upgrade the version. It moves to the PostgreSQL(DBaaS) details page.
4. Click the Modify button in the image/version item. The Version Upgrade popup window opens.
5. In the Version Upgrade popup window, select the version to modify and whether to set backup, and then click the Confirm button.
6. In the Version Upgrade Notification popup window, click the Confirm button.

Configuring Migration

It provides a migration function that synchronizes with the operating database in real-time and replicates in a replication manner without interrupting the service.

To configure migration, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. On the PostgreSQL(DBaaS) list page, click the resource to migrate. It moves to the PostgreSQL(DBaaS) details page.
4. Click the More button and then click the Configure Migration button. The Configure Migration popup window opens.
5. In the Configure Migration popup window, check the instructions and click the Confirm button. It moves to the Configure Migration page.
6. On the Configure Migration page, enter the corresponding information and click the Connect Check button.
7. When the connection is complete, click the Complete button.

The configured migration cluster can be promoted to a master cluster.

To promote the migration cluster to master, follow these steps:

1. Click the All Services > Database > PostgreSQL(DBaaS) menu. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. On the PostgreSQL(DBaaS) list page, click the resource to promote to master. It moves to the PostgreSQL(DBaaS) details page.
4. Click the More button and then click the Promote to Master button. The Promote to Master Notification popup window opens.
5. In the Promote to Master Notification popup window, click the Confirm button.

2 - DB Backup and Recovery

The user can set up a backup of PostgreSQL(DBaaS) through the Samsung Cloud Platform Console and restore it with the backed-up file.

PostgreSQL(DBaaS) backup

PostgreSQL(DBaaS) provides a data backup feature based on its own backup command, and also provides an optimized backup environment for data protection and management through backup history checking and backup file deletion functions.

Setting up backup

The method of setting up a backup of PostgreSQL(DBaaS) is described in PostgreSQL(DBaaS) creation guide.

To modify the backup settings of the generated resource, follow these steps.

To set up a backup, follow these steps.

1. All Services > Database > PostgreSQL(DBaaS) menu is clicked. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. PostgreSQL(DBaaS) list page, click the resource to set the backup. It moves to the PostgreSQL(DBaaS) details page.
4. Click the Edit button of the backup item. The Backup Settings popup window will open.
5. If you set up a backup, click Use in the Backup Settings popup window, select the retention period, backup start time, and Archive backup cycle, and then click the Confirm button.
   • If you want to stop the backup setting, uncheck Use in the Backup Setting popup window and click the OK button.

Check Backup History

To view the backup history, follow these steps.

1. 모든 서비스 > Database > PostgreSQL(DBaaS) menu should be clicked. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. PostgreSQL(DBaaS) list page, click the resource to check the backup history. It moves to the PostgreSQL(DBaaS) details page.
4. Click the Backup History button. The Backup History popup window will open.
5. Backup History popup window where you can check the backup status, version, backup start time, backup completion time, and capacity.

Deleting backup files

To delete the backup history, follow these steps.

1. All services > Database > PostgreSQL(DBaaS) menu, click. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. PostgreSQL(DBaaS) list page, click the resource to check the backup history. It moves to the PostgreSQL(DBaaS) details page.
4. Click the Backup History button. The Backup History popup window opens.
5. Backup History popup window, check the file you want to delete, and then click the Delete button.

PostgreSQL(DBaaS) recovery

In the event of a failure or data loss that requires restoration from a backup file, the recovery function can be used to restore to a specific point in time. When performing a PostgreSQL (DBaaS) recovery, a new server is created with the OS image at the initial provisioning time, the DB is installed with the version at the backup point, and the recovery proceeds with the DB configuration information and data.

To restore PostgreSQL(DBaaS), follow these steps.

1. All services > Database > PostgreSQL(DBaaS) menu is clicked. It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the PostgreSQL(DBaaS) menu. It moves to the PostgreSQL(DBaaS) list page.
3. PostgreSQL(DBaaS) resource list page, click the resource you want to restore. It moves to the PostgreSQL(DBaaS) detail page.
4. Database Recovery 버튼을 클릭하세요. Database Recovery 페이지로 이동합니다.
5. Database Recovery Configuration area, enter the corresponding information, and then click the Complete button.

3 - Read Replica Setup

The user can enter the required information for a Read Replica through the Samsung Cloud Platform Console and create the service using detailed options.

Replica Configure

Through the Replica configuration, you can create replica servers for read-only or disaster recovery purposes. You can create up to 5 Replicas per Database.

To configure a replica, follow these steps.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. Navigate to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. Go to the PostgreSQL(DBaaS) List page.
3. PostgreSQL(DBaaS) List Click the resource to configure the replica on the page. PostgreSQL(DBaaS) Detail Navigate to the page.
4. Click the Replica configuration button. Navigate to the Replica configuration page.
5. Replica configuration After entering information in the area, click the Complete button.

   Category	Required	Detailed description
   Region	Required	Region to configure Replica Replica configuration (Other Region) displayed only when selected
   Number of Replicas	Required	Number of Replicas to configure Up to 5 can be configured per cluster If selecting more than 2 values, additionally input Replica name and service type information
   Replica name	Required	Replica server name Start with a lowercase English letter, and use lowercase letters, numbers, and the special character (-) to input 3 to 19 characters The entered Replica name is displayed as the cluster name in the list
   Service Type > Server Type	Required	Replica Server Type Standard: Standard specifications commonly used High Capacity: Large-capacity server with 24 vCore or more
   Service Type > Planned Compute	Optional	Status of resources with Planned Compute set In Use: Number of resources with Planned Compute that are currently in use Configured: Number of resources with Planned Compute set Coverage Preview: Amount applied per resource by Planned Compute Create Planned Compute Service: Go to the Planned Compute service application page For details, refer to Apply for Planned Compute
   IP Access Control	Select	Service Access Policy Settings Since the access policy is set for the IP entered on the page, a separate Security Group policy setting is 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 Period	Select	DB Maintenance Period If Use is selected, set the day of the week, start time, and duration. It is recommended to set a maintenance period for stable DB management. Patch work will be performed at the set time, causing service interruption. If set to not use, we are not responsible for issues arising from patches not being applied.
   Tag	Select	Add Tag Add Tag button click then input or select Key, Value values

   Table. PostgreSQL(DBaaS) Replica configuration items

Replica Reconstruct

If a network failure or replication delay with the Master Cluster occurs, you can re-replicate the Master Cluster’s data using the Replica reconstruction function.

To reconstruct the Replica, follow these steps.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. Go to the Service Home page of PostgreSQL(DBaaS).
2. Service Home page, click the PostgreSQL(DBaaS) menu. Move to the PostgreSQL(DBaaS) list page.
3. PostgreSQL(DBaaS) list page, click the resource to reconfigure the Replica. PostgreSQL(DBaaS) details page will be opened.
4. Replica reconstruction Click the button. Replica reconstruction notification A popup window opens.
5. Replica Reconstruction Notification in the popup window click the Confirm button.

Promote Replica Cluster to Master Cluster

You can promote a Replica Cluster that has completed configuration to a Master Cluster.

To promote a Replica Cluster to Master, follow these steps.

1. All Services > Database > PostgreSQL(DBaaS) Click the menu. Navigate to the Service Home page of PostgreSQL(DBaaS).
2. Click the PostgreSQL(DBaaS) menu on the Service Home page. Navigate to the PostgreSQL(DBaaS) List page.
3. Click the resource to promote to Master on the PostgreSQL(DBaaS) List page. You will be taken to the PostgreSQL(DBaaS) Details page.
4. Click the More button and click the Master promotion button. The Master promotion notification popup window opens.
5. Master Promotion Notification in the popup window click the Confirm button.

4 - Connect to DB Server

Scenario Overview

The PostgreSQL(DBaaS) server connection scenario is a scenario where a Bastion host (Virtual Server) and Database service are created, and the DB service is accessed through the Bastion host. To securely access PostgreSQL(DBaaS) in the Samsung Cloud Platform environment, it is necessary to create a Bastion host and use it for network connection. To maintain a stable and high level of security, it is recommended to configure the Database service in a Private Subnet environment and configure the Bastion host in a limited Public Subnet environment.

This scenario largely describes the process of creating Bastion host and Database services, and configuring the network environment for Bastion host and Database connection, to connect through a DB access client.

Scenario Components

You can configure the scenario using the following services.

Scenario composition method

To configure the scenario, create the necessary services through the following procedure.

1. Configuring the Network

This describes the process of configuring the network environment for Bastion Host and Database service connection.

1-1. Creating a VPC

1. Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
2. On the Service Home page, click the Create VPC button. It moves to the Create VPC page.
3. VPC Creation page, please enter the information required for service creation.
   • IP range should be entered as 192.168.x.0/16.
4. In the Summary panel, review the detailed information and estimated charges, then click the Complete button.
   • After creation is complete, check the created resource on the VPC list page.

1-2. Creating a Subnet

1. Click on the menu for all services > Networking > VPC. It moves to the Service Home page of VPC.
2. Service Home page, click the Subnet menu. It moves to the Subnet list page.
3. Click the Subnet Creation button. It moves to the Subnet Creation page.
4. Subnet Creation page where you enter the information needed to create a service.
   • Subnet type should be selected as General.
   • Please select a pre-created VPC.
   • IP range should be entered as 192.168.x.0/24.
5. In the Summary panel, review the detailed information and estimated charges, then click the Complete button.
   • Once creation is complete, check the created resource on the Subnet list page.

1-3. Creating an Internet Gateway

1. Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
2. Service Home page, click the Internet Gateway menu. It moves to the Internet Gateway list page.
3. Click the Create Internet Gateway button. It moves to the Create Internet Gateway page.
4. Internet Gateway creation page, please enter the required information necessary for service creation.
   • Please select a pre-created VPC.
   • Select Use in the Firewall usage item.
5. In the Summary panel, review the detailed information and the estimated charge, then click the Complete button.
   • Once the creation is complete, check the created resource on the Internet Gateway list page.

1-4. Creating a Public IP

1. Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
2. Service Home page, click the Public IP menu. It moves to the Public IP list page.
3. Public IP Reservation button, click. Move to the Public IP Reservation page.
4. Public IP Reservation page, enter the required information necessary for service reservation.
5. In the Summary panel, review the detailed information and estimated charges, then click the Complete button.
   • After creation is complete, check the created resource on the Public IP List page.

1-5. Creating a Security Group

1. Click on the menu for all services > Networking > Security Group. It moves to the Service Home page of Security Group.
2. Click the Security Group creation button on the Service Home page. It moves to the Security Group creation page.
3. Security Group creation page where you enter the required information necessary for service creation.
4. Check the input information and click the Complete button.
   • After creation is complete, check the created resource on the Security Group list page

2. Creating a Bastion Host

This describes the process of configuring the Bastion Host where the database connection client should be installed.

2-1. Creating a Server Keypair

1. Click All Services > Compute > Virtual Server menu. It moves to the Service Home page of Virtual Server.
2. Click the Keypair menu on the Service Home page. It moves to the Keypair list page.
3. Keypair creation button should be clicked. It moves to the Keypair creation page.
4. Keypair creation page, please enter the required information necessary for service creation.
5. Check the creation information and click the Complete button.
   • The key can only be downloaded for the first time, and re-issuance is not provided.
   • Please keep the downloaded key in a safe place.

2-2. Creating a Bastion Host

1. Click All Services > Compute > Virtual Server menu. It moves to the Service Home page of Virtual Server.
2. Click the Virtual Server Creation button on the Service Home page. It moves to the Virtual Server Creation page.
3. Virtual Server creation page where you enter the required information necessary for service creation.
   • Image is Windows please select.
   • Please select the pre-created VPC and Subnet.
   • Click NAT usage and select the Public IP reserved in 1-4. Public IP creation.
   • 2-1. Creating Server Keypair Connect the Keypair created from 2-1. Creating Server Keypair.
4. Summary panel, check the detailed information generated and the expected billing amount, and click the Complete button.
   • Once creation is complete, check the created resource on the Virtual Server list page.

2-3. Check Bastion host connection ID and PW

1. Click on the menu for all services > Compute > Virtual Server. It moves to the Service Home page of Virtual Server.
2. Service Home page, click the Virtual Server menu. Move to the Virtual Server list page.
3. Virtual Serve list page, click on the resource created in 2-2. Bastion host creation. It moves to the detailed information page of the corresponding resource.
4. Click the RDP password inquiry button in the Keypair item on the detailed information page. The RDP password inquiry popup window will open.
5. RDP password inquiry popup window, attach the keypair file downloaded from 2-1. Creating a server keypair.
6. After attaching, click the Password Check button. The ID and password required to access the resource will be displayed.
   • The ID and Password will be used as information to connect to the Bastion host later, as described in 5-1. Connect to Bastion host.

3. Creating a Database

Describes the process of creating a database service.

3-1. Creating PostgreSQL(DBaaS) Service

1. Click on the menu for all services > Database > PostgreSQL(DBaaS). It moves to the Service Home page of PostgreSQL(DBaaS).
2. On the Service Home page, click the Create PostgreSQL(DBaaS) button. It moves to the Create PostgreSQL(DBaaS) page.
3. PostgreSQL(DBaaS) creation page, please enter the required information needed for service creation.
   • Select and connect the pre-created VPC and Subnet.
   • Enter database-related creation information on the essential information input screen.
   • Add the Bastion host IP to the IP access control items.
   • Database Port is 2866 by default, but you can specify it as you want.
4. In the Summary panel, review the detailed information and estimated charges, then click the Complete button.
   • After creation is complete, check the created resource on the PostgreSQL(DBaaS) list page.

4. Setting Rules

This describes the process of setting rules for users to access the Bastion host and rules for the Bastion host to access the Database.

4-1. Adding Security Group Security Rules

1. Click on the menu for all services > Networking > Security Group. It moves to the Service Home page of Security Group.
2. Service Home page, click the Security Group menu. Move to the Security Group list page.
3. 1-5. Creating a Security Group Select the Security Group resource created from. It will move to the detailed information page of the resource.
4. Click the Rules tab on the detail information page. It moves to the Rules tab.
5. Click the Rules tab and click the Add Rule button. It moves to the Add Rule popup window.
6. Add Rule popup window, enter the rules below, and click the OK button

4-2. Adding IGW Firewall Rules

1. Click All services > Networking > Firewall menu. It moves to the Service Home page of Firewall.
2. Service Home page, click the Firewall menu. It moves to the Firewall list page.
3. Firewall list page, select the Internet Gateway resource name created in 1-3. Creating Internet Gateway, and move to the detailed information page of the corresponding resource.
4. Click the Rules tab on the detailed information page. It moves to the Rules tab.
5. Click the Rule tab and click the Add Rule button. It moves to the Add Rule popup window.
6. Add Rule In the popup window, enter the rules below and click the OK button.

5. Connect to Database

This describes the process of a user accessing the Database through a DB connection client program.

This guide provides instructions on how to connect using pgAdmin. There are various database client programs and CLI utilities, so you can install and use the tools that are suitable for the user.

5-1. Connect to the Bastion host

1. Run Remote Desktop Connection in the Windows environment of the PC you want to connect to the Bastion host, enter the NAT IP of the Bastion Host, and click the Connect button.
2. After a successful remote desktop connection, the User Credential Input Window opens. Enter the ID and Password confirmed in 2-3. Checking Bastion Host Access ID and PW and click the Confirm button.

5-2. Installing DB connection client program (pgAdmin) on the Bastion host

1. Go to the official pgAdmin page and download the pgAdmin program.
   • pgAdmin program download path: https://www.pgadmin.org/download/
2. Connect the hard drive of the user PC to upload the file to the Bastion host.
3. Click the Details button for local devices and resources entries in the Local Resources tab of Remote Desktop Connection.
4. Select the local disk where the file was downloaded to the drive and click the Confirm button.
5. Copy the downloaded file and upload it to the Bastion Host, then click the pgAdmin installation file to install it.

5-3. Using DB connection client program (pgAdmin) to connect to the database

1. Run pgAdmin and click the Add New Server button.
2. In the Register - Server popup window, enter the Database server information created in 3-1. PostgreSQL(DBaaS) service creation in the General tab and Connection tab, and click the Save button.

   Screen (Tab)	Required Input Element Items	Input Value
   General	Name	Custom (ex. Service Name)
   Connection	Host name/address	Database server IP
   Connection	Port	Database Port
   Connection	Maintenance database	Database name
   Connection	Password	Database password

   DB connection client program input items
3. Click the database name created on pgAdmin to connect.
   • You can try simple queries after connecting.

5 - Using Extensions

PostgreSQL(DBaaS) Extension usage

The list of extensions that can be installed in the current database can be checked with the following SQL statement.

SQL> select * from pg_available_extensions;

PostgreSQL(DBaaS) has the following additional installation items outside of the default extension by version:

In addition to the above items, if additional Extension installation is required, please refer to Support Center > 문의하기 and inquire.

• Once the inquiry is received, we will proceed with the installation after review. Please note that some Extensions may not work normally during Replica configuration and recovery.