postgresql - Docker是否与PostgreSQL和Prometheus PostgreSQL Exporter拒绝连接？

我正在尝试解决有关将PostgreSQL导出到Prometheus(https://github.com/wrouesnel/postgres_exporter)，Prometheus PostgreSQL server exporter example not working on MacOS?的问题，运行连接到用户定义的桥接网络而不是主机网络的postgres和postgres_exporter容器，这似乎不适用于Mac的Docker桌面。我创建了以下docker-compose.yml:

version: "3"
services:
  db:
    image: postgres
    environment:
      POSTGRES_PASSWORD: mypassword
    networks:
      - mynetwork

  exporter:
    image: wrouesnel/postgres_exporter
    environment:
      DATA_SOURCE_NAME: "postgresql://postgres:mypassword@db:5432/postgres?sslmode=disable"
    ports:
      - "9187:9187"
    networks:
      - mynetwork

networks:
  mynetwork:

但是，我对此有两个问题。首先，来自exporter服务的日志显示以下错误消息:



这是完整的输出:

> docker-compose up
Creating network "postgres-performance-testing_mynetwork" with the default driver
Creating postgres-performance-testing_db_1       ... done
Creating postgres-performance-testing_exporter_1 ... done
Attaching to postgres-performance-testing_db_1, postgres-performance-testing_exporter_1
exporter_1  | time="2019-10-03T20:16:56Z" level=info msg="Established new database connection to \"db:5432\"." source="postgres_exporter.go:778"
exporter_1  | time="2019-10-03T20:16:56Z" level=error msg="Error opening connection to database (postgresql://postgres:PASSWORD_REMOVED@db:5432/postgres?sslmode=disable): dial tcp 172.18.0.2:5432: connect: connection refused" source="postgres_exporter.go:1348"
exporter_1  | time="2019-10-03T20:16:56Z" level=info msg="Starting Server: :9187" source="postgres_exporter.go:1459"
db_1        | The files belonging to this database system will be owned by user "postgres".
db_1        | This user must also own the server process.
db_1        |
db_1        | The database cluster will be initialized with locale "en_US.utf8".
db_1        | The default database encoding has accordingly been set to "UTF8".
db_1        | The default text search configuration will be set to "english".
db_1        |
db_1        | Data page checksums are disabled.
db_1        |
db_1        | fixing permissions on existing directory /var/lib/postgresql/data ... ok
db_1        | creating subdirectories ... ok
db_1        | selecting default max_connections ... 100
db_1        | selecting default shared_buffers ... 128MB
db_1        | selecting default timezone ... Etc/UTC
db_1        | selecting dynamic shared memory implementation ... posix
db_1        | creating configuration files ... ok
db_1        | running bootstrap script ... ok
db_1        | performing post-bootstrap initialization ... ok
db_1        | syncing data to disk ... ok
db_1        |
db_1        | Success. You can now start the database server using:
db_1        |
db_1        |     pg_ctl -D /var/lib/postgresql/data -l logfile start
db_1        |
db_1        |
db_1        | WARNING: enabling "trust" authentication for local connections
db_1        | You can change this by editing pg_hba.conf or using the option -A, or
db_1        | --auth-local and --auth-host, the next time you run initdb.
db_1        | waiting for server to start....2019-10-03 20:16:57.084 UTC [42] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1        | 2019-10-03 20:16:57.095 UTC [43] LOG:  database system was shut down at 2019-10-03 20:16:56 UTC
db_1        | 2019-10-03 20:16:57.101 UTC [42] LOG:  database system is ready to accept connections
db_1        |  done
db_1        | server started
db_1        |
db_1        | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
db_1        |
db_1        | waiting for server to shut down...2019-10-03 20:16:57.180 UTC [42] LOG:  received fast shutdown request
db_1        | .2019-10-03 20:16:57.182 UTC [42] LOG:  aborting any active transactions
db_1        | 2019-10-03 20:16:57.186 UTC [42] LOG:  background worker "logical replication launcher" (PID 49) exited with exit code 1
db_1        | 2019-10-03 20:16:57.186 UTC [44] LOG:  shutting down
db_1        | 2019-10-03 20:16:57.197 UTC [42] LOG:  database system is shut down
db_1        |  done
db_1        | server stopped
db_1        |
db_1        | PostgreSQL init process complete; ready for start up.
db_1        |
db_1        | 2019-10-03 20:16:57.297 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
db_1        | 2019-10-03 20:16:57.297 UTC [1] LOG:  listening on IPv6 address "::", port 5432
db_1        | 2019-10-03 20:16:57.299 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1        | 2019-10-03 20:16:57.310 UTC [51] LOG:  database system was shut down at 2019-10-03 20:16:57 UTC
db_1        | 2019-10-03 20:16:57.314 UTC [1] LOG:  database system is ready to accept connections

这是因为Prometheus导出程序在准备好接受连接之前尝试连接到数据库吗？ (从日志记录的顺序来看似乎是这种情况)。

另一个问题是，如果我浏览到localhost:9187，结果是我下载了一个包含HTML的文件，而不是实际看到我可以遵循的/metrics链接:



知道如何解决这些问题吗？

最佳答案

在不知道您的图像是如何构建的情况下，我发现有两个可能的问题需要解决:

似乎exporter容器首先启动，并且在postgres正常运行之前尝试连接到db容器。您可能需要在depends_on: db部分中添加exporter。

您可能需要先在pg_hba.conf容器上编辑db，然后exporter才能连接到它。默认情况下，仅允许本地连接，因此您必须附加exporter的IP地址(如果是仅限开发环境，则必须使用/0网络掩码)

如果您修复了这两个问题，那么一切应该会开始为您工作。

披露:我是EnterpriseDB (EDB)员工