forked from canonical/postgresql-k8s-operator
-
Notifications
You must be signed in to change notification settings - Fork 0
/
config.yaml
408 lines (407 loc) · 12.8 KB
/
config.yaml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
# Copyright 2023 Canonical Ltd.
# See LICENSE file for licensing details.
options:
durability_synchronous_commit:
description: |
Sets the current transactions synchronization level. This charm allows only the
“on”, “remote_apply” and “remote_write” values to avoid data loss if the primary
crashes and there are replicas.
type: string
default: "on"
instance_default_text_search_config:
description: |
Selects the text search configuration that is used by those variants of the text
search functions that do not have an explicit argument specifying it.
Allowed values start with “pg_catalog.” followed by a language name, like
“pg_catalog.english”.
type: string
default: "pg_catalog.simple"
instance_password_encryption:
description: |
Determines the algorithm to use to encrypt the password.
Allowed values are: “md5” and “scram-sha-256”.
type: string
default: "scram-sha-256"
logging_log_connections:
description: |
Logs each successful connection.
type: boolean
default: false
logging_log_disconnections:
description: |
Logs end of a session, including duration.
type: boolean
default: false
logging_log_lock_waits:
description: |
Logs long lock waits.
type: boolean
default: false
logging_log_min_duration_statement:
description: |
Sets the minimum running time (milliseconds) above which statements will be logged.
Allowed values are: from -1 to 2147483647 (-1 disables logging
statement durations).
type: int
default: -1
memory_maintenance_work_mem:
description: |
Sets the maximum memory (KB) to be used for maintenance operations.
Allowed values are: from 1024 to 2147483647.
type: int
default: 65536
memory_max_prepared_transactions:
description: |
Sets the maximum number of simultaneously prepared transactions.
Allowed values are: from 0 to 262143.
type: int
default: 0
memory_shared_buffers:
description: |
Sets the number of shared memory buffers (8 kB) used by the server. This charm allows
to set this value up to 40% of the available memory from the unit, as it is unlikely
that an allocation of more than that will work better than a smaller amount.
Allowed values are: from 16 to 1073741823.
type: int
memory_temp_buffers:
description: |
Sets the maximum number of temporary buffers (8 kB) used by each session.
Allowed values are: from 100 to 1073741823.
type: int
default: 1024
memory_work_mem:
description: |
Sets the maximum memory (KB) to be used for query workspaces.
Allowed values are: from 64 to 2147483647.
type: int
default: 4096
optimizer_constraint_exclusion:
description: |
Enables the planner to use constraints to optimize queries.
Allowed values are: “on”, “off” and “partition”.
type: string
default: "partition"
optimizer_default_statistics_target:
description: |
Sets the default statistics target. Allowed values are: from 1 to 10000.
type: int
default: 100
optimizer_from_collapse_limit:
description: |
Sets the FROM-list size beyond which subqueries are not collapsed.
Allowed values are: from 1 to 2147483647.
type: int
default: 8
optimizer_join_collapse_limit:
description: |
Sets the FROM-list size beyond which JOIN constructs are not flattened.
Allowed values are: from 1 to 2147483647.
type: int
default: 8
plugin_citext_enable:
default: false
type: boolean
description: Enable citext extension.
plugin_debversion_enable:
default: false
type: boolean
description: Enable debversion extension.
plugin_hstore_enable:
default: false
type: boolean
description: Enable hstore extension.
plugin_pg_trgm_enable:
default: false
type: boolean
description: Enable pg_trgm extension.
plugin_plpython3u_enable:
default: false
type: boolean
description: Enable PL/Python extension.
plugin_unaccent_enable:
default: false
type: boolean
description: Enable unaccent extension.
plugin_bloom_enable:
default: false
type: boolean
description: Enable bloom extension.
plugin_btree_gin_enable:
default: false
type: boolean
description: Enable btree_gin extension.
plugin_btree_gist_enable:
default: false
type: boolean
description: Enable btree_gist extension.
plugin_cube_enable:
default: false
type: boolean
description: Enable cube extension.
plugin_dict_int_enable:
default: false
type: boolean
description: Enable dict_int extension.
plugin_dict_xsyn_enable:
default: false
type: boolean
description: Enable dict_xsyn extension.
plugin_earthdistance_enable:
default: false
type: boolean
description: Enable earthdistance extension.
plugin_fuzzystrmatch_enable:
default: false
type: boolean
description: Enable fuzzystrmatch extension.
plugin_intarray_enable:
default: false
type: boolean
description: Enable intarray extension.
plugin_isn_enable:
default: false
type: boolean
description: Enable isn extension.
plugin_lo_enable:
default: false
type: boolean
description: Enable lo extension.
plugin_ltree_enable:
default: false
type: boolean
description: Enable ltree extension.
plugin_old_snapshot_enable:
default: false
type: boolean
description: Enable old_snapshot extension.
plugin_pg_freespacemap_enable:
default: false
type: boolean
description: Enable pg_freespacemap extension.
plugin_pgrowlocks_enable:
default: false
type: boolean
description: Enable pgrowlocks extension.
plugin_pgstattuple_enable:
default: false
type: boolean
description: Enable pgstattuple extension.
plugin_pg_visibility_enable:
default: false
type: boolean
description: Enable pg_visibility extension.
plugin_seg_enable:
default: false
type: boolean
description: Enable seg extension.
plugin_tablefunc_enable:
default: false
type: boolean
description: Enable tablefunc extension.
plugin_tcn_enable:
default: false
type: boolean
description: Enable tcn extension.
plugin_tsm_system_rows_enable:
default: false
type: boolean
description: Enable tsm_system_rows extension.
plugin_tsm_system_time_enable:
default: false
type: boolean
description: Enable tsm_system_time extension.
plugin_uuid_ossp_enable:
default: false
type: boolean
description: Enable uuid_ossp extension.
plugin_spi_enable:
default: false
type: boolean
description: Enable spi extension.
plugin_bool_plperl_enable:
default: false
type: boolean
description: Enable bool_plperl extension.
plugin_hll_enable:
default: false
type: boolean
description: Enable hll extension.
plugin_hypopg_enable:
default: false
type: boolean
description: Enable hypopg extension.
plugin_ip4r_enable:
default: false
type: boolean
description: Enable ip4r extension.
plugin_plperl_enable:
default: false
type: boolean
description: Enable plperl extension.
plugin_jsonb_plperl_enable:
default: false
type: boolean
description: Enable jsonb_plperl extension.
plugin_orafce_enable:
default: false
type: boolean
description: Enable orafce extension.
plugin_pg_similarity_enable:
default: false
type: boolean
description: Enable pg_similarity extension.
plugin_prefix_enable:
default: false
type: boolean
description: Enable prefix extension.
plugin_rdkit_enable:
default: false
type: boolean
description: Enable rdkit extension.
plugin_tds_fdw_enable:
default: false
type: boolean
description: Enable tds_fdw extension.
plugin_icu_ext_enable:
default: false
type: boolean
description: Enable icu_ext extension.
plugin_pltcl_enable:
default: false
type: boolean
description: Enable pltcl extension.
plugin_postgis_enable:
default: false
type: boolean
description: Enable postgis extension.
plugin_address_standardizer_enable:
default: false
type: boolean
description: Enable address_standardizer extension.
plugin_postgis_raster_enable:
default: false
type: boolean
description: Enable postgis_raster extension.
plugin_address_standardizer_data_us_enable:
default: false
type: boolean
description: Enable address_standardizer_data_us extension.
plugin_postgis_tiger_geocoder_enable:
default: false
type: boolean
description: Enable postgis_tiger_geocoder extension.
plugin_postgis_topology_enable:
default: false
type: boolean
description: Enable postgis_topology extension.
plugin_vector_enable:
default: false
type: boolean
description: Enable pgvector extension
plugin_timescaledb_enable:
default: false
type: boolean
description: Enable timescaledb extension
plugin_audit_enable:
default: true
type: boolean
description: Enable pgAudit extension
profile:
description: |
Profile representing the scope of deployment, and used to tune resource allocation.
Allowed values are: “production” and “testing”.
Production will tune postgresql for maximum performance while testing will tune for
minimal running performance.
type: string
default: "production"
profile_limit_memory:
type: int
description: |
Amount of memory in Megabytes to limit PostgreSQL and associated process to.
If unset, this will be decided according to the default memory limit in the selected profile.
Only comes into effect when the `production` profile is selected.
request_date_style:
description: |
Sets the display format for date and time values. Allowed formats are explained
in https://www.postgresql.org/docs/14/runtime-config-client.html#GUC-DATESTYLE.
type: string
default: "ISO, MDY"
request_standard_conforming_strings:
description: |
Causes ... strings to treat backslashes literally.
type: boolean
default: true
request_time_zone:
description: |
Sets the time zone for displaying and interpreting time stamps.
Allowed values are the ones from IANA time zone data, a time zone abbreviation
like PST and POSIX-style time zone specifications.
type: string
default: "UTC"
response_bytea_output:
description: |
Sets the output format for bytes.
Allowed values are: “escape” and “hex”.
type: string
default: "hex"
response_lc_monetary:
description: |
Sets the locale for formatting monetary amounts.
Allowed values are the locales available in the unit.
type: string
default: "C"
response_lc_numeric:
description: |
Sets the locale for formatting numbers.
Allowed values are the locales available in the unit.
type: string
default: "C"
response_lc_time:
description: |
Sets the locale for formatting date and time values.
Allowed values are the locales available in the unit.
type: string
default: "C"
vacuum_autovacuum_analyze_scale_factor:
description: |
Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when
deciding whether to trigger a VACUUM. The default, 0.1, means 10% of table size.
Allowed values are: from 0 to 100.
type: float
default: 0.1
vacuum_autovacuum_analyze_threshold:
description: |
Sets the minimum number of inserted, updated or deleted tuples needed to trigger
an ANALYZE in any one table. Allowed values are: from 0 to 2147483647.
type: int
default: 50
vacuum_autovacuum_freeze_max_age:
description: |
Maximum age (in transactions) before triggering autovacuum on a table to prevent
transaction ID wraparound. Allowed values are: from 100000 to 2000000000.
type: int
default: 200000000
vacuum_autovacuum_vacuum_cost_delay:
description: |
Sets cost delay value (milliseconds) that will be used in automatic VACUUM operations.
Allowed values are: from -1 to 100 (-1 tells PostgreSQL to use the regular
vacuum_cost_delay value).
type: float
default: 2.0
vacuum_autovacuum_vacuum_scale_factor:
description: |
Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when
deciding whether to trigger a VACUUM. The default, 0.2, means 20% of table size.
Allowed values are: from 0 to 100.
type: float
default: 0.2
vacuum_vacuum_freeze_table_age:
description: |
Age (in transactions) at which VACUUM should scan whole table to freeze tuples.
Allowed values are: from 0 to 2000000000.
type: int
default: 150000000
experimental_max_connections:
type: int
description: |
[EXPERIMENTAL] Force set max_connections.