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).