Postgres Database
List Postgres Databases in a specific location of a project
API Documentation
Project
Firewall
- GETReturn the list of firewalls in the project
- POSTCreate a new firewall
- GETGet details of a specific firewall
- DELDelete a specific firewall
- GETReturn the list of firewalls in the project and location
- GETGet details of a specific firewall
- POSTCreate a new firewall
- DELDelete a specific firewall
- POSTAttach a subnet to firewall
- POSTDetach a subnet from firewall
Firewall Rule
Load Balancer
- GETList Load Balancers in a specific project
- GETGet details of a specific Load Balancer
- POSTCreate a new Load Balancer in a project
- GETList Load Balancers in a specific location of a project
- GETGet details of a specific Load Balancer in a location
- POSTCreate a new Load Balancer in a specific location of a project
- DELDelete a specific Load Balancer
- PATCHUpdate a Load Balancer in a specific location of a project
- POSTAttach a VM to a Load Balancer in a specific location of a project
- POSTDetach a VM from a Load Balancer in a specific location of a project
Postgres Database
- GETList Postgres Databases in a specific location of a project
- GETGet details of a specific Postgres database in a location
- POSTCreate a new Postgres Database in a specific location of a project
- DELDelete a specific Postgres Database
- PATCHUpdate a Postgres Database in a specific location of a project
- GETDownload CA certificates for a specific Postgres Database in a location with name
- POSTReset superuser password of the Postgres database
- POSTRestart a specific Postgres Database
- POSTRestore a new Postgres database in a specific location of a project
- POSTSet maintenance window for the Postgres database
- GETList visible Postgres Databases
Postgres Metric Destination
Postgres Firewall Rule
Private Subnet
- GETList Private Subnets in a specific location of a project
- GETGet details of a specific Private Subnet in a location
- POSTCreate a new Private Subnet in a specific location of a project
- DELDelete a specific Private Subnet
- POSTConnect private subnet to another private subnet
- POSTDisconnect private subnet from another private subnet
- GETList visible Private Subnets
Virtual Machine
Postgres Database
List Postgres Databases in a specific location of a project
GET
/
project
/
{project_id}
/
location
/
{location}
/
postgres
Copy
curl --request GET \
--url https://api.ubicloud.com/project/{project_id}/location/{location}/postgres \
--header 'Authorization: Bearer <token>'
Copy
{
"count": 123,
"items": [
{
"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>",
"maintenance_window_start_at": 123
}
]
}
Authorizations
Bearer authentication header of the form Bearer <token>
, where <token>
is your auth token.
Path Parameters
ID of the project
Example:
"pjkkmx0f2vke4h36nk9cm8v8q0"
The Ubicloud location/region
Example:
"eu-central-h1"
Query Parameters
Pagination - Start after
Pagination - Page size
Pagination - Order column
Response
200
application/json
A list of Postgres Databases
Kind of Postgres database
High availability type
ID of the Postgres database
Example:
"pgn30gjk1d1e2jj34v9x0dq4rp"
Location of the Postgres database
Name of the Postgres database
State of the Postgres database
Storage size in GiB
Postgres version
Size of the underlying VM
Maintenance window start time
CA certificates of the root CA used to issue postgres server certificates
Copy
curl --request GET \
--url https://api.ubicloud.com/project/{project_id}/location/{location}/postgres \
--header 'Authorization: Bearer <token>'
Copy
{
"count": 123,
"items": [
{
"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>",
"maintenance_window_start_at": 123
}
]
}