Getting started

Available in VPC

Getting started with Cloud DB for PostgreSQL describes what you need to do to properly use Cloud DB for PostgreSQL after checking the Cloud DB for PostgreSQL user environment and supported specifications and fully understanding the Overall usage scenarios and Glossary. The following is the content dealt with in getting started with Cloud DB for PostgreSQL:

• How to create an application server (APP server) from the NAVER Cloud Platform console
• How to test application server connection
• How to create PostgreSQL Servers from the NAVER Cloud Platform console
• How to test PostgreSQL Server connection

If you completed the above, then you've completed the basic procedure for using Cloud DB for PostgreSQL. Afterward, you have the option of proceeding with the following tasks for more efficient server management and operation:

• Event and notification (alarm) settings using NAVER Cloud Platform's Cloud Insight
• Management of administration permissions using NAVER Cloud Platform's Sub Account
• Storage of log files and backup files using NAVER Cloud Platform's Object Storage
• Setting DB server read load balancing using NAVER Cloud Platform's Load Balancer

The above tasks can be done from Cloud Insight, Sub Account, Object Storage, Load Balancer after subscribing, rather than in Cloud DB for PostgreSQL. They are not explained in detail in this guide. For detailed instructions, see Cloud Insight user guide, Sub Account user guide, Object Storage user guide, and Load Balancer user guide.

Create application server

To create an application server from the NAVER Cloud Platform console, follow these steps:

1. Access the NAVER Cloud Platform console.
2. Click Region and Platform at the top right of the console interface.
3. Select your Region and VPC platform and click [Apply].
4. Click .
5. Services > Compute > Server at the top left of the console interface.
6. Click [Create server].
7. Select the server image and click [Next].
8. Enter the required information, and then click [Next].
9. If you do not have an existing authentication key, then create a new authentication key and click [Next].
10. If you do not have any ACG, create a new one.
11. After the final confirmation, click [Create server].

Set access environment

From the NAVER Cloud Platform console, you can set up the access environment for application servers by either setting up a public IP or an SSL VPN.

Set public IP

To set up a public IP, follow these steps:

1. From the NAVER Cloud Platform console, click Services > Compute > Server, in order.
2. Click Public IP.
3. Click [Request public IP].
4. Select the target server, enter a memo, and then click [Next].
5. Click [Create].

Check admin password

To get the admin (root) password required for accessing the application server after setting up the public IP, follow these steps:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Compute > Server, in order.
2. Click [Manage servers and change settings], and then click the Check admin password menu.
3. Enter the authentication key generated while creating the server.
4. Click [Check password].
5. Check the password.

Set SSL VPN

To allow external access on the PostgreSQL Server to be created by using SSL VPN, follow these steps:

1. Create SSL VPN
2. Add the VPN range to Subnet's Route Table
3. Set the PostgreSQL Server's ACG
4. Set the PostgreSQL Server's DB USER
5. Check the access information of the PostgreSQL Server

1. Create SSL VPN

To create an SSL VPN, follow these steps:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Security > SSL VPN.
2. Click the SSL VPN menu.
3. Click [Request for an SSL VPN].
4. When the Create SSL VPN popup window appears, enter the required information, and then click [Create].
5. After creation, check the SSL VPN IP address range from the delivered email or the SSL VPN page of the console.

2. Add the VPN range to Subnet's Route Table

To add a VPN range to the subnet's route table, follow these steps:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Networking > VPC.
2. Click Route Table.
3. Register the range of each SSL VPN to the route table of the subnet to be used.
4. Click and select the route table to set up, and then click [Set routes].
5. When the Set Route Table popup window appears, enter the required information.
   • Destination: SSL VPN's IP pool
   • Target Type: SSL VPN
   • Target name: the name of the created SSL VPN
6. Click [OK].

3. Set the PostgreSQL Server's ACG

To set up a PostgreSQL Server's ACG, follow these steps:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Storage > Cloud DB for PostgreSQL.
2. Click the DB Server menu.
3. From the details page of the server to be configured, click the button of the ACG.
4. Click the [Set ACG] button.
5. Add settings to allow SSL VPN access.
   • Access source: the IP address bandwidth of SSL VPN
   • Allowed port: DB Server port
6. Click the [Apply] button.

4. Set the PostgreSQL Server's DB USER

To set up PostgreSQL Server's DB USER, follow these steps:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Storage > Cloud DB for PostgreSQL.
2. Click the DB Server menu.
3. Click to select the server to configure, and then click Manage DB > Manage DB User, in order.
4. Add DB User to allow access from the VPN bandwidth.
5. Click the [Save] button.

5. Check the access information of the PostgreSQL Server

After completing the external access settings using SSL VPN, check the access information of the PostgreSQL Server. To check the information, follow these steps:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Storage > Cloud DB for PostgreSQL.
2. Click the DB Server menu.
3. Click to select the server you want to check, and check the necessary information from the View details page.
   • Private domain: it is a domain that can only be accessed from the NAVER Cloud Platform servers, and is used similarly as the DB server host name.
   • DB access port

Test application server connection

You can use the terminal program, PuTTY, to test if you can properly connect to the application server, follow these steps:

1. Run PuTTY.
2. Enter the IP address and port number acquired from the access environment settings for Host Name (or IP address) and Port.
   
3. Click [Open].
4. When the PuTTY Security Alert popup window appears, click [Accept].
   
5. When the cmd window for server access appears, enter the password you got from Get admin password.
   

Create PostgreSQL Server

Some of the services provided by NAVER Cloud Platform require you to go through the subscription procedure from the console before the start of actual usage. However, for Cloud DB for PostgreSQL, you can start using it upon creation of a PostgreSQL Server without a separate subscription step. To create an PostgreSQL Server from the NAVER Cloud Platform console, follow these steps:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Database > Cloud DB for PostgreSQL.
2. Click the DB Server menu.
3. Click [Create DB Server].
4. When the subscribe page appears, enter the required information and click [Next].
5. Click [Create].

Set ACG

To set up the Access Control Group (ACG) for a PostgreSQL Server from the NAVER Cloud Platform console, follow these steps:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Database > Cloud DB for PostgreSQL.
2. Click the ACG menu.
   
3. Click and select the ACG to set up, and then click [Set ACG].
   • Select the ACG of the PostgreSQL Server automatically created
4. Enter the ACG name of the application server in Access source.
5. Enter the port number in Allowed port.
6. Click the [Add] button.
7. Click the [Apply] button.

Test PostgreSQL Server connection

To test if you can connect properly to the created PostgreSQL Server by installing the PostgreSQL client:

1. Connect to pgAdmin.org.
2. Click the Download menu.
3. Download the version appropriate for your operating system and install it on your local PC.
4. Add the information of the PostgreSQL server you want to connect to.
5. Connect to the PostgreSQL server.