Include default parameters in the status
Problem to solve
We want to know which parameters of configuration (postgres and pgbouncer) will de added by default
Proposal
Include list of parameters that are defaults in the status of SGPostgresConfig
and SGPoolingConfig
CRs when modified by the mutating web hooks.
Proposed schema changes:
- SGPostgresConfig:
apiVersion: stackgres.io/v1beta1
kind: SGPostgresConfig
metadata:
name: example
spec:
postgresVersion: 'latest'
postgresql.conf:
checkpoint_completion_target: '0.9'
checkpoint_timeout: 15min
default_statistics_target: '250'
wal_compression: on
lc_messages: C
track_activity_query_size: '2048'
huge_pages: off
shared_preload_libraries: pg_stat_statements
track_io_timing: on
track_functions: pl
extra_float_digits: '1'
random_page_cost: '1.5'
status:
defaultParameters:
- checkpoint_completion_target
- checkpoint_timeout
- default_statistics_target
- wal_compression
- lc_messages
- track_activity_query_size
- huge_pages
- shared_preload_libraries
- track_io_timing
- track_functions
- extra_float_digits
- SGPoolingConfig:
apiVersion: stackgres.io/v1beta1
kind: SGPoolingConfig
metadata:
name: example
spec:
pgBouncer:
pgbouncer.ini:
pool_mode: session
max_client_conn: 2000
status:
pgBouncer:
defaultParameters:
- pool_mode
Edited by Matteo Melli