GET
/
cloud
/
v1
/
dbaas
/
postgres
/
clusters
/
{project_id}
/
{region_id}
/
{cluster_name}
Get PostgreSQL cluster
curl --request GET \
  --url https://api.gcore.com/cloud/v1/dbaas/postgres/clusters/{project_id}/{region_id}/{cluster_name} \
  --header 'Authorization: <api-key>'
{
  "cluster_name": "<string>",
  "created_at": "2023-11-07T05:31:56Z",
  "databases": [
    {
      "name": "mydatabase",
      "owner": "myuser",
      "size": 2048
    }
  ],
  "flavor": {
    "cpu": 1,
    "memory_gib": 1
  },
  "high_availability": {
    "replication_mode": "sync"
  },
  "network": {
    "acl": [
      "92.33.34.127"
    ],
    "connection_string": "postgresql://username:password@address.gcore.dev:5432/dbname",
    "host": "address.gcore.dev",
    "network_type": "public"
  },
  "pg_server_configuration": {
    "pg_conf": "\nlisten_addresses = 'localhost'\nport = 5432\nmax_connections = 100\nshared_buffers = 128MB\nlogging_collector = on",
    "pooler": null,
    "version": "<string>"
  },
  "status": "DELETING",
  "storage": {
    "size_gib": 100,
    "type": "ssd-hiiops"
  },
  "users": [
    {
      "is_secret_revealed": true,
      "name": "myuser",
      "role_attributes": [
        "INHERIT"
      ]
    }
  ]
}

Authorizations

​
Authorization
string
header
required

API key for authentication. Make sure to include the word apikey, followed by a single space and then your token. Example: apikey 1234$abcdef

Path Parameters

​
project_id
integer
required

Project ID

​
region_id
integer
required

Region ID

​
cluster_name
string
required

Cluster name

Response

Cluster details

​
cluster_name
string
required
Required string length: 1 - 50
​
created_at
string<date-time>
required
​
databases
DatabaseOverview · object[]
required
​
flavor
object
required

Instance RAM and CPU

​
high_availability
object | null
required
​
network
object
required
​
pg_server_configuration
object
required

Main PG configuration

​
status
enum<string>
required

Current cluster status

Available options:
DELETING,
FAILED,
PREPARING,
READY,
UNHEALTHY,
UNKNOWN,
UPDATING
​
storage
object
required

PG's storage configuration

​
users
PgUserOverview · object[]
required