SHARE
TWEET

Untitled

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