PostgreSQL

Create a Postgre SQL instance

This method allows to create a postgre SQL instance.

You will have to know at the minimum :

• the area of the region where you want to host your cluster (area attribute). Areas can be available in List Regions method.
• name of postgre SQL cluster (name attribute). The name can contain any lowercase characters or numbers (5-60). It must not be the keyword 'cluster'.
• Size of nodes in the postgre SQL cluster (nodeSizing attribute). Ex: 2cpu2gb
• storage needed on each data node of the postgre SQL cluster (diskSize attribute). The possible values are at least 40 and maximum 1024 (representing GB).
• how to connect to the instance (admPassword attribute). The password must be At least one lowercase, one uppercase, one digit, one special character, minimum length must be 12.
• version of the postgre SQL cluster (postgreVersion attribute). Example: 13
• On which service the postgre SQL instance belongs to (serviceId attribute).
• network ID of the cluster (networkId attribute).
• Topology of the postgre SQL cluster (topology attribute). Either standalone / HA
• trigram of the postgre SQL cluster (trigram attribute).
• Allowed replication Lag of the postgre SQL (allowedReplicationLag attribute). The minimum size is 1 MB and maximum is 10240 MB

HA topology extra fields: These fields are required for HA clusters:

• prefix of the node names for postgre cluster (nodePrefix attribute). The prefix should be from 5 to 12 characters and can contain any uppercase character.
• Availability zone of the postgre cluster (az attribute).
• Trigram of the postgre cluster (trigram attribute).
• TLS enabled boolean for the postgre cluster (tls attribute).

This method is asynchronous (status code 202) and you'll have to wait for async action to be completed by checking its status.

POST /postgresql
{
  "serviceId" : 123,
  "nodeSizing" : "2cpu4gb",
  "networkId" : 132,
  "area" : "EB-QA",
  "diskSize" : 40,
  "admPassword" : "Test123@2022",
  "postgreVersion" : "13",
  "allowedReplicationLag" : 10,
  "az" : "az",
  "topology" : "STANDALONE",
  "trigram" : "tri",
  "tls" : true,
  "name" : "NEWPOSTGRE01"
}

POSThttps://api.cegedim.cloud/itcare/databases/postgresql

Body

application/vnd.cegedim-it.v1+json

one of

HaPostgreCreationRequestV1 (object)StandalonePostgreCreationRequestV1 (object)

Response

200400

OK

Body

application/vnd.cegedim-it.v1+json

processstring

Code of action performed

statusenum

Status label of action

SUCCESS,IN_PROGRESS,ERROR

messagestring

Human readable message of status

idinteger (int32)

internalIdinteger (int64)

resourceNamestring

resourceTypestring

familystring

lastUpdatedAtstring (date-time)

Request

JavaScriptCurlPython

const response = await fetch('https://api.cegedim.cloud/itcare/databases/postgresql', {
    method: 'POST',
    headers: {
      "Content-Type": "application/vnd.cegedim-it.v1+json"
    },
    body: JSON.stringify({
      "admPassword": "text",
      "area": "text",
      "diskSize": 0,
      "networkId": 0,
      "nodeSizing": "text",
      "platform": "text",
      "postgreVersion": "text",
      "region": "text",
      "serviceId": 0,
      "topology": "STANDALONE"
    }),
});
const data = await response.json();

Response

200

{
  "process": "text",
  "status": "SUCCESS,IN_PROGRESS,ERROR",
  "message": "text",
  "id": 0,
  "internalId": 0,
  "resourceName": "text",
  "resourceType": "text",
  "family": "text",
  "lastUpdatedAt": "2025-01-02T14:31:07.794Z"
}

Get a Postgre SQL Instance available in the cloud

GEThttps://api.cegedim.cloud/itcare/databases/postgresql/{id}

Path parameters

id*integer (int64)

id, example: 500061854

Response

200400

OK

Body

application/vnd.cegedim-it.v1+json

idinteger (int64)

namestring

typestring

internalTypestring

statusstring

categorystring

technologystring

familystring

labelstring

commentstring

productCodestring

productNamestring

productVersionstring

cloudIdinteger (int64)

cloudNamestring

serviceIdinteger (int64)

serviceNamestring

serviceKeystring

environmentstring

endOfSupportAtstring (date-time)

supportPhasestring

creationUserstring

creationTimestring

releasedAtstring (date-time)

