API tools faq
paste
Guest User

Postgresql Config

a guest
Jul 10th, 2021
83
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.32 KB | None | 0 0
raw download clone embed print report
  1. # FILE LOCATIONS
  2. #------------------------------------------------------------------------------
  3.  
  4. # The default values of these variables are driven from the -D command-line
  5. # option or PGDATA environment variable, represented here as ConfigDir.
  6.  
  7. data_directory = '/var/lib/postgresql/12/main' # use data in another directory
  8. # (change requires restart)
  9. hba_file = '/etc/postgresql/12/main/pg_hba.conf' # host-based authentication file
  10. # (change requires restart)
  11. ident_file = '/etc/postgresql/12/main/pg_ident.conf' # ident configuration file
  12. # (change requires restart)
  13.  
  14. # If external_pid_file is not explicitly set, no extra PID file is written.
  15. external_pid_file = '/var/run/postgresql/12-main.pid' # write an extra PID file
  16. # (change requires restart)
  17.  
  18.  
  19. #------------------------------------------------------------------------------
  20. # CONNECTIONS AND AUTHENTICATION
  21. #------------------------------------------------------------------------------
  22.  
  23. # - Connection Settings -
  24.  
  25. listen_addresses = '*' # what IP address(es) to listen on;
  26. # comma-separated list of addresses;
  27. # defaults to 'localhost'; use '*' for all
  28. # (change requires restart)
  29. port = 5432 # (change requires restart)
  30. max_connections = 200 # (change requires restart)
  31. superuser_reserved_connections = 3 # (change requires restart)
  32. unix_socket_directories = '/var/run/postgresql' # comma-separated list of directories
  33. # (change requires restart)
  34. #unix_socket_group = '' # (change requires restart)
  35. #unix_socket_permissions = 0777 # begin with 0 to use octal notation
  36. # (change requires restart)
  37. #bonjour = off # advertise server via Bonjour
  38. # (change requires restart)
  39. #bonjour_name = '' # defaults to the computer name
  40. # (change requires restart)
  41.  
  42. # - TCP settings -
  43. # see "man 7 tcp" for details
  44.  
  45. #tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds;
  46. # 0 selects the system default
  47. #tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds;
  48. # 0 selects the system default
  49. #tcp_keepalives_count = 0 # TCP_KEEPCNT;
  50. # 0 selects the system default
  51. #tcp_user_timeout = 0 # TCP_USER_TIMEOUT, in milliseconds;
  52. # 0 selects the system default
  53.  
  54. # - Authentication -
  55.  
  56. #authentication_timeout = 1min # 1s-600s
  57. #password_encryption = md5 # md5 or scram-sha-256
  58. #db_user_namespace = off
  59.  
  60. # GSSAPI using Kerberos
  61. #krb_server_keyfile = 'FILE:${sysconfdir}/krb5.keytab'
  62. #krb_caseins_users = off
  63.  
  64. # - SSL -
  65.  
  66. ssl = on
  67. #ssl_ca_file = ''
  68. ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem'
  69. #ssl_crl_file = ''
  70. ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key'
  71. #ssl_ciphers = 'HIGH:MEDIUM:+3DES:!aNULL' # allowed SSL ciphers
  72. #ssl_prefer_server_ciphers = on
  73. #ssl_ecdh_curve = 'prime256v1'
  74. #ssl_min_protocol_version = 'TLSv1'
  75. #ssl_max_protocol_version = ''
  76. #ssl_dh_params_file = ''
  77. #ssl_passphrase_command = ''
  78. #ssl_passphrase_command_supports_reload = off
  79.  
  80.  
  81. #------------------------------------------------------------------------------
  82. # RESOURCE USAGE (except WAL)
  83. #------------------------------------------------------------------------------
  84.  
  85. # - Memory -
  86.  
  87. shared_buffers = 24GB # min 128kB
  88. # (change requires restart)
  89. huge_pages = try # on, off, or try
  90. # (change requires restart)
  91. #temp_buffers = 8MB # min 800kB
  92. #max_prepared_transactions = 0 # zero disables the feature
  93. # (change requires restart)
  94. # Caution: it is not advisable to set max_prepared_transactions nonzero unless
  95. # you actively intend to use prepared transactions.
  96. work_mem = 983MB # min 64kB
  97. maintenance_work_mem = 2GB # min 1MB
  98. #autovacuum_work_mem = -1 # min 1MB, or -1 to use maintenance_work_mem
  99. #max_stack_depth = 2MB # min 100kB
  100. #shared_memory_type = mmap # the default is the first option
  101. # supported by the operating system:
  102. # mmap
  103. # sysv
  104. # windows
  105. # (change requires restart)
  106. dynamic_shared_memory_type = posix # the default is the first option
  107. # supported by the operating system:
  108. # posix
  109. # sysv
  110. # windows
  111. # mmap
  112. # (change requires restart)
  113.  
  114. # - Disk -
  115.  
  116. #temp_file_limit = -1 # limits per-process temp file space
  117. # in kB, or -1 for no limit
  118.  
  119. # - Kernel Resources -
  120.  
  121. #max_files_per_process = 1000 # min 25
  122. # (change requires restart)
  123.  
  124. # - Cost-Based Vacuum Delay -
  125.  
  126. #vacuum_cost_delay = 0 # 0-100 milliseconds (0 disables)
  127. #vacuum_cost_page_hit = 1 # 0-10000 credits
  128. #vacuum_cost_page_miss = 10 # 0-10000 credits
  129. #vacuum_cost_page_dirty = 20 # 0-10000 credits
  130. #vacuum_cost_limit = 200 # 1-10000 credits
  131.  
  132. # - Background Writer -
  133.  
  134. #bgwriter_delay = 200ms # 10-10000ms between rounds
  135. #bgwriter_lru_maxpages = 100 # max buffers written/round, 0 disables
  136. #bgwriter_lru_multiplier = 2.0 # 0-10.0 multiplier on buffers scanned/round
  137. #bgwriter_flush_after = 512kB # measured in pages, 0 disables
  138.  
  139. # - Asynchronous Behavior -
  140.  
  141. effective_io_concurrency = 200 # 1-1000; 0 disables prefetching
  142. max_worker_processes = 8 # (change requires restart)
  143. #max_parallel_maintenance_workers = 2 # taken from max_parallel_workers
  144. max_parallel_workers_per_gather = 4 # taken from max_parallel_workers
  145. #parallel_leader_participation = on
  146. max_parallel_workers = 8 # maximum number of max_worker_processes that
  147. # can be used in parallel operations
  148. #old_snapshot_threshold = -1 # 1min-60d; -1 disables; 0 is immediate
  149. # (change requires restart)
  150. #backend_flush_after = 0 # measured in pages, 0 disables
  151.  
  152.  
  153. #------------------------------------------------------------------------------
  154. # WRITE-AHEAD LOG
  155. #------------------------------------------------------------------------------
  156.  
  157. # - Settings -
  158.  
  159. #wal_level = replica # minimal, replica, or logical
  160. # (change requires restart)
  161. #fsync = on # flush data to disk for crash safety
  162. # (turning this off can cause
  163. # unrecoverable data corruption)
  164. #synchronous_commit = on # synchronization level;
  165. # off, local, remote_write, remote_apply, or on
  166. #wal_sync_method = fsync # the default is the first option
  167. # supported by the operating system:
  168. # open_datasync
  169. # fdatasync (default on Linux and FreeBSD)
  170. # fsync
  171. # fsync_writethrough
  172. # open_sync
  173. #full_page_writes = on # recover from partial page writes
  174. #wal_compression = off # enable compression of full-page writes
  175. #wal_log_hints = off # also do full page writes of non-critical updates
  176. # (change requires restart)
  177. #wal_init_zero = on # zero-fill new WAL files
  178. #wal_recycle = on # recycle WAL files
  179. wal_buffers = 16MB # min 32kB, -1 sets based on shared_buffers
  180. # (change requires restart)
  181. #wal_writer_delay = 200ms # 1-10000 milliseconds
  182. #wal_writer_flush_after = 1MB # measured in pages, 0 disables
  183.  
  184. #commit_delay = 0 # range 0-100000, in microseconds
  185. #commit_siblings = 5 # range 1-1000
  186.  
  187. # - Checkpoints -
  188.  
  189. #checkpoint_timeout = 5min # range 30s-1d
  190. max_wal_size = 3GB
  191. min_wal_size = 1GB
  192. checkpoint_completion_target = 0.9 # checkpoint target duration, 0.0 - 1.0
  193. #checkpoint_flush_after = 256kB # measured in pages, 0 disables
  194. #checkpoint_warning = 30s # 0 disables
  195.  
  196. # - Archiving -
  197.  
  198. #archive_mode = off # enables archiving; off, on, or always
  199. # (change requires restart)
  200. #archive_command = '' # command to use to archive a logfile segment
  201. # placeholders: %p = path of file to archive
  202. # %f = file name only
  203. # e.g. 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f'
  204. #archive_timeout = 0 # force a logfile segment switch after this
  205. # number of seconds; 0 disables
  206.  
  207. # - Archive Recovery -
  208.  
  209. # These are only used in recovery mode.
  210.  
  211. #restore_command = '' # command to use to restore an archived logfile segment
  212. # placeholders: %p = path of file to restore
  213. # %f = file name only
  214. # e.g. 'cp /mnt/server/archivedir/%f %p'
  215. # (change requires restart)
  216. #archive_cleanup_command = '' # command to execute at every restartpoint
  217. #recovery_end_command = '' # command to execute at completion of recovery
  218.  
  219. # - Recovery Target -
  220.  
  221. # Set these only when performing a targeted recovery.
  222.  
  223. #recovery_target = '' # 'immediate' to end recovery as soon as a
  224. # consistent state is reached
  225. # (change requires restart)
  226. #recovery_target_name = '' # the named restore point to which recovery will proceed
  227. # (change requires restart)
  228. #recovery_target_time = '' # the time stamp up to which recovery will proceed
  229. # (change requires restart)
  230. #recovery_target_xid = '' # the transaction ID up to which recovery will proceed
  231. # (change requires restart)
  232. #recovery_target_lsn = '' # the WAL LSN up to which recovery will proceed
  233. # (change requires restart)
  234. #recovery_target_inclusive = on # Specifies whether to stop:
  235. # just after the specified recovery target (on)
  236. # just before the recovery target (off)
  237. # (change requires restart)
  238. #recovery_target_timeline = 'latest' # 'current', 'latest', or timeline ID
  239. # (change requires restart)
  240. #recovery_target_action = 'pause' # 'pause', 'promote', 'shutdown'
  241. # (change requires restart)
  242.  
  243.  
  244. #------------------------------------------------------------------------------
  245. # REPLICATION
  246. #------------------------------------------------------------------------------
  247.  
  248. # - Sending Servers -
  249.  
  250. # Set these on the master and on any standby that will send replication data.
  251.  
  252. #max_wal_senders = 10 # max number of walsender processes
  253. # (change requires restart)
  254. #wal_keep_segments = 0 # in logfile segments; 0 disables
  255. #wal_sender_timeout = 60s # in milliseconds; 0 disables
  256.  
  257. #max_replication_slots = 10 # max number of replication slots
  258. # (change requires restart)
  259. #track_commit_timestamp = off # collect timestamp of transaction commit
  260. # (change requires restart)
  261.  
  262. # - Master Server -
  263.  
  264. # These settings are ignored on a standby server.
  265.  
  266. #synchronous_standby_names = '' # standby servers that provide sync rep
  267. # method to choose sync standbys, number of sync standbys,
  268. # and comma-separated list of application_name
  269. # from standby(s); '*' = all
  270. #vacuum_defer_cleanup_age = 0 # number of xacts by which cleanup is delayed
  271.  
  272. # - Standby Servers -
  273.  
  274. # These settings are ignored on a master server.
  275.  
  276. #primary_conninfo = '' # connection string to sending server
  277. # (change requires restart)
  278. #primary_slot_name = '' # replication slot on sending server
  279. # (change requires restart)
  280. #promote_trigger_file = '' # file name whose presence ends recovery
  281. #hot_standby = on # "off" disallows queries during recovery
  282. # (change requires restart)
  283. #max_standby_archive_delay = 30s # max delay before canceling queries
  284. # when reading WAL from archive;
  285. # -1 allows indefinite delay
  286. #max_standby_streaming_delay = 30s # max delay before canceling queries
  287. # when reading streaming WAL;
  288. # -1 allows indefinite delay
  289. #wal_receiver_status_interval = 10s # send replies at least this often
  290. # 0 disables
  291. #hot_standby_feedback = off # send info from standby to prevent
  292. # query conflicts
  293. #wal_receiver_timeout = 60s # time that receiver waits for
  294. # communication from master
  295. # in milliseconds; 0 disables
  296. #wal_retrieve_retry_interval = 5s # time to wait before retrying to
  297. # retrieve WAL after a failed attempt
  298. #recovery_min_apply_delay = 0 # minimum delay for applying changes during recovery
  299.  
  300. # - Subscribers -
  301.  
  302. # These settings are ignored on a publisher.
  303.  
  304. #max_logical_replication_workers = 4 # taken from max_worker_processes
  305. # (change requires restart)
  306. #max_sync_workers_per_subscription = 2 # taken from max_logical_replication_workers
  307.  
  308.  
  309. #------------------------------------------------------------------------------
  310. # QUERY TUNING
  311. #------------------------------------------------------------------------------
  312.  
  313. # - Planner Method Configuration -
  314.  
  315. #enable_bitmapscan = on
  316. #enable_hashagg = on
  317. #enable_hashjoin = on
  318. #enable_indexscan = on
  319. #enable_indexonlyscan = on
  320. #enable_material = on
  321. #enable_mergejoin = on
  322. #enable_nestloop = on
  323. #enable_parallel_append = on
  324. #enable_seqscan = on
  325. #enable_sort = on
  326. #enable_tidscan = on
  327. enable_partitionwise_join = on
  328. enable_partitionwise_aggregate = on
  329. #enable_parallel_hash = on
  330. #enable_partition_pruning = on
  331.  
  332. # - Planner Cost Constants -
  333.  
  334. #seq_page_cost = 1.1 # measured on an arbitrary scale
  335. random_page_cost = 1.1 # same scale as above
  336. #cpu_tuple_cost = 0.01 # same scale as above
  337. #cpu_index_tuple_cost = 0.005 # same scale as above
  338. #cpu_operator_cost = 0.0025 # same scale as above
  339. #parallel_tuple_cost = 0.1 # same scale as above
  340. #parallel_setup_cost = 1000.0 # same scale as above
  341.  
  342. #jit_above_cost = 100000 # perform JIT compilation if available
  343. # and query more expensive than this;
  344. # -1 disables
  345. #jit_inline_above_cost = 500000 # inline small functions if query is
  346. # more expensive than this; -1 disables
  347. #jit_optimize_above_cost = 500000 # use expensive JIT optimizations if
  348. # query is more expensive than this;
  349. # -1 disables
  350.  
  351. #min_parallel_table_scan_size = 8MB
  352. #min_parallel_index_scan_size = 512kB
  353. effective_cache_size = 72GB
  354.  
  355. # - Genetic Query Optimizer -
  356.  
  357. #geqo = on
  358. #geqo_threshold = 12
  359. #geqo_effort = 5 # range 1-10
  360. #geqo_pool_size = 0 # selects default based on effort
  361. #geqo_generations = 0 # selects default based on effort
  362. #geqo_selection_bias = 2.0 # range 1.5-2.0
  363. #geqo_seed = 0.0 # range 0.0-1.0
  364.  
  365. # - Other Planner Options -
  366.  
  367. default_statistics_target = 100 # range 1-10000
  368. #constraint_exclusion = partition # on, off, or partition
  369. #cursor_tuple_fraction = 0.1 # range 0.0-1.0
  370. #from_collapse_limit = 8
  371. #join_collapse_limit = 8 # 1 disables collapsing of explicit
  372. # JOIN clauses
  373. #force_parallel_mode = off
  374. #jit = on # allow JIT compilation
  375. #plan_cache_mode = auto # auto, force_generic_plan or
  376. # force_custom_plan
  377.  
  378.  
  379. #------------------------------------------------------------------------------
  380. # REPORTING AND LOGGING
  381. #------------------------------------------------------------------------------
  382.  
  383. # - Where to Log -
  384.  
  385. #log_destination = 'stderr' # Valid values are combinations of
  386. # stderr, csvlog, syslog, and eventlog,
  387. # depending on platform. csvlog
  388. # requires logging_collector to be on.
  389.  
  390. # This is used when logging to stderr:
  391. logging_collector = on # Enable capturing of stderr and csvlog
  392. # into log files. Required to be on for
  393. # csvlogs.
  394. # (change requires restart)
  395.  
  396. # These are only used if logging_collector is on:
  397. log_directory = '/var/log/postgresql/queries' # directory where log files are written,
  398. # can be absolute or relative to PGDATA
  399. #log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern,
  400. # can include strftime() escapes
  401. log_file_mode = 0640 # creation mode for log files,
  402. # begin with 0 to use octal notation
  403. #log_truncate_on_rotation = off # If on, an existing log file with the
  404. # same name as the new log file will be
  405. # truncated rather than appended to.
  406. # But such truncation only occurs on
  407. # time-driven rotation, not on restarts
  408. # or size-driven rotation. Default is
  409. # off, meaning append to existing files
  410. # in all cases.
  411. #log_rotation_age = 1d # Automatic rotation of logfiles will
  412. # happen after that time. 0 disables.
  413. log_rotation_size = 100MB # Automatic rotation of logfiles will
  414. # happen after that much log output.
  415. # 0 disables.
  416.  
  417. # These are relevant when logging to syslog:
  418. #syslog_facility = 'LOCAL0'
  419. #syslog_ident = 'postgres'
  420. #syslog_sequence_numbers = on
  421. #syslog_split_messages = on
  422.  
  423. # This is only relevant when logging to eventlog (win32):
  424. # (change requires restart)
  425. #event_source = 'PostgreSQL'
  426.  
  427. # - When to Log -
  428.  
  429. #log_min_messages = warning # values in order of decreasing detail:
  430. # debug5
  431. # debug4
  432. # debug3
  433. # debug2
  434. # debug1
  435. # info
  436. # notice
  437. # warning
  438. # error
  439. # log
  440. # fatal
  441. # panic
  442.  
  443. #log_min_error_statement = error # values in order of decreasing detail:
  444. # debug5
  445. # debug4
  446. # debug3
  447. # debug2
  448. # debug1
  449. # info
  450. # notice
  451. # warning
  452. # error
  453. # log
  454. # fatal
  455. # panic (effectively off)
  456.  
  457. log_min_duration_statement = 1000 # -1 is disabled, 0 logs all statements
  458. # and their durations, > 0 logs only
  459. # statements running at least this number
  460. # of milliseconds
  461.  
  462. #log_transaction_sample_rate = 0.0 # Fraction of transactions whose statements
  463. # are logged regardless of their duration. 1.0 logs all
  464. # statements from all transactions, 0.0 never logs.
  465.  
  466. # - What to Log -
  467.  
  468. #debug_print_parse = off
  469. #debug_print_rewritten = off
  470. #debug_print_plan = off
  471. #debug_pretty_print = on
  472. log_checkpoints = on
  473. log_connections = on
  474. log_disconnections = on
  475. #log_duration = off
  476. log_error_verbosity = default # terse, default, or verbose messages
  477. #log_hostname = off
  478. log_line_prefix = '%m [%p] %q%u@%d ' # special values:
  479. # %a = application name
  480. # %u = user name
  481. # %d = database name
  482. # %r = remote host and port
  483. # %h = remote host
  484. # %p = process ID
  485. # %t = timestamp without milliseconds
  486. # %m = timestamp with milliseconds
  487. # %n = timestamp with milliseconds (as a Unix epoch)
  488. # %i = command tag
  489. # %e = SQL state
  490. # %c = session ID
  491. # %l = session line number
  492. # %s = session start timestamp
  493. # %v = virtual transaction ID
  494. # %x = transaction ID (0 if none)
  495. # %q = stop here in non-session
  496. # processes
  497. # %% = '%'
  498. # e.g. '<%u%%%d> '
  499. log_lock_waits = on # log lock waits >= deadlock_timeout
  500. #log_statement = 'none' # none, ddl, mod, all
  501. #log_replication_commands = off
  502. log_temp_files = 0 # log temporary files equal or larger
  503. # than the specified size in kilobytes;
  504. # -1 disables, 0 logs all temp files
  505. log_timezone = 'Europe/Brussels'
  506.  
  507. #------------------------------------------------------------------------------
  508. # PROCESS TITLE
  509. #------------------------------------------------------------------------------
  510.  
  511. cluster_name = '12/main' # added to process titles if nonempty
  512. # (change requires restart)
  513. #update_process_title = on
  514.  
  515.  
  516. #------------------------------------------------------------------------------
  517. # STATISTICS
  518. #------------------------------------------------------------------------------
  519.  
  520. # - Query and Index Statistics Collector -
  521.  
  522. #track_activities = on
  523. #track_counts = on
  524. #track_io_timing = off
  525. #track_functions = none # none, pl, all
  526. #track_activity_query_size = 1024 # (change requires restart)
  527. stats_temp_directory = '/var/run/postgresql/12-main.pg_stat_tmp'
  528.  
  529.  
  530. # - Monitoring -
  531.  
  532. #log_parser_stats = off
  533. #log_planner_stats = off
  534. #log_executor_stats = off
  535. #log_statement_stats = off
  536.  
  537.  
  538. #------------------------------------------------------------------------------
  539. # AUTOVACUUM
  540. #------------------------------------------------------------------------------
  541.  
  542. #autovacuum = on # Enable autovacuum subprocess? 'on'
  543. # requires track_counts to also be on.
  544. log_autovacuum_min_duration = 0 # -1 disables, 0 logs all actions and
  545. # their durations, > 0 logs only
  546. # actions running at least this number
  547. # of milliseconds.
  548. #autovacuum_max_workers = 3 # max number of autovacuum subprocesses
  549. # (change requires restart)
  550. #autovacuum_naptime = 1min # time between autovacuum runs
  551. #autovacuum_vacuum_threshold = 50 # min number of row updates before
  552. # vacuum
  553. #autovacuum_analyze_threshold = 50 # min number of row updates before
  554. # analyze
  555. #autovacuum_vacuum_scale_factor = 0.2 # fraction of table size before vacuum
  556. #autovacuum_analyze_scale_factor = 0.1 # fraction of table size before analyze
  557. #autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum
  558. # (change requires restart)
  559. #autovacuum_multixact_freeze_max_age = 400000000 # maximum multixact age
  560. # before forced vacuum
  561. # (change requires restart)
  562. #autovacuum_vacuum_cost_delay = 2ms # default vacuum cost delay for
  563. # autovacuum, in milliseconds;
  564. # -1 means use vacuum_cost_delay
  565. #autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for
  566. # autovacuum, -1 means use
  567. # vacuum_cost_limit
  568.  
  569.  
  570. #------------------------------------------------------------------------------
  571. # CLIENT CONNECTION DEFAULTS
  572. #------------------------------------------------------------------------------
  573.  
  574. # - Statement Behavior -
  575.  
  576. #client_min_messages = notice # values in order of decreasing detail:
  577. # debug5
  578. # debug4
  579. # debug3
  580. # debug2
  581. # debug1
  582. # log
  583. # notice
  584. # warning
  585. # error
  586. #search_path = '"$user", public' # schema names
  587. #row_security = on
  588. #default_tablespace = '' # a tablespace name, '' uses the default
  589. #temp_tablespaces = '' # a list of tablespace names, '' uses
  590. # only default tablespace
  591. #default_table_access_method = 'heap'
  592. #check_function_bodies = on
  593. #default_transaction_isolation = 'read committed'
  594. #default_transaction_read_only = off
  595. #default_transaction_deferrable = off
  596. #session_replication_role = 'origin'
  597. #statement_timeout = 0 # in milliseconds, 0 is disabled
  598. #lock_timeout = 0 # in milliseconds, 0 is disabled
  599. #idle_in_transaction_session_timeout = 0 # in milliseconds, 0 is disabled
  600. #vacuum_freeze_min_age = 50000000
  601. #vacuum_freeze_table_age = 150000000
  602. #vacuum_multixact_freeze_min_age = 5000000
  603. #vacuum_multixact_freeze_table_age = 150000000
  604. #vacuum_cleanup_index_scale_factor = 0.1 # fraction of total number of tuples
  605. # before index cleanup, 0 always performs
  606. # index cleanup
  607. #bytea_output = 'hex' # hex, escape
  608. #xmlbinary = 'base64'
  609. #xmloption = 'content'
  610. #gin_fuzzy_search_limit = 0
  611. #gin_pending_list_limit = 4MB
  612.  
  613. # - Locale and Formatting -
  614.  
  615. datestyle = 'iso, mdy'
  616. #intervalstyle = 'postgres'
  617. timezone = 'Europe/Brussels'
  618. #timezone_abbreviations = 'Default' # Select the set of available time zone
  619. # abbreviations. Currently, there are
  620. # Default
  621. # Australia (historical usage)
  622. # India
  623. # You can create your own file in
  624. # share/timezonesets/.
  625. #extra_float_digits = 1 # min -15, max 3; any value >0 actually
  626. # selects precise output mode
  627. #client_encoding = sql_ascii # actually, defaults to database
  628. # encoding
  629.  
  630. # These settings are initialized by initdb, but they can be changed.
  631. lc_messages = 'en_US.UTF-8' # locale for system error message
  632. lc_messages = 'C' # strings
  633. lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
  634. lc_numeric = 'en_US.UTF-8' # locale for number formatting
  635. lc_time = 'en_US.UTF-8' # locale for time formatting
  636.  
  637. # default configuration for text search
  638. default_text_search_config = 'pg_catalog.english'
  639.  
  640. # - Shared Library Preloading -
  641.  
  642. #shared_preload_libraries = '' # (change requires restart)
  643. #local_preload_libraries = ''
  644. #session_preload_libraries = ''
  645. #jit_provider = 'llvmjit' # JIT library to use
  646.  
  647. # - Other Defaults -
  648.  
  649. #dynamic_library_path = '$libdir'
  650. #extension_destdir = '' # prepend path when loading extensions
  651. # and shared objects (added by Debian)
  652.  
  653.  
  654. #------------------------------------------------------------------------------
  655. # LOCK MANAGEMENT
  656. #------------------------------------------------------------------------------
  657.  
  658. #deadlock_timeout = 1s
  659. #max_locks_per_transaction = 64 # min 10
  660. # (change requires restart)
  661. #max_pred_locks_per_transaction = 64 # min 10
  662. # (change requires restart)
  663. #max_pred_locks_per_relation = -2 # negative values mean
  664. # (max_pred_locks_per_transaction
  665. # / -max_pred_locks_per_relation) - 1
  666. #max_pred_locks_per_page = 2 # min 0
  667.  
  668.  
  669. #------------------------------------------------------------------------------
  670. # VERSION AND PLATFORM COMPATIBILITY
  671. #------------------------------------------------------------------------------
  672.  
  673. # - Previous PostgreSQL Versions -
  674.  
  675. #array_nulls = on
  676. #backslash_quote = safe_encoding # on, off, or safe_encoding
  677. #escape_string_warning = on
  678. #lo_compat_privileges = off
  679. #operator_precedence_warning = off
  680. #quote_all_identifiers = off
  681. #standard_conforming_strings = on
  682. #synchronize_seqscans = on
  683.  
  684. # - Other Platforms and Clients -
  685.  
  686. #transform_null_equals = off
  687.  
  688.  
  689. #------------------------------------------------------------------------------
  690. # ERROR HANDLING
  691. #------------------------------------------------------------------------------
  692.  
  693. #exit_on_error = off # terminate session on any error?
  694. #restart_after_crash = on # reinitialize after backend crash?
  695. #data_sync_retry = off # retry or panic on failure to fsync
  696. # data?
  697. # (change requires restart)
  698.  
  699.  
  700. #------------------------------------------------------------------------------
  701. # CONFIG FILE INCLUDES
  702. #------------------------------------------------------------------------------
  703.  
  704. # These options allow settings to be loaded from files other than the
  705. # default postgresql.conf. Note that these are directives, not variable
  706. # assignments, so they can usefully be given more than once.
  707.  
  708. include_dir = 'conf.d' # include files ending in '.conf' from
  709. # a directory, e.g., 'conf.d'
  710. #include_if_exists = '...' # include file only if it exists
  711. #include = '...' # include file
  712.  
  713.  
  714. #------------------------------------------------------------------------------
  715. # CUSTOMIZED OPTIONS
  716. #------------------------------------------------------------------------------
  717.  
  718. # Add settings for extensions here
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!