Server configuration | Environment variable | PDS default value | Restart required? |
archive_mode
| ARCHIVE_MODE
| on
| Yes
|
archive_timeout
| ARCHIVE_TIMEOUT
| 60
| No
|
autovacuum
| AUTOVACUUM
| on
| No
|
autovacuum_analyze_threshold
| AUTOVACUUM_ANALYZE_THRESHOLD
| 1000
| No
|
autovacuum_max_workers
| AUTOVACUUM_MAX_WORKERS
| 5
| Yes
|
autovacuum_vacuum_cost_delay
| AUTOVACUUM_VACUUM_COST_DELAY
| -1
| No
|
autovacuum_vacuum_scale_factor
| AUTOVACUUM_VACUUM_SCALE_FACTOR
| 0.01
| No
|
autovacuum_vacuum_threshold
| AUTOVACUUM_VACUUM_THRESHOLD
| 1000
| No
|
checkpoint_completion_target
| CHECKPOINT_COMPLETION_TARGET
| 0.9
| No
|
checkpoint_flush_after
| CHECKPOINT_FLUSH_AFTER
| 32 (256KB)
| No
|
checkpoint_timeout
| CHECKPOINT_TIMEOUT
| 300
| No
|
checkpoint_warning
| CHECKPOINT_WARNING
| 30
| No
|
commit_delay
| COMMIT_DELAY
| 0
| No
|
commit_siblings
| COMMIT_SIBLINGS
| 5
| No
|
cron.database_name
| CRON_DATABASE_NAME
| pds
| No
|
datestyle
| DATESTYLE
| iso, mdy
| No
|
default_text_search_config
| DEFAULT_TEXT_SEARCH_CONFIG
| pg_catalog.english
| No
|
effective_cache_size
| EFFECTIVE_CACHE_SIZE
| 10240MB
| No
|
fsync
| FSYNC
| on
| No
|
full_page_writes
| FULL_PAGE_WRITES
| on
| No
|
hot_standby
| HOT_STANDBY
| on
| Yes
|
lc_messages
| LC_MESSAGES
| en_US.UTF-8
| No
|
lc_monetary
| LC_MONETARY
| en_US.UTF-8
| No
|
lc_numeric
| LC_NUMERIC
| en_US.UTF-8
| No
|
lc_time
| LC_TIME
| en_US.UTF-8
| No
|
log_autovacuum_min_duration
| LOG_AUTOVACUUM_MIN_DURATION
| 0
| No
|
log_destination
| LOG_DESTINATION
| stderr
| No
|
log_directory
| LOG_DIRECTORY
| pg_log
| Yes
|
log_filename
| LOG_FILENAME
| postgresql-%a.log
| No
|
log_line_prefix
| LOG_LINE_PREFIX
| postgres %m [%p] %q(%u@%d/%a)
| No
|
log_lock_waits
| LOG_LOCK_WAITS
| on
| No
|
log_min_duration_statement
| LOG_MIN_DURATION_STATEMENT
| 60000
| No
|
log_rotation_age
| LOG_ROTATION_AGE
| 1d
| No
|
log_rotation_size
| LOG_ROTATION_SIZE
| 0
| No
|
log_statement
| LOG_STATEMENT
| none
| No
|
log_timezone
| LOG_TIMEZONE
| UTC
| No
|
log_truncate_on_rotation
| LOG_TRUNCATE_ON_ROTATION
| on
| No
|
logging_collector
| LOGGING_COLLECTOR
| off
| Yes
|
maintenance_io_concurrency (v13+)
| MAINTENANCE_IO_CONCURRENCY
| 10
| No
|
maintenance_work_mem
| MAINTENANCE_WORK_MEM
| 4000MB
| No
|
max_connections
| MAX_CONNECTIONS
| 200
| Yes
|
max_slot_wal_keep_size
| MAX_SLOT_WAL_KEEP_SIZE
| -1
| No
|
max_wal_senders
| MAX_WAL_SENDERS
| 10
| Yes
|
max_wal_size
| MAX_WAL_SIZE
| 1GB
| No
|
patroni_log_level
| PATRONI_LOG_LEVEL
| INFO
| Yes
|
pg_database
| PG_DATABASE
| pds
| Only during Init time
|
pg_stat_statements.max
| PG_STAT_STATEMENTS_MAX
| 1000
| No
|
| pg_stat_statements.save | PG_STAT_STATEMENTS_SAVE | on | no |
pg_stat_statements.track
| PG_STAT_STATEMENTS_TRACK
| all
| No
|
| pg_stat_statements.track_planning | PG_STAT_STATEMENTS_TRACK_PLANNING | off | no |
| pg_stat_statements.track_utility | PG_STAT_STATEMENTS_TRACK_UTILITY | on | no |
PGHA_REPLICA_REINIT_ON_START_FAIL
| PGHA_REPLICA_REINIT_ON_START_FAIL
| true (case sensitive)
| Yes
|
PGHA_SYNC_REPLICATION
| PGHA_SYNC_REPLICATION
| false (case sensitive)
| Yes
|
pglogical.conflict_resolution
| PGLOGICAL_CONFLICT_RESOLUTION
| apply_remote
| No
|
random_page_cost
| RANDOM_PAGE_COST
| 1.5
| No
|
recovery_prefetch (v15+)
| RECOVERY_PREFETCH
| try
| No
|
shared_buffers
| SHARED_BUFFERS
| 128MB
| Yes
|
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. | Yes
|
standard_conforming_strings
| STANDARD_CONFORMING_STRINGS
| on
| No
|
temp_buffers
| TEMP_BUFFERS
| 8MB
| No
|
timezone
| TIMEZONE
| UTC
| No
|
| track_activities | TRACK_ACTIVITIES | on | no |
| track_activity_query_size | TRACK_ACTIVITY_QUERY_SIZE | 1024 | no |
| track_commit_timestamp | TRACK_COMMIT_TIMESTAMP | off | no |
track_counts
| TRACK_COUNTS
| on
| No
|
| track_functions | TRACK_FUNCTIONS | none | no |
| track_io_timing | TRACK_IO_TIMING | off | no |
| track_wal_io_timing | TRACK_WAL_IO_TIMING | off | no |
use_slots
| USE_SLOTS
| FALSE
| Yes
|
vacuum_cost_delay
| VACUUM_COST_DELAY
| 10ms
| No
|
wal_buffers
| WAL_BUFFERS
| -1
| Yes
|
wal_decode_buffer_size (v15+)
| WAL_DECODE_BUFFER_SIZE
| 512KB
| Yes
|
wal_keep_size
| WAL_KEEP_SIZE
| 0
| No
|
wal_level
| WAL_LEVEL
| replica
| Yes
|
wal_sync_method
| WAL_SYNC_METHOD
| fdatasync
| No
|
work_mem
| WORK_MEM
| 32MB
| No
|