Documentation | Managed PostgreSQL › Status › Activate Or Deactivate Dbaas Service For A Specified Project

Managed PostgreSQL

managed_postgresql

Postgres

managed_postgresql.postgres

Methods

Check Quota PostgreSQL Cluster Creation -> { baremetal_basic_count_limit, baremetal_basic_count_requested, baremetal_basic_count_usage, 126 more... }

post/v1/dbaas/postgres/check_limit/{project_id}/{region_id}

Check quota PostgreSQL cluster creation

Get Available Postgtre Sql Configurations For A Region -> { flavors, storage_classes, versions }

get/v1/dbaas/postgres/configuration/{project_id}/{region_id}

Get available PostgtreSQL configurations for a region.

Validate User S Custom PostgreSQL Configuration File -> { errors, is_valid }

post/v1/dbaas/postgres/validate_pg_conf/{project_id}/{region_id}

Validate user's custom PostgreSQL configuration file.

Domain types

PgClusterCreate = { cluster_name, flavor, high_availability, 5 more... }

Managed PostgreSQL Postgres

Clusters

managed_postgresql.postgres.clusters

Methods

Create Dbaas PostgreSQL Cluster -> { tasks }

post/v1/dbaas/postgres/clusters/{project_id}/{region_id}

Create DBAAS PostgreSQL cluster.

Delete Dbaas PostgreSQL Cluster -> { tasks }

delete/v1/dbaas/postgres/clusters/{project_id}/{region_id}/{cluster_name}

Delete DBAAS PostgreSQL cluster.

List Dbaas PostgreSQL Clusters -> OffsetPage<{ cluster_name, created_at, status, 1 more... }>

get/v1/dbaas/postgres/clusters/{project_id}/{region_id}

List DBAAS PostgreSQL Clusters.

Get Dbaas Postgres Cluster -> { cluster_name, created_at, databases, 7 more... }

get/v1/dbaas/postgres/clusters/{project_id}/{region_id}/{cluster_name}

Get DBAAS Postgres Cluster.

Patch Dbaas Postgres Cluster -> { tasks }

patch/v1/dbaas/postgres/clusters/{project_id}/{region_id}/{cluster_name}

Patch DBAAS Postgres Cluster.

Managed PostgreSQL Postgres Clusters

Users

managed_postgresql.postgres.clusters.users

Managed PostgreSQL Postgres Clusters Users

Credentials

managed_postgresql.postgres.clusters.users.credentials

Methods

Recreate Credentials For Given User In Pg Cluster ->

UserCredentials

post/v1/dbaas/postgres/clusters/{project_id}/{region_id}/{cluster_name}/users/{username}/credentials

Recreate credentials for given user in PG Cluster.

Get Credentials For Given User In Pg Cluster Once ->

UserCredentials

get/v1/dbaas/postgres/clusters/{project_id}/{region_id}/{cluster_name}/users/{username}/credentials

Get credentials for given user in PG Cluster once.

Domain types

UserCredentials = { password, username }

Managed PostgreSQL

Status

managed_postgresql.status

Methods

Get Dbaas Service Status For A Specified Project It May Be Initialized Or Not ->

DbaasStatus

get/v1/dbaas/status/{project_id}/{region_id}

Get DBAAS service status for a specified project. It may be initialized or not

Activate Or Deactivate Dbaas Service For A Specified Project ->

DbaasStatus

put/v1/dbaas/status/{project_id}/{region_id}

Activate or deactivate DBAAS Service for a specified project.

Parameters

project_id: number

region_id: number

Response fields

DbaasStatus

Request example

curl https://api.gcore.com/cloud/v1/dbaas/status/$PROJECT_ID/$REGION_ID \
    -X PUT \
    -H 'Content-Type: application/json' \
    -H "APIKey: $CLOUD_API_API_KEY" \
    -d '{
      "is_initialized": true
    }'

200Example

{
  "is_initialized": true
}

Domain types

DbaasStatus = { is_initialized }