endOfSalesAtstring (date-time)

extendedSupportAtstring (date-time)

monitoringEnabledboolean

monitoringAlertingboolean

monitoringOnCallEnabledboolean

monitoringRequestedboolean

replicationStatusboolean

backupStatusboolean

patchPartyPatchPartyV1 (object)

Representation of a resource patch party

metrologyUrlstring

pathstring

resourceTypestring

internalResourceIdinteger (int64)

backupPolicyDetailsBackupPolicyDetailsV1 (object)

areastring

Area. Refer to an Area of a Region, that is a low-latency network area, available in List Regions method. If absent, default Area of Region will be used.

instanceCount*integer (int32)

Number of instances to create in Postgre cluster

nodeSizing*string

Node sizing for Postgre cluster

storage*integer (int32)

The storage needed on each data node of the Postgre cluster

networkId*integer (int32)

Network Id

versionstring

ipAddressstring

IP Address of the resource

allowedReplicationLaginteger (int32)

Allowed replication Lag

tlsEnabledboolean

topologystring

trigramstring

allowMonitoringDisplayboolean

cpuinteger (int64)

raminteger (int64)

urlstring

nodeCountinteger (int64)

Request

JavaScriptCurlPython

const response = await fetch('https://api.cegedim.cloud/itcare/databases/postgresql/{id}', {
    method: 'GET',
    headers: {},
});
const data = await response.json();

Response

200

{
  "id": 0,
  "name": "text",
  "type": "text",
  "internalType": "text",
  "status": "text",
  "category": "text",
  "technology": "text",
  "family": "text",
  "label": "text",
  "comment": "text",
  "productCode": "text",
  "productName": "text",
  "productVersion": "text",
  "cloudId": 0,
  "cloudName": "text",
  "serviceId": 0,
  "serviceName": "text",
  "serviceKey": "text",
  "environment": "text",
  "endOfSupportAt": "2025-01-02T14:31:07.794Z",
  "supportPhase": "text",
  "creationUser": "text",
  "creationTime": "text",
  "releasedAt": "2025-01-02T14:31:07.794Z",
  "endOfSalesAt": "2025-01-02T14:31:07.794Z",
  "extendedSupportAt": "2025-01-02T14:31:07.794Z",
  "monitoringEnabled": false,
  "monitoringAlerting": false,
  "monitoringOnCallEnabled": false,
  "monitoringRequested": false,
  "replicationStatus": false,
  "backupStatus": false,
  "patchParty": {
    "excluded": false,
    "exclusionReason": "text",
    "patchGroup": "text",
    "patchDate": "2025-01-02T14:31:07.794Z",
    "patchTag": "text",
    "name": "text",
    "id": 0,
    "excludedBy": "text",
    "exclusionDate": "2025-01-02T14:31:07.794Z"
  },
  "metrologyUrl": "text",
  "path": "text",
  "resourceType": "text",
  "internalResourceId": 0,
  "backupPolicyDetails": {
    "backups": [
      {
        "id": 0,
        "type": "text",
        "backupSize": 0,
        "backupLastDate": "2025-01-02T14:31:07.794Z"
      }
    ],
    "policies": [
      {
        "name": "text",
        "label": "text",
        "scope": "text",
        "type": "text",
        "replication": false,
        "durationInHours": 0,
        "startTime": "text",
        "timezone": "text",
        "policyId": "text",
        "backupLastDate": "2025-01-02T14:31:07.794Z",
        "backupSize": 0
      }
    ]
  },
  "area": "text",
  "instanceCount": 0,
  "nodeSizing": "text",
  "storage": 0,
  "networkId": 0,
  "version": "text",
  "ipAddress": "text",
  "allowedReplicationLag": 0,
  "tlsEnabled": false,
  "topology": "text",
  "trigram": "text",
  "allowMonitoringDisplay": false,
  "cpu": 0,
  "ram": 0,
  "url": "text",
  "nodeCount": 0
}

Delete an existing PostgreSQL instance

This method allows to delete a postgre SQL instance.

This method is asynchronous (status code 202) and you'll have to wait for async action to be completed by checking its status.

DELETE /postgresql/123

DELETEhttps://api.cegedim.cloud/itcare/databases/postgresql/{id}

Path parameters

id*integer (int64)

id, example: 123

Response

200400

OK

Body

application/vnd.cegedim-it.v1+json

processstring

Code of action performed

statusenum

