Cloud DB for PostgreSQL (VPC) overview

Prev Next

Available in VPC

You can easily build and automatically manage PostgreSQL databases with Cloud DB for PostgreSQL. It is a fully managed cloud database service that operates stably through NAVER's optimization settings, and it automatically recovers in case of failure occurrence. Cloud DB for PostgreSQL provides APIs for database management features in RESTful form.

Common Cloud DB for PostgreSQL settings

The following describes commonly used request and response formats in Cloud DB for PostgreSQL APIs.

Request

The following describes the common request format.

API URL

The request API URL is as follows:

https://ncloud.apigw.ntruss.com/vpostgresql/v2

Request headers

The following describes the request headers.

Field Required Description
x-ncp-apigw-timestamp Required This is the number of milliseconds that have elapsed since January 1, 1970 00:00:00 UTC.
  • Request is considered invalid if the timestamp differs from the current time by more than 5 minutes.
    		•
    x-ncp-iam-access-key Required Access key issued on NAVER Cloud Platform
  • Issue and check access key: See Create authentication key.
  • Issue and check access key for sub account: See Create sub account.
    		•
    x-ncp-apigw-signature-v2 Required Base64-encoded signature that encrypts the request information with a secret key that maps to the access key issued on NAVER Cloud Platform, using the HMAC encryption algorithm (HmacSHA256)
  • Issue and check secret key: See Create authentication key.
  • Create signature: See Create signature.
    		•

    Response

    The following describes the common response format.

    Response status codes

    Cloud DB for PostgreSQL APIs use NAVER Cloud Platform's common response status codes. For response status codes common to NAVER Cloud Platform, see Ncloud API response status codes.

    Cloud DB for PostgreSQL API

    The following describes the APIs provided by the Cloud DB for PostgreSQL API service.

    API Description
    addCloudPostgresqlDatabaseList Add a Cloud DB for PostgreSQL database.
    addCloudPostgresqlUserList Add a Cloud DB for PostgreSQL DB user.
    changeCloudPostgresqlUserList Cloud DB for PostgreSQL DB user information
    createCloudPostgresqlInstance Create a Cloud DB for PostgreSQL instance.
    createCloudPostgresqlReadReplicaInstance Create a Cloud DB for PostgreSQL read replica server instance.
    deleteCloudPostgresqlDatabaseList Delete a Cloud DB for PostgreSQL database.
    deleteCloudPostgresqlInstance Delete a Cloud DB for PostgreSQL instance.
    deleteCloudPostgresqlReadReplicaInstance Delete a Cloud DB for PostgreSQL read replica server instance.
    deleteCloudPostgresqlUserList Delete a Cloud DB for PostgreSQL DB user.
    exportBackupToObjectStorage Send Cloud DB for PostgreSQL backup files to Object Storage.
    exportDbServerLogToObjectStorage Send Cloud DB for PostgreSQL database server log files to Object Storage.
    getCloudPostgresqlBackupDetailList Get Cloud DB for PostgreSQL backup details list.
    getCloudPostgresqlBackupList Get Cloud DB for PostgreSQL backup list.
    getCloudPostgresqlBucketList Get the list of Object Storage buckets available to use in Cloud DB for PostgreSQL.
    getCloudPostgresqlDatabaseList Get Cloud DB for PostgreSQL database list.
    getCloudPostgresqlImageProductList Get Cloud DB for PostgreSQL product code list.
    getCloudPostgresqlInstanceDetail Get Cloud DB for PostgreSQL instance details.
    getCloudPostgresqlInstanceList Get Cloud DB for PostgreSQL instance list.
    getCloudPostgresqlProductList Get the list of Cloud DB for PostgreSQL server specification codes.
    getCloudPostgresqlTargetSubnetList Get the list of available subnets in Cloud DB for PostgreSQL.
    getCloudPostgresqlTargetVpcList Get the list of available VPCs in Cloud DB for PostgreSQL.
    getCloudPostgresqlUserList Get Cloud DB for PostgreSQL DB user list.
    getDbServerLogList Get Cloud DB for PostgreSQL database server log list.
    rebootCloudPostgresqlServerInstance Restart a Cloud DB for PostgreSQL server instance.

    Cloud DB for PostgreSQL related resources

    NAVER Cloud Platform provides a variety of related resources to help users better understand Cloud DB for PostgreSQL APIs.