Gets project's Postgres config

1
{
2
  "effective_cache_size": "lorem",
3
  "logical_decoding_work_mem": "lorem",
4
  "pg_stat_statements.max": 100,
5
  "pg_net.batch_size": 0,
6
  "autovacuum_max_workers": 1,
7
  "autovacuum_work_mem": "lorem",
8
  "cron.log_statement": true,
9
  "log_autovacuum_min_duration": "444444444444444444444444444444444444444444444444444",
10
  "log_checkpoints": true,
11
  "log_connections": true,
12
  "log_disconnections": true,
13
  "log_duration": true,
14
  "log_lock_waits": true,
15
  "log_recovery_conflict_waits": true,
16
  "log_replication_commands": true,
17
  "log_startup_progress_interval": "444444444444444444444444444444444444444444444444444",
18
  "log_temp_files": "lorem",
19
  "maintenance_work_mem": "lorem",
20
  "track_activity_query_size": "lorem",
21
  "max_connections": 1,
22
  "max_locks_per_transaction": 10,
23
  "max_logical_replication_workers": 0,
24
  "max_parallel_maintenance_workers": 0,
25
  "max_parallel_workers": 0,
26
  "max_parallel_workers_per_gather": 0,
27
  "max_replication_slots": -9007199254740991,
28
  "max_slot_wal_keep_size": "lorem",
29
  "max_standby_archive_delay": "lorem",
30
  "max_standby_streaming_delay": "lorem",
31
  "max_sync_workers_per_subscription": 0,
32
  "max_wal_size": "lorem",
33
  "max_wal_senders": -9007199254740991,
34
  "max_worker_processes": 0,
35
  "session_replication_role": "origin",
36
  "shared_buffers": "lorem",
37
  "statement_timeout": "444444444444444444444444444444444444444444444444444",
38
  "track_commit_timestamp": true,
39
  "wal_keep_size": "lorem",
40
  "wal_sender_timeout": "444444444444444444444444444444444444444444444444444",
41
  "work_mem": "lorem",
42
  "checkpoint_timeout": "444444444444444444444444444444444444444444444444444",
43
  "hot_standby_feedback": true
44
}

1
{
2
  "type": "object",
3
  "properties": {
4
    "effective_cache_size": {
5
      "type": "string"
6
    },
7
    "logical_decoding_work_mem": {
8
      "type": "string"
9
    },
10
    "pg_stat_statements.max": {
11
      "type": "integer",
12
      "minimum": 100,
13
      "maximum": 45000
14
    },
15
    "pg_net.batch_size": {
16
      "type": "integer",
17
      "minimum": 0,
18
      "maximum": 32767
19
    },
20
    "autovacuum_max_workers": {
21
      "type": "integer",
22
      "minimum": 1,
23
      "maximum": 262143
24
    },
25
    "autovacuum_work_mem": {
26
      "type": "string"
27
    },
28
    "cron.log_statement": {
29
      "type": "boolean"
30
    },
31
    "log_autovacuum_min_duration": {
32
      "type": "string",
33
      "description": "Default unit: ms",
34
      "pattern": "^(-?[0-9]+(?:\\.[0-9]+)?)(us|ms|s|min|h|d)?$"
35
    },
36
    "log_checkpoints": {
37
      "type": "boolean"
38
    },
39
    "log_connections": {
40
      "type": "boolean"
41
    },
42
    "log_disconnections": {
43
      "type": "boolean"
44
    },
45
    "log_duration": {
46
      "type": "boolean"
47
    },
48
    "log_lock_waits": {
49
      "type": "boolean"
50
    },
51
    "log_recovery_conflict_waits": {
52
      "type": "boolean"
53
    },
54
    "log_replication_commands": {
55
      "type": "boolean"
56
    },
57
    "log_startup_progress_interval": {
58
      "type": "string",
59
      "description": "Default unit: ms",
60
      "pattern": "^(-?[0-9]+(?:\\.[0-9]+)?)(us|ms|s|min|h|d)?$"
61
    },
62
    "log_temp_files": {
63
      "type": "string"
64
    },
65
    "maintenance_work_mem": {
66
      "type": "string"
67
    },
68
    "track_activity_query_size": {
69
      "type": "string"
70
    },
71
    "max_connections": {
72
      "type": "integer",
73
      "minimum": 1,
74
      "maximum": 262143
75
    },
76
    "max_locks_per_transaction": {
77
      "type": "integer",
78
      "minimum": 10,
79
      "maximum": 2147483640
80
    },
81
    "max_logical_replication_workers": {
82
      "type": "integer",
83
      "minimum": 0,
84
      "maximum": 262143
85
    },
86
    "max_parallel_maintenance_workers": {
87
      "type": "integer",
88
      "minimum": 0,
89
      "maximum": 1024
90
    },
91
    "max_parallel_workers": {
92
      "type": "integer",
93
      "minimum": 0,
94
      "maximum": 1024
95
    },
96
    "max_parallel_workers_per_gather": {
97
      "type": "integer",
98
      "minimum": 0,
99
      "maximum": 1024
100
    },
101
    "max_replication_slots": {
102
      "type": "integer",
103
      "minimum": -9007199254740991,
104
      "maximum": 9007199254740991
105
    },
106
    "max_slot_wal_keep_size": {
107
      "type": "string"
108
    },
109
    "max_standby_archive_delay": {
110
      "type": "string"
111
    },
112
    "max_standby_streaming_delay": {
113
      "type": "string"
114
    },
115
    "max_sync_workers_per_subscription": {
116
      "type": "integer",
117
      "minimum": 0,
118
      "maximum": 262143
119
    },
120
    "max_wal_size": {
121
      "type": "string"
122
    },
123
    "max_wal_senders": {
124
      "type": "integer",
125
      "minimum": -9007199254740991,
126
      "maximum": 9007199254740991
127
    },
128
    "max_worker_processes": {
129
      "type": "integer",
130
      "minimum": 0,
131
      "maximum": 262143
132
    },
133
    "session_replication_role": {
134
      "type": "string",
135
      "enum": [
136
        "origin",
137
        "replica",
138
        "local"
139
      ]
140
    },
141
    "shared_buffers": {
142
      "type": "string"
143
    },
144
    "statement_timeout": {
145
      "type": "string",
146
      "description": "Default unit: ms",
147
      "pattern": "^(-?[0-9]+(?:\\.[0-9]+)?)(us|ms|s|min|h|d)?$"
148
    },
149
    "track_commit_timestamp": {
150
      "type": "boolean"
151
    },
152
    "wal_keep_size": {
153
      "type": "string"
154
    },
155
    "wal_sender_timeout": {
156
      "type": "string",
157
      "description": "Default unit: ms",
158
      "pattern": "^(-?[0-9]+(?:\\.[0-9]+)?)(us|ms|s|min|h|d)?$"
159
    },
160
    "work_mem": {
161
      "type": "string"
162
    },
163
    "checkpoint_timeout": {
164
      "type": "string",
165
      "description": "Default unit: s",
166
      "pattern": "^(-?[0-9]+(?:\\.[0-9]+)?)(us|ms|s|min|h|d)?$"
167
    },
168
    "hot_standby_feedback": {
169
      "type": "boolean"
170
    }
171
  }
172
}