Cloud DB for PostgreSQL quickstart

Available in VPC

Cloud DB for PostgreSQL on the NAVER Cloud Platform enables you to quickly and easily build PostgreSQL servers in a cloud environment and operate and manage them to provide stable database services. The overall workflow for using Cloud DB for PostgreSQL on the NAVER Cloud Platform is as follows:

Each step is described as follows:

1. Create an application server
2. Configure the connection environment
3. Test the application server connection
4. Create a PostgreSQL server
5. Configure the ACG
6. Test access to the PostgreSQL server

1. Create an application server

First, create an application server (APP server) that will communicate with the PostgreSQL server you create in Cloud DB for PostgreSQL in the NAVER Cloud Platform console. Because Cloud DB for PostgreSQL is currently accessible only within the NAVER Cloud Platform, the application server must also be located within the NAVER Cloud Platform. In the NAVER Cloud Platform console, you can create an application server (APP server) in > Services > Compute > Server menu.
For detailed instructions, see:

• Quick guide to creating an application server
• Guide to creating an application server

2. Configure the connection environment

After you complete the application server creation, configure the connection environment so you can access the application server. There are two ways to configure the connection environment:

• Configure access to the private domain using a public IP on the NAVER Cloud Platform
• Configure external access using the SSL VPN on the NAVER Cloud Platform

When you configure access using a public IP, check the administrator (root) password required to access the server by using the administrator password check feature. When you configure access using SSL VPN, you can access the DB server by installing an SSL VPN client on your personal PC. Using SSL VPN is more secure when the server is used for administrative purposes.
For detailed instructions, see:

• Quick guide to configuring a public IP or SSL VPN
• Guide to configuring a public IP
• Guide to configuring SSL VPN

3. Test the application server connection

After you complete the connection environment configuration, test whether you can successfully connect to the application server by using a terminal program.
You can see the following guides:

• Guide to connection testing
• Download the PuTTY terminal program

4. Create a PostgreSQL server

After you complete the application server connection test, create an PostgreSQL server that will communicate with the application server. You can create a PostgreSQL server directly from > Services > Database > Cloud DB for PostgreSQL in the NAVER Cloud Platform console without submitting a separate service request.
For detailed instructions, see:

• Quick guide to creating a PostgreSQL server
• Guide to creating a PostgreSQL server

Server redundancy configuration

You can configure server redundancy to prevent data loss and minimize service impact in the event of a failure. Cloud DB for PostgreSQL creates a primary DB server and a secondary DB server and provides automatic failover to the secondary server if the primary server fails. Because access is available through DNS, no additional application changes are required.

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

Monitoring and event management

You can monitor server performance and operating system status and review events for running PostgreSQL servers from the NAVER Cloud Platform console to manage database services in a stable manner. You can also configure events and notifications (alarms) by using Cloud Insight on the NAVER Cloud Platform.

You can refer to the following guide(s):

• Guide to using monitoring
• Guide to checking events
  • Guide to configuring events and notifications

Administrative and operational permission management

In addition to the main account, you can create sub accounts to configure various management and operation permissions for Cloud DB for PostgreSQL. You can design permissions by using system-managed and user-created policies in Sub Account on the NAVER Cloud Platform.

For detailed instructions, see:

• Quick guide on administrative and operational permissions management
• Guide on managing administrative and operational permissions

Log and backup file storage

You can securely store log files or backup files generated on the PostgreSQL server by using Object Storage on the NAVER Cloud Platform.

For detailed instructions, see:

• Log and backup file storage guide

Configure read load balancing

You can configure read load balancing for the PostgreSQL server by using the Load Balancer on the NAVER Cloud Platform.

For detailed instructions, see:

• Quick guide to Load Balancer
• Load Balancer user guide

5. Configure the ACG

Configure the Access Control Group (ACG) of the PostgreSQL server so that the application server can access the PostgreSQL server.
For detailed instructions, see:

• Quick guide to configuring the ACG
• Guide to configuring the ACG

6. Test access to the PostgreSQL server

Test whether you can successfully connect to the created PostgreSQL server by using an PostgreSQL client.
For detailed instructions, see:

• Guide to connection testing