v1
latestOpenAPI 3.0.02026-07-14169146300.3 KBDatabase
Updates project's Postgres config
put/v1/projects/{ref}/config/database/postgres
Path parameters
refstring required
Example:abcdefghijklmnopqrst
Project ref
Request body
effective_cache_sizestring
logical_decoding_work_memstring
cron.log_statementboolean
log_autovacuum_min_durationstring
Default unit: ms
log_checkpointsboolean
log_connectionsboolean
log_disconnectionsboolean
log_durationboolean
log_lock_waitsboolean
log_recovery_conflict_waitsboolean
log_replication_commandsboolean
log_startup_progress_intervalstring
Default unit: ms
log_temp_filesstring
maintenance_work_memstring
track_activity_query_sizestring
max_connectionsinteger
max_locks_per_transactioninteger
max_logical_replication_workersinteger
max_parallel_maintenance_workersinteger
max_parallel_workersinteger
max_parallel_workers_per_gatherinteger
max_replication_slotsinteger
max_slot_wal_keep_sizestring
max_standby_archive_delaystring
max_standby_streaming_delaystring
max_sync_workers_per_subscriptioninteger
max_wal_sizestring
max_wal_sendersinteger
max_worker_processesinteger
session_replication_role'origin' | 'replica' | 'local'
shared_buffersstring
statement_timeoutstring
Default unit: ms
track_commit_timestampboolean
wal_keep_sizestring
wal_sender_timeoutstring
Default unit: ms
work_memstring
checkpoint_timeoutstring
Default unit: s
hot_standby_feedbackboolean
restart_databaseboolean
Example request
{
"max_connections": 120,
"shared_buffers": "256MB",
"work_mem": "4MB",
"statement_timeout": "60000ms"
}Response
effective_cache_sizestring
logical_decoding_work_memstring
cron.log_statementboolean
log_autovacuum_min_durationstring
Default unit: ms
log_checkpointsboolean
log_connectionsboolean
log_disconnectionsboolean
log_durationboolean
log_lock_waitsboolean
log_recovery_conflict_waitsboolean
log_replication_commandsboolean
log_startup_progress_intervalstring
Default unit: ms
log_temp_filesstring
maintenance_work_memstring
track_activity_query_sizestring
max_connectionsinteger
max_locks_per_transactioninteger
max_logical_replication_workersinteger
max_parallel_maintenance_workersinteger
max_parallel_workersinteger
max_parallel_workers_per_gatherinteger
max_replication_slotsinteger
max_slot_wal_keep_sizestring
max_standby_archive_delaystring
max_standby_streaming_delaystring
max_sync_workers_per_subscriptioninteger
max_wal_sizestring
max_wal_sendersinteger
max_worker_processesinteger
session_replication_role'origin' | 'replica' | 'local'
shared_buffersstring
statement_timeoutstring
Default unit: ms
track_commit_timestampboolean
wal_keep_sizestring
wal_sender_timeoutstring
Default unit: ms
work_memstring
checkpoint_timeoutstring
Default unit: s
hot_standby_feedbackboolean