Troubleshoot common issues

Available in VPC

In using Cloud DB for PostgreSQL, you may encounter the following problems. View the causes and solutions of problems and take proper action:

PostgreSQL Server connection error

Error occurs when connecting to PostgreSQL Server.

Cause

You need to create an application server that will communicate with PostgreSQL Server to access PostgreSQL Server. Otherwise, Cloud DB for PostgreSQL of NAVER Cloud Platform cannot be used normally.

Solution

PostgreSQL Server created from Cloud DB for PostgreSQL is currently only accessible within NAVER Cloud Platform, so the applications server must also be created inside NAVER Cloud Platform. For the overall flow of server creation, check scenario and see Start guide by environment for each platform:

• Overall usage scenario
• Getting started with Cloud DB for PostgreSQL

DB creation error

Error occurs when creating DB.

Cause

Error may occur if exceeding the creation limit of servers.

Solution

Check the creation limit of servers and the number of servers created.
If you need additional servers, write customer inquiry with the purpose of the number of servers and purpose of using service.

Notifications on exceeding PostgreSQL Server threshold

Unable to receive an event notification on exceeding PostgreSQL Server threshold.

Cause

Cloud DB for PostgreSQL provides monitoring service and event collection service for the performance and operating system of the server. You can directly set thresholds by integrating with Cloud Insight. If there's an error between Cloud Insight integration and custom config value, notification may not be sent normally.

Solution

The monitoring results and event collection results of Cloud DB for PostgreSQL can be integrated with Cloud Insight to get notification via email or SMS. For more information on how to use, see Monitoring, and Event.

Assign Superuser permission

Cannot allocate Superuser permission to specific User account of DB.
I want to grant Superuser permission to DB User.

Cause

Cloud DB for PostgreSQL restricts Superuser permission due to stability in backup, redundancy and monitoring.

Solution

It is not allowed to grant Superuser permissions due to Superuser permissions restriction.

PostGIS installation error

Error occurs when installing PostGIS.

Cause

Currently, Cloud DB for PostgreSQL does not support PostGIS.

Solution

PostGIS is not currently available and cannot be installed. For available Extension, see list of supported extensions.
We are planning for future support but there is no schedule fixed. This will be informed via portal announcement or through guide.

Limits in the number of Max Connection

Cannot limit the number of Max Connection.

Cause

You can set in the console.

Solution

To limit the number of Max Connection, follow these steps:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Database > Cloud DB for PostgreSQL > DB Server.
2. Select DB and click Manage DB > View DB Service details.
3. Click [Manage DB Config].
4. Select max_connections in Config Name and enter the value to change in Config Value.
5. Click add to add settings.
6. Click save.

For more information, see manage DB Config. See PostgreSQL official documentation to check if there are any side effects.

Error when executing Create Cast function

Error occurs when executing the Create Cast function.

Cause

As owner of pg_type is postgres and superuser, it is not available to execute Create Cast in User account.

Solution

Instead of using Cast function, convert the string '1' to numeric data type.

SELECT '1'::numeric;