Configuration avancée via API (EN)
Advanced configuration for Public Cloud Databases engines via API
Last updated 1st April, 2022
Objective
Public cloud database engines are managed services, which means that they are not fully configurable. For example, it is not possible to modify pg_hba.conf. However, it is possible to modify some parameters via the API.
These actions are not available from the OVHcloud Control Panel
Requirements
- A Public Cloud project in your OVHcloud account
- A database running on your OVHcloud Public Cloud Databases (this guide can help you to meet this requirement)
If you have never used the OVHcloud API before, then follow this tutorial: First Steps with the OVHcloud APIs.
Here, we consider that your are logged on the relevant API (Europe: https://api.ovh.com, Canada/Asia: https://ca.api.ovh.com).
Instructions
Get your service and cluster IDs
You first need to identify the service and the cluster you want to apply the changes to.
Get the desired service ID
Execute the following API call:
From the resulting list, select and copy the service identifier corresponding to the desired service, also known as serviceName.
Get the desired cluster ID
Open the following API call, paste your service ID into the serviceName input field and click Execute:
From the resulting list, select and copy the cluster ID, also known as clusterId.
Get the existing Advanced Configuration
Open the following API call and paste the corresponding inputs (serviceName, clusterId) and click Execute:
Advanced Configuration parameters list
Open the following API call and paste the corresponding inputs (serviceName, clusterId) and click Execute:
Change Advanced Configuration
Please note that changes to the advanced settings apply at the cluster level and therefore to all the databases in the cluster.
Open the following API call and paste the corresponding inputs (serviceName, clusterId)
Now, according the parameters you chose, set the different values into the string arrays, such as in the example below:
When ready, click Execute to update the parameters.
Checking
You can check the changes in different ways such as:
API call
pgAdmin
Follow this guide to learn more about pgAdmin
We want your feedback!
We would love to help answer questions and appreciate any feedback you may have.
Are you on Discord? Connect to our channel at https://discord.gg/PwPqWUpN8G and interact directly with the team that builds our databases service!
Cette documentation vous a-t-elle été utile ?
N’hésitez pas à nous proposer des suggestions d’amélioration afin de faire évoluer cette documentation.
Images, contenu, structure… N’hésitez pas à nous dire pourquoi afin de la faire évoluer ensemble !
Vos demandes d’assistance ne seront pas traitées par ce formulaire. Pour cela, utilisez le formulaire "Créer un ticket" .
Merci beaucoup pour votre aide ! Vos retours seront étudiés au plus vite par nos équipes..