Skip to main content

Allowed configurations

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_cron
  • pglogical
  • orafce
  • plprofiler
  • pgaudit

In addition to these values, there are some extensions built into the Vanilla PostgreSQL installation.
For example:
  • pg_stat_statements
  • auto_explain
  • pg_prewarm
  • postgres_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

note

After updating the following application configuration parameters, within a PostgreSQL deployment, be sure to restart them:

  • autovacuum_max_workers
  • hot_standby
  • logging_collector
  • max_connections
  • max_wal_senders
  • shared_buffers
  • shared_preload_libraries
  • wal_buffers
  • wal_decode_buffer_size
  • wal_level
Was this page helpful?