postgres.conf 4.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134
  1. # netdata python.d.plugin configuration for postgresql
  2. #
  3. # This file is in YaML format. Generally the format is:
  4. #
  5. # name: value
  6. #
  7. # There are 2 sections:
  8. # - global variables
  9. # - one or more JOBS
  10. #
  11. # JOBS allow you to collect values from multiple sources.
  12. # Each source will have its own set of charts.
  13. #
  14. # JOB parameters have to be indented (using spaces only, example below).
  15. # ----------------------------------------------------------------------
  16. # Global Variables
  17. # These variables set the defaults for all JOBs, however each JOB
  18. # may define its own, overriding the defaults.
  19. # update_every sets the default data collection frequency.
  20. # If unset, the python.d.plugin default is used.
  21. # update_every: 1
  22. # priority controls the order of charts at the netdata dashboard.
  23. # Lower numbers move the charts towards the top of the page.
  24. # If unset, the default for python.d.plugin is used.
  25. # priority: 60000
  26. # penalty indicates whether to apply penalty to update_every in case of failures.
  27. # Penalty will increase every 5 failed updates in a row. Maximum penalty is 10 minutes.
  28. # penalty: yes
  29. # autodetection_retry sets the job re-check interval in seconds.
  30. # The job is not deleted if check fails.
  31. # Attempts to start the job are made once every autodetection_retry.
  32. # This feature is disabled by default.
  33. # autodetection_retry: 0
  34. # ----------------------------------------------------------------------
  35. # JOBS (data collection sources)
  36. #
  37. # The default JOBS share the same *name*. JOBS with the same name
  38. # are mutually exclusive. Only one of them will be allowed running at
  39. # any time. This allows autodetection to try several alternatives and
  40. # pick the one that works.
  41. #
  42. # Any number of jobs is supported.
  43. #
  44. # All python.d.plugin JOBS (for all its modules) support a set of
  45. # predefined parameters. These are:
  46. #
  47. # job_name:
  48. # name: myname # the JOB's name as it will appear at the
  49. # # dashboard (by default is the job_name)
  50. # # JOBs sharing a name are mutually exclusive
  51. # update_every: 1 # the JOB's data collection frequency
  52. # priority: 60000 # the JOB's order on the dashboard
  53. # penalty: yes # the JOB's penalty
  54. # autodetection_retry: 0 # the JOB's re-check interval in seconds
  55. #
  56. # A single connection is required in order to pull statistics.
  57. #
  58. # Connections can be configured with the following options:
  59. #
  60. # dsn : 'connection URI' # see https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING
  61. #
  62. # OR
  63. #
  64. # database : 'example_db_name'
  65. # user : 'example_user'
  66. # password : 'example_pass'
  67. # host : 'localhost'
  68. # port : 5432
  69. # connect_timeout : 2 # in seconds, default is 2
  70. # statement_timeout : 2000 # in ms, default is 2000
  71. # sslmode : mode # one of [disable, allow, prefer, require, verify-ca, verify-full]
  72. # sslrootcert : path/to/rootcert # the location of the root certificate file
  73. # sslcrl : path/to/crl # the location of the CRL file
  74. # sslcert : path/to/cert # the location of the client certificate file
  75. # sslkey : path/to/key # the location of the client key file
  76. #
  77. # SSL connection parameters description: https://www.postgresql.org/docs/current/libpq-ssl.html
  78. #
  79. # Additionally, the following options allow selective disabling of charts
  80. #
  81. # table_stats : false
  82. # index_stats : false
  83. # database_poll : 'dbase_name1 dbase_name2' # poll only specified databases (all other will be excluded from charts)
  84. #
  85. # Postgres permissions are configured at its pg_hba.conf file. You can
  86. # "trust" local clients to allow netdata to connect, or you can create
  87. # a postgres user for netdata and add its password below to allow
  88. # netdata connect.
  89. #
  90. # Postgres supported versions are :
  91. # - 9.3 (without autovacuum)
  92. # - 9.4
  93. # - 9.5
  94. # - 9.6
  95. # - 10
  96. #
  97. # Superuser access is needed for theses charts:
  98. # Write-Ahead Logs
  99. # Archive Write-Ahead Logs
  100. #
  101. # Autovacuum charts is allowed since Postgres 9.4
  102. # ----------------------------------------------------------------------
  103. socket:
  104. name : 'local'
  105. user : 'postgres'
  106. database : 'postgres'
  107. tcp:
  108. name : 'local'
  109. database : 'postgres'
  110. user : 'postgres'
  111. host : 'localhost'
  112. port : 5432
  113. tcpipv4:
  114. name : 'local'
  115. database : 'postgres'
  116. user : 'postgres'
  117. host : '127.0.0.1'
  118. port : 5432
  119. tcpipv6:
  120. name : 'local'
  121. database : 'postgres'
  122. user : 'postgres'
  123. host : '::1'
  124. port : 5432