Status label of action

SUCCESS,IN_PROGRESS,ERROR

messagestring

Human readable message of status

idinteger (int32)

internalIdinteger (int64)

resourceNamestring

resourceTypestring

familystring

lastUpdatedAtstring (date-time)

Request

JavaScriptCurlPython

const response = await fetch('https://api.cegedim.cloud/itcare/databases/postgresql/{id}', {
    method: 'DELETE',
    headers: {},
});
const data = await response.json();

Response

200

{
  "process": "text",
  "status": "SUCCESS,IN_PROGRESS,ERROR",
  "message": "text",
  "id": 0,
  "internalId": 0,
  "resourceName": "text",
  "resourceType": "text",
  "family": "text",
  "lastUpdatedAt": "2025-01-02T14:31:07.794Z"
}

Performs update state actions to an existing Postgre SQL instance

This method allows to update a PostgreSQL instance.

Structure of payload is generic and describes :

• operation you want to be performed
• options data relative to the operation performed - see details - optional.

Below are different operations currently implemented.

Start PostgreSQL instance

Use the start operation to start a PostgreSQL instance.

Starts PostgreSQL instance.

This method is asynchronous (status code 202).

Example :

PATCH /postgresql/1234
{
    "operation": "start"
}

Stop PostgreSQL instance

Use the stop operation to stop the nodes of the PostgreSQL instance and the instance itself.

This operation cannot be undone afterwards.

This method is asynchronous (status code 202).

PATCH /postgresql/1234
{
	"operation":"stop"
}

Resize PostgreSQL instance

Use the resize operation to resize the nodes of the PostgreSQL instance and the instance itself.

This operation cannot be undone afterwards.

This method is asynchronous (status code 202).

PATCH /postgresql/1234
{
	"operation":"resize",
	"options": {
        "sizing": "2cpu4gb"
    }
}

Restore PostgreSQL instance

Use the restore operation to restore a PostgreSQL instance to another PostgreSQL instance with the same farm version.

• the source instance must be backed up.
• the source instance and destination farm must be ACTIVE
• the timestamp must be between now and now - 14 days for production service and now - 7 days for non production service→ raise exception
• timestamp should respect the format described in Json Schema (date-time) The following is correct : 2022-11-02T09:32:02.000+00:00

The available stop options are BEFORE and AFTER.

This method is asynchronous (status code 202).

PATCH /postgresql/5678
{
	"operation": "restore",
	"options": {
	    "sourceId": 1234,
	    "stop": "BEFORE",
	    "timestamp": "2022-11-02T09:32:02.000+00:00"
	}
}

Convert from Standalone to HA PostgreSQL instance

Use the enable_ha operation to convert a PostgreSQL instance from Standalone to HA mode.

• the replicationLag must be between 1 and 500.
• The standalone instance must have a version greater or egal to 12.
• changeReference is optional

This method is asynchronous (status code 202).

PATCH /postgresql/5678
{
	"operation": "enable_ha",
	"options": {
	    "replicationLag": 50,
	    "changeReference": "000"
	}
}

Update Monitoring

Use the update_monitoring operation to update the monitoring state of the cluster.

Use the state option to turn on/off monitoring. Use the on_call option to turn on/off 24/7 monitoring.

This method is asynchronous (status code 202).

PATCH /postgresql/1234
{
  "operation": "update_monitoring",
  "options": {
       "state": true,
       "on_call": true
 }
}

Update Patch Party

Use the update_patch_party operation to update the patch party scheduled plan of the cluster.

• Use the excluded option to turn on/off patch party.
• Use the patchGroup option to select the patching group, the patchGroup is optional, and is only allowed when the farm has one member.
• Use the exclusionReason option to explain the reason of excluding the resource from patch part.

This method is synchronous (status code 202).

• Include from patch party body:

PATCH /postgresql/1234
{
  "operation": "update_patch_party",
  "options": {
    "patchParty": {
        "excluded": false,
        "patchGroup": "3"
    }
 }
}

• Exclude from patch party body:

PATCH /postgresql/1234
{
  "operation": "update_patch_party",
  "options": {
    "patchParty": {
        "excluded": true,
        "exclusionReason": "I want to handle this by myself"
    }
 }
}

Install PostgreSQL extension

Use the install_extension operation to install an extension in the PostgreSQL.

This method is asynchronous (status code 202).

