All URIs are relative to https://api.ionos.com/databases/postgresql
Method
HTTP request
Description
cluster_postgres_versions_get
cluster_postgres_versions_get(cluster_id)
List PostgreSQL versions
Retrieves a list of all PostgreSQL versions available for this cluster including the current version.
Examples
require'time'require'ionoscloud-dbaas-postgres'# setup authorizationIonoscloudDbaasPostgres.configure do|config|# Configure HTTP basic authorization: basicAuth config.username ='YOUR USERNAME' config.password ='YOUR PASSWORD'# Configure API key authorization: tokenAuth config.api_key['Authorization'] ='YOUR API KEY'# Uncomment the following line to set a prefix for the API key, e.g. 'Bearer' (defaults to nil)# config.api_key_prefix['Authorization'] = 'Bearer'endapi_instance =IonoscloudDbaasPostgres::ClustersApi.newcluster_id ='cluster_id_example'# String | The unique ID of the cluster.begin# List PostgreSQL versions result = api_instance.cluster_postgres_versions_get(cluster_id)p resultrescueIonoscloudDbaasPostgres::ApiError=> eputs"Error when calling ClustersApi->cluster_postgres_versions_get: #{e}"end
Using the cluster_postgres_versions_get_with_http_info variant
This returns an Array which contains the response data, status code and headers.
require'time'require'ionoscloud-dbaas-postgres'# setup authorizationIonoscloudDbaasPostgres.configure do|config|# Configure HTTP basic authorization: basicAuth config.username ='YOUR USERNAME' config.password ='YOUR PASSWORD'# Configure API key authorization: tokenAuth config.api_key['Authorization'] ='YOUR API KEY'# Uncomment the following line to set a prefix for the API key, e.g. 'Bearer' (defaults to nil)# config.api_key_prefix['Authorization'] = 'Bearer'endapi_instance =IonoscloudDbaasPostgres::ClustersApi.newcluster_id ='cluster_id_example'# String | The unique ID of the cluster.begin# Delete a cluster result = api_instance.clusters_delete(cluster_id)p resultrescueIonoscloudDbaasPostgres::ApiError=> eputs"Error when calling ClustersApi->clusters_delete: #{e}"end
Using the clusters_delete_with_http_info variant
This returns an Array which contains the response data, status code and headers.
You can retrieve a PostgreSQL cluster by using its ID. This value can be found in the response body when a PostgreSQL cluster is created or when you GET a list of PostgreSQL clusters.
Examples
require'time'require'ionoscloud-dbaas-postgres'# setup authorizationIonoscloudDbaasPostgres.configure do|config|# Configure HTTP basic authorization: basicAuth config.username ='YOUR USERNAME' config.password ='YOUR PASSWORD'# Configure API key authorization: tokenAuth config.api_key['Authorization'] ='YOUR API KEY'# Uncomment the following line to set a prefix for the API key, e.g. 'Bearer' (defaults to nil)# config.api_key_prefix['Authorization'] = 'Bearer'endapi_instance =IonoscloudDbaasPostgres::ClustersApi.newcluster_id ='cluster_id_example'# String | The unique ID of the cluster.begin# Fetch a cluster result = api_instance.clusters_find_by_id(cluster_id)p resultrescueIonoscloudDbaasPostgres::ApiError=> eputs"Error when calling ClustersApi->clusters_find_by_id: #{e}"end
Using the clusters_find_by_id_with_http_info variant
This returns an Array which contains the response data, status code and headers.
require'time'require'ionoscloud-dbaas-postgres'# setup authorizationIonoscloudDbaasPostgres.configure do|config|# Configure HTTP basic authorization: basicAuth config.username ='YOUR USERNAME' config.password ='YOUR PASSWORD'# Configure API key authorization: tokenAuth config.api_key['Authorization'] ='YOUR API KEY'# Uncomment the following line to set a prefix for the API key, e.g. 'Bearer' (defaults to nil)# config.api_key_prefix['Authorization'] = 'Bearer'endapi_instance =IonoscloudDbaasPostgres::ClustersApi.newopts = { limit: 100,# Integer | The maximum number of elements to return. Use together with 'offset' for pagination. offset: 200,# Integer | The first element to return. Use together with 'limit' for pagination. filter_name: 'filter_name_example' # String | Response filter to list only the PostgreSQL clusters that contain the specified name. The value is case insensitive and matched on the 'displayName' field.
}begin# List clusters result = api_instance.clusters_get(opts)p resultrescueIonoscloudDbaasPostgres::ApiError=> eputs"Error when calling ClustersApi->clusters_get: #{e}"end
Using the clusters_get_with_http_info variant
This returns an Array which contains the response data, status code and headers.
require'time'require'ionoscloud-dbaas-postgres'# setup authorizationIonoscloudDbaasPostgres.configure do|config|# Configure HTTP basic authorization: basicAuth config.username ='YOUR USERNAME' config.password ='YOUR PASSWORD'# Configure API key authorization: tokenAuth config.api_key['Authorization'] ='YOUR API KEY'# Uncomment the following line to set a prefix for the API key, e.g. 'Bearer' (defaults to nil)# config.api_key_prefix['Authorization'] = 'Bearer'endapi_instance =IonoscloudDbaasPostgres::ClustersApi.newcluster_id ='cluster_id_example'# String | The unique ID of the cluster.patch_cluster_request = IonoscloudDbaasPostgres::PatchClusterRequest.new # PatchClusterRequest | Part of the cluster which should be modified.
begin# Patch a cluster result = api_instance.clusters_patch(cluster_id, patch_cluster_request)p resultrescueIonoscloudDbaasPostgres::ApiError=> eputs"Error when calling ClustersApi->clusters_patch: #{e}"end
Using the clusters_patch_with_http_info variant
This returns an Array which contains the response data, status code and headers.
Creates a new PostgreSQL cluster. If the fromBackup field is populated, the new cluster will be created based on the given backup.
Examples
require'time'require'ionoscloud-dbaas-postgres'# setup authorizationIonoscloudDbaasPostgres.configure do|config|# Configure HTTP basic authorization: basicAuth config.username ='YOUR USERNAME' config.password ='YOUR PASSWORD'# Configure API key authorization: tokenAuth config.api_key['Authorization'] ='YOUR API KEY'# Uncomment the following line to set a prefix for the API key, e.g. 'Bearer' (defaults to nil)# config.api_key_prefix['Authorization'] = 'Bearer'endapi_instance =IonoscloudDbaasPostgres::ClustersApi.newcreate_cluster_request = IonoscloudDbaasPostgres::CreateClusterRequest.new # CreateClusterRequest | The cluster to be created.
begin# Create a cluster result = api_instance.clusters_post(create_cluster_request)p resultrescueIonoscloudDbaasPostgres::ApiError=> eputs"Error when calling ClustersApi->clusters_post: #{e}"end
Using the clusters_post_with_http_info variant
This returns an Array which contains the response data, status code and headers.
Retrieves a list of all available PostgreSQL versions.
Examples
require'time'require'ionoscloud-dbaas-postgres'# setup authorizationIonoscloudDbaasPostgres.configure do|config|# Configure HTTP basic authorization: basicAuth config.username ='YOUR USERNAME' config.password ='YOUR PASSWORD'# Configure API key authorization: tokenAuth config.api_key['Authorization'] ='YOUR API KEY'# Uncomment the following line to set a prefix for the API key, e.g. 'Bearer' (defaults to nil)# config.api_key_prefix['Authorization'] = 'Bearer'endapi_instance =IonoscloudDbaasPostgres::ClustersApi.newbegin# List PostgreSQL versions result = api_instance.postgres_versions_getp resultrescueIonoscloudDbaasPostgres::ApiError=> eputs"Error when calling ClustersApi->postgres_versions_get: #{e}"end
Using the postgres_versions_get_with_http_info variant
This returns an Array which contains the response data, status code and headers.
The maximum number of elements to return. Use together with 'offset' for pagination.
[optional][default to 100]
offset
Integer
The first element to return. Use together with 'limit' for pagination.
[optional][default to 0]
filter_name
String
Response filter to list only the PostgreSQL clusters that contain the specified name. The value is case insensitive and matched on the 'displayName' field.