Cloud DB for PostgreSQL scenario

Available in VPC

NAVER Cloud Platform's Cloud DB for PostgreSQL easily and quickly builds PostgreSQL Servers in cloud environments, and operates and manages them to enable stable database service. The full sequence for utilizing NAVER Cloud Platform's Cloud DB for PostgreSQL is as follows.

The descriptions for each step are as follows.

1. Create application server
2. Set access environment
3. Test application server connection
4. Create PostgreSQL Server
5. Set ACG
6. Test PostgreSQL Server connection

1. Create application server

First, create an application server (app server) that will communicate with the PostgreSQL Server to be created from Cloud DB for PostgreSQL of the NAVER Cloud Platform console. Currently, Cloud DB for PostgreSQL is only accessible within NAVER Cloud Platform. Thus, the application server must also reside in NAVER Cloud Platform. The application server (app server) can be created from the Services > Server menu of the NAVER Cloud Platform console.
You can refer to the following guides:

• Application server creation quick guide
• Application server creation guide

2. Set access environment

Once you've completed creating an application server, set up an access environment so that users can access the application server. You have two ways of setting the access environment, which are described as follows:

• Set up access to a private domain using the public IP of NAVER Cloud Platform
• Set up external access using SSL VPN of NAVER Cloud Platform

For access settings using the public IP, you need to check the admin (root) password required for the server access, using the Get admin password feature. For access settings using the SSL VPN product, you can access the DB server by installing the SSL VPN client on your personal PC. For better security, it is recommended to use the SSL VPN product for administrative purposes.
You can refer to the following guides:

• Public IP/SSL VPN settings quick guide
• Public IP settings guide
• SSL VPN settings guide

3. Test application server connection

Once you complete setting up the access environment, you can use the terminal program to test if you can properly connect to the application server.
You can refer to the following websites:

• Connection test guide
• Download terminal program (PuTTY)

4. Create PostgreSQL Server

After you complete testing the application server connection, create a PostgreSQL Server that will communicate with the application server. The PostgreSQL Server can be created from the Services > Database > Cloud DB for PostgreSQL menu of the NAVER Cloud Platform console without a separate service subscription request.
You can refer to the following guides:

• PostgreSQL Server creation quick guide
• PostgreSQL Server creation guide

Server redundancy configuration

To prevent data loss and minimize service impact if failures occur, you can set up server redundancy. Cloud DB for PostgreSQL creates a primary DB server and a secondary DB server. It provides a feature that automatically fails over to the secondary when the primary fails. Since the access is available with DNS, no additional application change is required.

To configure server redundancy, click and select Support high availability when creating the PostgreSQL Server.

Manage monitoring and event

For PostgreSQL Servers that have been created and are in operation, you can check monitoring for server performance and operating system status as well as events that occurred, as well as manage them for stable database service from the NAVER Cloud Platform console. You can also utilize NAVER Cloud Platform's Cloud Insight product for event and notification settings.

You can refer to the following guides:

• Monitoring guide
• Event confirmation guide
  • Event and notification settings guide

Manage management and administration permissions

You can create sub accounts in addition to the main user account, and set various management and administration permissions for Cloud DB for PostgreSQL. You can design permissions by utilizing the System Managed and User Created policies in NAVER Cloud Platform's Sub Account product.

You can refer to the following guides:

• Management and administration permissions management quick guide
• Management and administration permissions management guide

Store log and backup files

You can safely store the log files and backup files created from PostgreSQL Servers using NAVER Cloud Platform's Object Storage product.

You can refer to the following guides:

• Log and backup file storage guide

Set read load balancing

You can utilize NAVER Cloud Platform's Load Balancer product to configure read load balancing of PostgreSQL Servers.

You can refer to the following guides:

• Load Balancer quick guide
• Load Balancer Guide

5. Set ACG

Set the Access Control Group (ACG) for the PostgreSQL Server to allow the access of the application server to the created PostgreSQL Server.
You can refer to the following guides:

• ACG settings quick guide
• ACG settings guide

6. Test PostgreSQL Server connection

Use the PostgreSQL client and test to see if you can properly connect to the created PostgreSQL server.
You can refer to the following guides:

• Connection test guide