Updates project's Postgres config
put
/v1/projects/{ref}/config/database/postgresOAuth scopes
- database:write
Path parameters
- refRequiredstring
Project ref
Body
- effective_cache_sizeOptionalstring
- logical_decoding_work_memOptionalstring
- cron.log_statementOptionalboolean
- log_autovacuum_min_durationOptionalstring
- log_checkpointsOptionalboolean
- log_connectionsOptionalboolean
- log_disconnectionsOptionalboolean
- log_durationOptionalboolean
- log_lock_waitsOptionalboolean
- log_recovery_conflict_waitsOptionalboolean
- log_replication_commandsOptionalboolean
- log_startup_progress_intervalOptionalstring
- log_temp_filesOptionalstring
- maintenance_work_memOptionalstring
- track_activity_query_sizeOptionalstring
- max_connectionsOptionalinteger
- max_locks_per_transactionOptionalinteger
- max_parallel_maintenance_workersOptionalinteger
- max_parallel_workersOptionalinteger
- max_parallel_workers_per_gatherOptionalinteger
- max_replication_slotsOptionalinteger
- max_slot_wal_keep_sizeOptionalstring
- max_standby_archive_delayOptionalstring
- max_standby_streaming_delayOptionalstring
- max_wal_sizeOptionalstring
- max_wal_sendersOptionalinteger
- max_worker_processesOptionalinteger
- session_replication_roleOptionalenum
- shared_buffersOptionalstring
- statement_timeoutOptionalstring
- track_commit_timestampOptionalboolean
- wal_keep_sizeOptionalstring
- wal_sender_timeoutOptionalstring
- work_memOptionalstring
- checkpoint_timeoutOptionalstring
- hot_standby_feedbackOptionalboolean
- restart_databaseOptionalboolean
Response codes
- 200
- 401
- 403
- 429
- 500
Response (200)
1{2 "effective_cache_size": "lorem",3 "logical_decoding_work_mem": "lorem",4 "cron.log_statement": true,5 "log_autovacuum_min_duration": "444444444444444444444444444444444444444444444444444",6 "log_checkpoints": true,7 "log_connections": true,8 "log_disconnections": true,9 "log_duration": true,10 "log_lock_waits": true,11 "log_recovery_conflict_waits": true,12 "log_replication_commands": true,13 "log_startup_progress_interval": "444444444444444444444444444444444444444444444444444",14 "log_temp_files": "lorem",15 "maintenance_work_mem": "lorem",16 "track_activity_query_size": "lorem",17 "max_connections": 1,18 "max_locks_per_transaction": 10,19 "max_parallel_maintenance_workers": 0,20 "max_parallel_workers": 0,21 "max_parallel_workers_per_gather": 0,22 "max_replication_slots": 42,23 "max_slot_wal_keep_size": "lorem",24 "max_standby_archive_delay": "lorem",25 "max_standby_streaming_delay": "lorem",26 "max_wal_size": "lorem",27 "max_wal_senders": 42,28 "max_worker_processes": 0,29 "session_replication_role": "origin",30 "shared_buffers": "lorem",31 "statement_timeout": "444444444444444444444444444444444444444444444444444",32 "track_commit_timestamp": true,33 "wal_keep_size": "lorem",34 "wal_sender_timeout": "444444444444444444444444444444444444444444444444444",35 "work_mem": "lorem",36 "checkpoint_timeout": "444444444444444444444444444444444444444444444444444",37 "hot_standby_feedback": true38}