GET
/
project
/
{project_id}
/
location
/
{location}
/
postgres
/
id
/
{postgres_database_id}
curl --request GET \
  --url https://api.ubicloud.com/project/{project_id}/location/{location}/postgres/id/{postgres_database_id} \
  --header 'Authorization: Bearer <token>'
{
  "flavor": "<string>",
  "ha_type": "<string>",
  "id": "pgn30gjk1d1e2jj34v9x0dq4rp",
  "location": "<string>",
  "name": "<string>",
  "state": "<string>",
  "storage_size_gib": 123,
  "version": "<string>",
  "vm_size": "<string>",
  "ca_certificates": "<string>",
  "connection_string": "<string>",
  "earliest_restore_time": "<string>",
  "firewall_rules": [
    {
      "cidr": "<string>",
      "id": "pfmjgkgbktw62k53005jpx8tt7"
    }
  ],
  "latest_restore_time": "<string>",
  "primary": true
}

Authorizations

​
Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

​
project_id
string
required

ID of the project

Example:

"pjkkmx0f2vke4h36nk9cm8v8q0"

​
location
string
required

The Ubicloud location/region

Example:

"eu-central-h1"

​
postgres_database_id
string
required

Postgres database ID

Example:

"pgn30gjk1d1e2jj34v9x0dq4rp"

Response

200
application/json
A Postgres Database
​
flavor
string
required

Kind of Postgres database

​
ha_type
string
required

High availability type

​
id
string
required

ID of the Postgres database

Example:

"pgn30gjk1d1e2jj34v9x0dq4rp"

​
location
string
required

Location of the Postgres database

​
name
string
required

Name of the Postgres database

​
state
string
required

State of the Postgres database

​
storage_size_gib
integer
required

Storage size in GiB

​
version
string
required

Postgres version

​
vm_size
string
required

Size of the underlying VM

​
connection_string
string | null
required

Connection string to the Postgres database

​
earliest_restore_time
string | null
required

Earliest restore time (if primary)

​
firewall_rules
object[]
required

List of Postgres firewall rules

​
latest_restore_time
string
required

Latest restore time (if primary)"

​
primary
boolean
required

Is the database primary

​
ca_certificates
string | null

CA certificates of the root CA used to issue postgres server certificates

Failover a specific Postgres Database with IDDelete a specific Postgres Database with ID