PATCH /postgresql/1234
{
	"operation":"install_extension",
	"options": {
        "dbname": "mydb",
        "extensions_list": [
        		{"name": "ext1"},
        		{"name": "ext2"}
        ]
    }
}

PATCHhttps://api.cegedim.cloud/itcare/databases/postgresql/{id}

Path parameters

id*integer (int64)

id, example: 123

Body

application/jsonapplication/vnd.cegedim-it.v1+json

operationstring

optionsobject

Response

200400

OK

Body

application/vnd.cegedim-it.v1+json

processstring

Code of action performed

statusenum

Status label of action

SUCCESS,IN_PROGRESS,ERROR

messagestring

Human readable message of status

idinteger (int32)

internalIdinteger (int64)

resourceNamestring

resourceTypestring

familystring

lastUpdatedAtstring (date-time)

Request

JavaScriptCurlPython

const response = await fetch('https://api.cegedim.cloud/itcare/databases/postgresql/{id}', {
    method: 'PATCH',
    headers: {
      "Content-Type": "application/json"
    },
    body: JSON.stringify({}),
});
const data = await response.json();

Response

200

{
  "process": "text",
  "status": "SUCCESS,IN_PROGRESS,ERROR",
  "message": "text",
  "id": 0,
  "internalId": 0,
  "resourceName": "text",
  "resourceType": "text",
  "family": "text",
  "lastUpdatedAt": "2025-01-02T14:31:07.794Z"
}

Get a PostgreSQL node informations

GEThttps://api.cegedim.cloud/itcare/databases/postgresql/{id}/nodes

Path parameters

id*integer (int64)

Response

200400

OK

Body

application/vnd.cegedim-it.v1+json

idinteger (int64)

namestring

typestring

internalTypestring

statusstring

categorystring

technologystring

familystring

labelstring

commentstring

productCodestring

productNamestring

productVersionstring

cloudIdinteger (int64)

cloudNamestring

serviceIdinteger (int64)

serviceNamestring

serviceKeystring

environmentstring

endOfSupportAtstring (date-time)

supportPhasestring

creationUserstring

creationTimestring

releasedAtstring (date-time)

endOfSalesAtstring (date-time)

extendedSupportAtstring (date-time)

monitoringEnabledboolean

monitoringAlertingboolean

monitoringOnCallEnabledboolean

monitoringRequestedboolean

replicationStatusboolean

backupStatusboolean

patchPartyPatchPartyV1 (object)

Representation of a resource patch party

metrologyUrlstring

pathstring

resourceTypestring

internalResourceIdinteger (int64)

backupPolicyDetailsBackupPolicyDetailsV1 (object)

ipAddressstring

networkNetworkV1 (object)

storageInformationStorageInformationV1 (object)

Information about a Storage of an Instance

availabilityZoneAvailabilityZoneV1 (object)

areaAreaV1 (object)

regionRegionV1 (object)

backupBackupV1 (object)

Backup information on an instance

replicationReplicationV1 (object)

Replication information on an instance

snapshotSnapshotV1 (object)

Snapshot of an instance

labelRegionstring

Region pretty name

labelDataCenterstring

DataCenter pretty name

labelAreastring

Area pretty name

labelAvailabilityZonestring

Availability Zone pretty name

totalSizeDisksstring

Total Disk size of the resource

cpuinteger (int64)

CPU of the resource

raminteger (int64)

RAM of the resource

storagenumber

Storage after disks format in GB of the resource

isMemberOFLoadBalancerboolean

Instance is member of load balancer

loadbalancersarray of LoadbalancerInfoV1 (object)

imageCodestring

Internal Image linked to this instance

osNamestring

OS name of this instance

osTypestring

OS type of this instance

isExternalIngressNodeboolean

This instance is ingress external node

isInternalIngressNodeboolean

This instance is ingress internal node

storageMoveInProgressboolean

Information about storage replication in Progress

authenticationDomainstring

parentResourceTypestring

enableProfileBaseNtpboolean

enableProfileBaseResolveboolean

manageSentinelOneboolean

relayHoststring

firewallEnableboolean

firewallBlockIntraSubnetTrafficboolean

firewallPurgeboolean

ntpServersarray of string

Request

JavaScriptCurlPython

const response = await fetch('https://api.cegedim.cloud/itcare/databases/postgresql/{id}/nodes', {
    method: 'GET',
    headers: {},
});
const data = await response.json();

Response

