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
| SHARED_PRELOAD_LIBRARIES can
have multiple values, separated by
commas.
pg_cronpglogicalorafceplprofilerpgaudit
In addition to these values, there are some extensions built into the Vanilla PostgreSQL installation.
For example:
pg_stat_statementsauto_explainpg_prewarmpostgres_fdw
For the complete list of values, refer
to the PostgreSQL documentation. |
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
|
cron.database_name
| CRON_DATABASE_NAME
| pds
|
checkpoint_timeout
| CHECKPOINT_TIMEOUT
| 300
|
max_slot_wal_keep_size (v13+)
| MAX_SLOT_WAL_KEEP_SIZE
| -1
|
max_wal_size
| MAX_WAL_SIZE
| 1GB
|
full_page_writes
| FULL_PAGE_WRITES
| on
|
checkpoint_warning
| CHECKPOINT_WARNING
| 30
|
checkpoint_flush_after
| CHECKPOINT_FLUSH_AFTER
| 256KB
|
wal_keep_size (v13+)
| WAL_KEEP_SIZE
| 0
|
wal_buffers
| WAL_BUFFERS
| -1
|
commit_delay
| COMMIT_DELAY
| 0
|
fsync
| FSYNC
| on
|
commit_siblings
| COMMIT_SIBLINGS
| 5
|
wal_sync_method
| WAL_SYNC_METHOD
| fdatasync
|
track_wal_io_timing (v14+)
| TRACK_WAL_IO_TIMING
| off
|
recovery_prefetch (v15+)
| RECOVERY_PREFETCH
| try
|
maintenance_io_concurrency (v13+)
| MAINTENANCE_IO_CONCURRENCY
| 10
|
wal_decode_buffer_size (v15+)
| WAL_DECODE_BUFFER_SIZE
| 512KB
|