PostgreSQL Server Exporter
PostgreSQL Server Exporter 允许您导出各种 PostgreSQL 指标。
对于从源安装实例,您必须自己安装和配置它。
要启用 PostgreSQL Server Exporter:
- 启用 Prometheus。
-
编辑
/etc/gitlab/gitlab.rb
并启用postgres_exporter
:postgres_exporter['enable'] = true
如果 PostgreSQL Server Exporter 配置在单独的节点上,请确保本地地址列在
trust_auth_cidr_addresses
中,否则 Exporter 无法连接到数据库。 - 保存文件并重新配置极狐GitLab,使更改生效。
Prometheus 开始从 localhost:9187
下暴露的 PostgreSQL Server Exporter 收集性能数据。
高级配置
在大多数情况下,PostgreSQL Server Exporter 使用默认值,您不需要更改任何内容。要进一步自定义,请使用以下配置选项:
-
编辑
/etc/gitlab/gitlab.rb
:# The name of the database to connect to. postgres_exporter['dbname'] = 'pgbouncer' # The user to sign in as. postgres_exporter['user'] = 'gitlab-psql' # The user's password. postgres_exporter['password'] = '' # The host to connect to. Values that start with '/' are for unix domain sockets # (default is 'localhost'). postgres_exporter['host'] = 'localhost' # The port to bind to (default is '5432'). postgres_exporter['port'] = 5432 # Whether or not to use SSL. Valid options are: # 'disable' (no SSL), # 'require' (always use SSL and skip verification, this is the default value), # 'verify-ca' (always use SSL and verify that the certificate presented by # the server was signed by a trusted CA), # 'verify-full' (always use SSL and verify that the certification presented # by the server was signed by a trusted CA and the server host name matches # the one in the certificate). postgres_exporter['sslmode'] = 'require' # An application_name to fall back to if one isn't provided. postgres_exporter['fallback_application_name'] = '' # Maximum wait for connection, in seconds. Zero or not specified means wait indefinitely. postgres_exporter['connect_timeout'] = '' # Cert file location. The file must contain PEM encoded data. postgres_exporter['sslcert'] = 'ssl.crt' # Key file location. The file must contain PEM encoded data. postgres_exporter['sslkey'] = 'ssl.key' # The location of the root certificate file. The file must contain PEM encoded data. postgres_exporter['sslrootcert'] = 'ssl-root.crt'
-
保存文件并重新配置极狐GitLab,使更改生效。