200

[
  {
    "id": 0,
    "name": "text",
    "type": "text",
    "internalType": "text",
    "status": "text",
    "category": "text",
    "technology": "text",
    "family": "text",
    "label": "text",
    "comment": "text",
    "productCode": "text",
    "productName": "text",
    "productVersion": "text",
    "cloudId": 0,
    "cloudName": "text",
    "serviceId": 0,
    "serviceName": "text",
    "serviceKey": "text",
    "environment": "text",
    "endOfSupportAt": "2025-01-02T14:31:07.794Z",
    "supportPhase": "text",
    "creationUser": "text",
    "creationTime": "text",
    "releasedAt": "2025-01-02T14:31:07.794Z",
    "endOfSalesAt": "2025-01-02T14:31:07.794Z",
    "extendedSupportAt": "2025-01-02T14:31:07.794Z",
    "monitoringEnabled": false,
    "monitoringAlerting": false,
    "monitoringOnCallEnabled": false,
    "monitoringRequested": false,
    "replicationStatus": false,
    "backupStatus": false,
    "patchParty": {
      "excluded": false,
      "exclusionReason": "text",
      "patchGroup": "text",
      "patchDate": "2025-01-02T14:31:07.794Z",
      "patchTag": "text",
      "name": "text",
      "id": 0,
      "excludedBy": "text",
      "exclusionDate": "2025-01-02T14:31:07.794Z"
    },
    "metrologyUrl": "text",
    "path": "text",
    "resourceType": "text",
    "internalResourceId": 0,
    "backupPolicyDetails": {
      "backups": [
        {
          "id": 0,
          "type": "text",
          "backupSize": 0,
          "backupLastDate": "2025-01-02T14:31:07.794Z"
        }
      ],
      "policies": [
        {
          "name": "text",
          "label": "text",
          "scope": "text",
          "type": "text",
          "replication": false,
          "durationInHours": 0,
          "startTime": "text",
          "timezone": "text",
          "policyId": "text",
          "backupLastDate": "2025-01-02T14:31:07.794Z",
          "backupSize": 0
        }
      ]
    },
    "ipAddress": "text",
    "network": {
      "id": 0,
      "technicalId": "text",
      "cidr": "text",
      "description": "text",
      "scope": "text",
      "defaultNetwork": false,
      "usedPercent": 0,
      "ipFreeNumber": 0,
      "ipAddress": "text",
      "dns": [
        {
          "alias": "text",
          "domain": "text"
        }
      ],
      "mask": "text",
      "networkShortDescription": "text",
      "isIpRangePublic": false,
      "cloud": "text",
      "environment": "text",
      "shortDescription": "text",
      "gateway": "text",
      "region": "text",
      "area": "text"
    },
    "storageInformation": {
      "totalSizeDisks": 0,
      "fileSystems": [
        {
          "mountingPoint": "text",
          "type": "text",
          "sizeOf": 0,
          "free": 0
        }
      ],
      "totalSizeFileSystems": 0
    },
    "availabilityZone": {
      "id": "text",
      "location": "text",
      "routable": false,
      "defaultZone": false,
      "datacenterId": "text",
      "availabilityZoneGroup": "text"
    },
    "area": {
      "id": "text",
      "location": "text",
      "regulation": "text",
      "defaultArea": false,
      "availabilityZones": [
        {
          "id": "text",
          "location": "text",
          "routable": false,
          "defaultZone": false,
          "datacenterId": "text",
          "availabilityZoneGroup": "text"
        }
      ]
    },
    "region": {
      "id": "text",
      "location": "text",
      "areas": [
        {
          "id": "text",
          "location": "text",
          "regulation": "text",
          "defaultArea": false,
          "availabilityZones": [
            {
              "id": "text",
              "location": "text",
              "routable": false,
              "defaultZone": false,
              "datacenterId": "text",
              "availabilityZoneGroup": "text"
            }
          ]
        }
      ],
      "dataCenter": "text"
    },
    "backup": {
      "backupSystem": "text",
      "size": 0,
      "type": "text",
      "filesNb": 0,
      "lastDate": "2025-01-02T14:31:07.794Z"
    },
    "replication": {
      "storageClass": "text",
      "storageReplicationClass": "text",
      "storageClassOverride": "text",
      "storageMoveInProgress": false,
      "storageMoveTicket": "text",
      "noStoRplExplanation": "text"
    },
    "snapshot": {
      "id": "text",
      "label": "text",
      "createdBy": "text",
      "createdAt": "2025-01-02T14:31:07.794Z",
      "recoveredAt": "2025-01-02T14:31:07.794Z",
      "expiresAt": "2025-01-02T14:31:07.794Z",
      "description": "text",
      "changeReference": "text",
      "snapshotSize": 0
    },
    "labelRegion": "text",
    "labelDataCenter": "text",
    "labelArea": "text",
    "labelAvailabilityZone": "text",
    "totalSizeDisks": "text",
    "cpu": 0,
    "ram": 0,
    "storage": 0,
    "isMemberOFLoadBalancer": false,
    "loadbalancers": [
      {
        "id": 0,
        "name": "text",
        "status": "text",
        "monitoringEnabled": false,
        "memberCount": 0,
        "serviceId": 0
      }
    ],
    "imageCode": "text",
    "osName": "text",
    "osType": "text",
    "isExternalIngressNode": false,
    "isInternalIngressNode": false,
    "storageMoveInProgress": false,
    "authenticationDomain": "text",
    "parentResourceType": "text",
    "enableProfileBaseNtp": false,
    "enableProfileBaseResolve": false,
    "manageSentinelOne": false,
    "relayHost": "text",
    "firewallEnable": false,
    "firewallBlockIntraSubnetTraffic": false,
    "firewallPurge": false,
    "ntpServers": [
      "text"
    ]
  }
]

