Skip to content
Management API Reference

Updates project's Postgres config

put/v1/projects/{ref}/config/database/postgres

OAuth scopes

  • database:write

Path parameters

  • ref
    Required
    string

    Project ref

Body

  • effective_cache_size
    Optional
    string
  • logical_decoding_work_mem
    Optional
    string
  • cron.log_statement
    Optional
    boolean
  • log_autovacuum_min_duration
    Optional
    string
  • log_checkpoints
    Optional
    boolean
  • log_connections
    Optional
    boolean
  • log_disconnections
    Optional
    boolean
  • log_duration
    Optional
    boolean
  • log_lock_waits
    Optional
    boolean
  • log_recovery_conflict_waits
    Optional
    boolean
  • log_replication_commands
    Optional
    boolean
  • log_startup_progress_interval
    Optional
    string
  • log_temp_files
    Optional
    string
  • maintenance_work_mem
    Optional
    string
  • track_activity_query_size
    Optional
    string
  • max_connections
    Optional
    integer
  • max_locks_per_transaction
    Optional
    integer
  • max_parallel_maintenance_workers
    Optional
    integer
  • max_parallel_workers
    Optional
    integer
  • max_parallel_workers_per_gather
    Optional
    integer
  • max_replication_slots
    Optional
    integer
  • max_slot_wal_keep_size
    Optional
    string
  • max_standby_archive_delay
    Optional
    string
  • max_standby_streaming_delay
    Optional
    string
  • max_wal_size
    Optional
    string
  • max_wal_senders
    Optional
    integer
  • max_worker_processes
    Optional
    integer
  • session_replication_role
    Optional
    enum
  • shared_buffers
    Optional
    string
  • statement_timeout
    Optional
    string
  • track_commit_timestamp
    Optional
    boolean
  • wal_keep_size
    Optional
    string
  • wal_sender_timeout
    Optional
    string
  • work_mem
    Optional
    string
  • checkpoint_timeout
    Optional
    string
  • hot_standby_feedback
    Optional
    boolean
  • restart_database
    Optional
    boolean

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": true
38
}