PostgreSQL


Server Configurations Environment Variables PDS default values

max.connections

MAX_CONNECTIONS

200

shared.buffers

SHARED_BUFFERS

6000MB

vacuum.cost.delay

VACUUM_COST_DELAY

10ms

wal.level

WAL_LEVEL

hot_standby

max.wal.senders

MAX_WAL_SENDERS

6

effective.cache.size

EFFECTIVE_CACHE_SIZE

hot_standby

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

%t [%p]: [%l-1] user=%u,db=%d,app=%a,client=%h

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

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

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



Last edited: Tuesday, Aug 30, 2022