Get a PostgreSQL network informations

GEThttps://api.cegedim.cloud/itcare/databases/postgresql/{id}/networks

Path parameters

id*integer (int64)

Response

200400

OK

Body

application/vnd.cegedim-it.v1+json

idinteger (int64)

technicalIdstring

cidrstring

descriptionstring

scopestring

defaultNetworkboolean

usedPercentinteger (int32)

ipFreeNumberinteger (int32)

ipAddressstring

dnsarray of DNSV1 (object)

maskstring

networkShortDescriptionstring

isIpRangePublicboolean

cloudstring

environmentstring

shortDescriptionstring

gatewaystring

regionstring

areastring

Request

JavaScriptCurlPython

const response = await fetch('https://api.cegedim.cloud/itcare/databases/postgresql/{id}/networks', {
    method: 'GET',
    headers: {},
});
const data = await response.json();

Response

200

[
  {
    "id": 0,
    "technicalId": "text",
    "cidr": "text",
    "description": "text",
    "scope": "text",
    "defaultNetwork": false,
    "usedPercent": 0,
    "ipFreeNumber": 0,
    "ipAddress": "text",
    "dns": [
      {
        "alias": "text",
        "domain": "text"
      }
    ],
    "mask": "text",
    "networkShortDescription": "text",
    "isIpRangePublic": false,
    "cloud": "text",
    "environment": "text",
    "shortDescription": "text",
    "gateway": "text",
    "region": "text",
    "area": "text"
  }
]

Get available extensions for a Postgre SQL Farm in the cloud

GEThttps://api.cegedim.cloud/itcare/databases/postgresql/{id}/extensions

Path parameters

id*integer (int64)

id, example: 500061854

Response

200400

OK

Body

application/vnd.cegedim-it.v1+json

namestring

requiresRestartingboolean

versionstring

commentstring

linkstring

Request

JavaScriptCurlPython

const response = await fetch('https://api.cegedim.cloud/itcare/databases/postgresql/{id}/extensions', {
    method: 'GET',
    headers: {},
});
const data = await response.json();

Response

200

[
  {
    "name": "text",
    "requiresRestarting": false,
    "version": "text",
    "comment": "text",
    "link": "text"
  }
]

Get available databases for a Postgre SQL Farm in the cloud

GEThttps://api.cegedim.cloud/itcare/databases/postgresql/{id}/databases

Path parameters

id*integer (int64)

id, example: 500061854

Response

200400

OK

Body

application/vnd.cegedim-it.v1+json

namestring

extensionsarray of PostgreExtension (object)

Request

JavaScriptCurlPython

const response = await fetch('https://api.cegedim.cloud/itcare/databases/postgresql/{id}/databases', {
    method: 'GET',
    headers: {},
});
const data = await response.json();

Response

200

[
  {
    "name": "text",
    "extensions": [
      {
        "name": "text",
        "schema": "text",
        "version": "text"
      }
    ]
  }
]