Server configuration |
Environment variable |
PDS default value |
max.connections
|
MAX_CONNECTIONS
|
200
|
shared.buffers
|
SHARED_BUFFERS
|
6000MB
|
vacuum.cost.delay
|
VACUUM_COST_DELAY
|
10ms
|
wal.level
|
WAL_LEVEL
|
replica
|
max.wal.senders
|
MAX_WAL_SENDERS
|
6
|
effective.cache.size
|
EFFECTIVE_CACHE_SIZE
|
10240MB
|
log.destination
|
LOG_DESTINATION
|
stderr
|
logging.collector
|
LOGGING_COLLECTOR
|
off
|
log.directory
|
LOG_DIRECTORY
|
pg_log
|
log.timezone
|
LOG_TIMEZONE
|
UTC
|
track.counts
|
TRACK_COUNTS
|
on
|
autovacuum
|
AUTOVACUUM
|
on
|
autovacuum.max.workers
|
AUTOVACUUM_MAX_WORKERS
|
5
|
autovacuum.vacuum.threshold
|
AUTOVACUUM_VACUUM_THRESHOLD
|
1000
|
autovacuum.analyze.threshold
|
AUTOVACUUM_ANALYZE_THRESHOLD
|
1000
|
autovacuum.vacuum.scale.factor
|
AUTOVACUUM_VACUUM_SCALE_FACTOR
|
0.01
|
autovacuum.vacuum.cost.delay
|
AUTOVACUUM_VACUUM_COST_DELAY
|
-1
|
datestyle
|
DATESTYLE
|
iso, mdy
|
timezone
|
TIMEZONE
|
UTC
|
lc.messages
|
LC_MESSAGES
|
en_US.UTF-8
|
lc.monetary
|
LC_MONETARY
|
en_US.UTF-8
|
lc.numeric
|
LC_NUMERIC
|
en_US.UTF-8
|
lc.time
|
LC_TIME
|
en_US.UTF-8
|
default.text.search.config
|
DEFAULT_TEXT_SEARCH_CONFIG
|
pg_catalog.english
|
standard.conforming.strings
|
STANDARD_CONFORMING_STRINGS
|
on
|
work.mem
|
WORK_MEM
|
32MB
|
random.page.cost
|
RANDOM_PAGE_COST
|
1.5
|
wal.keep.segments
|
WAL_KEEP_SEGMENTS
|
400
|
hot.standby
|
HOT_STANDBY
|
on
|
log.filename
|
LOG_FILENAME
|
postgresql-%a.log
|
log.truncate.on.rotation
|
LOG_TRUNCATE_ON_ROTATION
|
on
|
log.rotation.age
|
LOG_ROTATION_AGE
|
1d
|
log.rotation.size
|
LOG_ROTATION_SIZE
|
0
|
log.line.prefix
|
LOG_LINE_PREFIX
|
postgres %m [%p] %q(%u@%d/%a)
|
log.lock.waits
|
LOG_LOCK_WAITS
|
on
|
checkpoint.completion.target
|
CHECKPOINT_COMPLETION_TARGET
|
0.9
|
log.autovacuum.min.duration
|
LOG_AUTOVACUUM_MIN_DURATION
|
0
|
maintenance.work.mem
|
MAINTENANCE_WORK_MEM
|
4000MB
|
temp.buffers
|
TEMP_BUFFERS
|
8MB
|
shared.preload.libraries
|
SHARED_PRELOAD_LIBRARIES
|
pg_stat_statements
|
pg.stat.statements.max
|
PG_STAT_STATEMENTS_MAX
|
1000
|
pg.stat.statements.track
|
PG_STAT_STATEMENTS_TRACK
|
all
|
archive_mode
|
ARCHIVE_MODE
|
on
|
archive_timeout
|
ARCHIVE_TIMEOUT
|
60
|
pg.mode
|
PG_MODE
|
primary
|
pg.locale
|
PG_LOCALE
|
en_US.UTF-8
|
checksums
|
CHECKSUMS
|
TRUE
|
path
|
PATH
|
/opt/cpm/bin:/usr/local/bin:$PGROOT/bin:/usr/local/bin:$PATH
|
ld.library.path
|
LD_LIBRARY_PATH
|
$PGROOT/lib
|
crunchy.debug
|
CRUNCHY_DEBUG
|
FALSE
|
log.statement
|
LOG_STATEMENT
|
none
|
log.min.duration.statement
|
LOG_MIN_DURATION_STATEMENT
|
60000
|
mount.opts
|
MOUNT_OPTS
|
defaults
|
pgbackrest
|
PGBACKREST
|
TRUE
|
pgbackrest.repo1.type
|
PGBACKREST_REPO1_TYPE
|
posix
|
archive.mode
|
ARCHIVE_MODE
|
on
|
archive.timeout
|
ARCHIVE_TIMEOUT
|
60
|
pgha.standby
|
PGHA_STANDBY
|
FALSE
|
pgha.default.config
|
PGHA_DEFAULT_CONFIG
|
TRUE
|
pgha.replica.reinit.on.start.fail
|
PGHA_REPLICA_REINIT_ON_START_FAIL
|
TRUE
|
pgha.pgbackrest
|
PGHA_PGBACKREST
|
TRUE
|
pgha.database
|
PGHA_DATABASE
|
$PG_DATABASE
|
pgha.user
|
PGHA_USER
|
$PG_USER
|
pgha.pg.port
|
PGHA_PG_PORT
|
$PG_PRIMARY_PORT
|
pgha.sync.replication
|
PGHA_SYNC_REPLICATION
|
FALSE
|
pgha.pgbackrest.initialize
|
PGHA_PGBACKREST_INITIALIZE
|
TRUE
|
patroni.log.level
|
PATRONI_LOG_LEVEL
|
INFO
|
