Path parameters
-
name string Required
Body Required
-
pgbouncer-settings object
PGBouncer connection pooling settings
-
backup-schedule object
-
variant string
Variant of the PostgreSQL service, may affect the features that are exposed by default
Values are
timescale
oraiven
. -
timescaledb-settings object
TimescaleDB extension configuration values
-
ip-filter array[string]
Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'
-
termination-protection boolean
Service is protected against termination and powering off
-
synchronous-replication string
Synchronous replication type. Note that the service plan also needs to support synchronous replication.
Values are
quorum
oroff
. -
pglookout-settings object
PGLookout settings
-
maintenance object
Automatic maintenance settings
-
version string
Version
-
plan string
Subscription plan
Minimum length is
1
, maximum length is128
. -
work-mem integer(int64)
Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. Default is 1MB + 0.075% of total RAM (up to 32MB).
Minimum value is
1
, maximum value is1024
. -
pg-settings object
PostgreSQL-specific settings
-
migration object
Migrate data from existing server
curl \
-X PUT https://api-ch-gva-2.exoscale.com/v2/dbaas-postgres/{name} \
-H "Content-Type: application/json" \
-d '{"pgbouncer-settings":{},"backup-schedule":{"backup-hour":42,"backup-minute":42},"variant":"timescale","timescaledb-settings":{},"ip-filter":["string"],"termination-protection":true,"synchronous-replication":"quorum","pglookout-settings":{},"maintenance":{"dow":"saturday","time":"string"},"version":"string","plan":"string","work-mem":42,"shared-buffers-percentage":42,"pg-settings":{},"migration":{"host":"string","port":42,"password":"string","ssl":true,"username":"string","dbname":"string","ignore-dbs":"string","method":"dump"}}'
{
"pgbouncer-settings": {},
"backup-schedule": {
"backup-hour": 42,
"backup-minute": 42
},
"variant": "timescale",
"timescaledb-settings": {},
"ip-filter": [
"string"
],
"termination-protection": true,
"synchronous-replication": "quorum",
"pglookout-settings": {},
"maintenance": {
"dow": "saturday",
"time": "string"
},
"version": "string",
"plan": "string",
"work-mem": 42,
"shared-buffers-percentage": 42,
"pg-settings": {},
"migration": {
"host": "string",
"port": 42,
"password": "string",
"ssl": true,
"username": "string",
"dbname": "string",
"ignore-dbs": "string",
"method": "dump"
}
}
{
"id": "string",
"reason": "incorrect",
"reference": {
"id": "string",
"link": "string",
"command": "string"
},
"message": "string",
"state": "failure"
}