API tools faq
paste
Advertisement
Guest User

Untitled

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