Path parameters
-
Service name
Minimum length is
0
, maximum length is63
.
GET /dbaas-postgres/{name}
curl \
-X GET https://api-ch-gva-2.exoscale.com/v2/dbaas-postgres/{name}
Response examples (200)
{
"pgbouncer-settings": {
"min_pool_size": 0,
"ignore_startup_parameters": [
"extra_float_digits",
"search_path"
],
"server_lifetime": 3600,
"autodb_pool_mode": "session",
"server_idle_timeout": 600,
"autodb_max_db_connections": 0,
"server_reset_query_always": false,
"autodb_pool_size": 0,
"autodb_idle_timeout": 3600
},
"updated-at": "2024-05-04T09:42:00+00:00",
"node-count": 42,
"connection-info": {
"uri": [
"string"
],
"params": [
{
"additionalProperty1": "string",
"additionalProperty2": "string"
}
],
"standby": [
"string"
],
"syncing": [
"string"
]
},
"backup-schedule": {
"backup-hour": 42,
"backup-minute": 42
},
"node-cpu-count": 42,
"integrations": [
{
"description": "string",
"settings": {},
"type": "string",
"is-enabled": true,
"source": "string",
"is-active": true,
"status": "string",
"id": "string",
"dest": "string"
}
],
"zone": "string",
"node-states": [
{
"name": "string",
"progress-updates": [
{
"completed": true,
"current": 42,
"max": 42,
"min": 42,
"phase": "stream",
"unit": "string"
}
],
"role": "standby",
"state": "leaving"
}
],
"name": "string",
"connection-pools": [
{
"connection-uri": "string",
"database": "string",
"mode": "transaction",
"name": "string",
"size": 42,
"username": "string"
}
],
"type": "string",
"state": "running",
"timescaledb-settings": {
"max_background_workers": 8
},
"databases": [
"string"
],
"ip-filter": [
"string"
],
"backups": [
{
"backup-name": "string",
"backup-time": "2024-05-04T09:42:00+00:00",
"data-size": 42
}
],
"termination-protection": true,
"notifications": [
{
"level": "warning",
"message": "string",
"type": "service_powered_off_removal",
"metadata": {}
}
],
"components": [
{
"component": "string",
"host": "string",
"port": 42,
"route": "dynamic",
"usage": "primary"
}
],
"synchronous-replication": "quorum",
"pglookout-settings": {
"max_failover_replication_time_lag": 60
},
"maintenance": {
"dow": "saturday",
"time": "string",
"updates": [
{
"description": "string",
"deadline": "2024-05-04T09:42:00+00:00",
"start-after": "2024-05-04T09:42:00+00:00",
"start-at": "2024-05-04T09:42:00+00:00"
}
]
},
"disk-size": 42,
"node-memory": 42,
"uri": "string",
"uri-params": {},
"version": "string",
"created-at": "2024-05-04T09:42:00+00:00",
"plan": "string",
"work-mem": 42,
"shared-buffers-percentage": 42,
"pg-settings": {
"track_activity_query_size": 1024,
"timezone": "Europe/Helsinki",
"track_io_timing": "off",
"pg_stat_monitor.pgsm_enable_query_plan": false,
"max_files_per_process": 42,
"pg_stat_monitor.pgsm_max_buckets": 10,
"wal": {
"max_slot_wal_keep_size": 42,
"max_wal_senders": 42,
"wal_sender_timeout": 42,
"wal_writer_delay": 50
},
"default_toast_compression": "lz4",
"deadlock_timeout": 1000,
"idle_in_transaction_session_timeout": 42,
"max_pred_locks_per_transaction": 42,
"max_replication_slots": 42,
"autovacuum": {
"log_autovacuum_min_duration": 42,
"autovacuum_vacuum_cost_limit": 42,
"autovacuum_max_workers": 42,
"autovacuum_vacuum_threshold": 42,
"autovacuum_naptime": 42,
"autovacuum_vacuum_scale_factor": 42.0,
"autovacuum_vacuum_cost_delay": 42,
"autovacuum_analyze_scale_factor": 42.0,
"autovacuum_analyze_threshold": 42,
"autovacuum_freeze_max_age": 200000000
},
"max_parallel_workers_per_gather": 42,
"pg_partman_bgw.interval": 3600,
"log_line_prefix": "'pid=%p,user=%u,db=%d,app=%a,client=%h '",
"log_temp_files": 42,
"max_locks_per_transaction": 42,
"track_commit_timestamp": "off",
"track_functions": "all",
"max_stack_depth": 42,
"max_parallel_workers": 42,
"pg_partman_bgw.role": "myrolename",
"max_logical_replication_workers": 42,
"max_prepared_transactions": 42,
"max_worker_processes": 42,
"pg_stat_statements.track": "all",
"temp_file_limit": 5000000,
"log_error_verbosity": "TERSE",
"log_min_duration_statement": 42,
"max_standby_streaming_delay": 42,
"jit": true,
"max_standby_archive_delay": 42,
"bg-writer": {
"bgwriter_delay": 200,
"bgwriter_flush_after": 512,
"bgwriter_lru_maxpages": 100,
"bgwriter_lru_multiplier": 2.0
}
},
"max-connections": 42,
"users": [
{
"type": "string",
"username": "string",
"password": "string",
"allow-replication": true
}
]
}