如何从主主机访问docker postgres数据库

Question

我有一个docker compose文件，看起来像：

version: "3"
services:
    redis:
        image: 'redis:3.2.7'
        # command: redis-server --requirepass redispass

    postgres:
        image: postgres:9.6
        ports:
            - "5432:5432"
        environment:
            - POSTGRES_USER=airflow
            - POSTGRES_PASSWORD=airflow
            - POSTGRES_DB=airflow
#            - PGDATA=/var/lib/postgresql/data


    webserver:
        image: airflow:develop
        depends_on:
            - postgres

        ports:
            - "8080:8080"

        command:
            - webserver

运行docker-compose up之后，我看到所有的服务都启动了，并且看起来工作良好。我的WebServer服务使用以下sqlalchemy连接字符串连接到postgres：PostgreSQL+Psycopg2:/airflow：airflow@postgres/airflow

 8:49AM /Users/paymahn/solvvy/scheduler gitlab-ci ✚ ◼
 ❮❮❮ psql -h postgres -p 5432 -U airflow
psql: could not translate host name "postgres" to address: nodename nor servname provided, or not known
 8:50AM /Users/paymahn/solvvy/scheduler  ✘ 2 gitlab-ci ✚ ◼
 ❯❯❯ psql -h localhost -p 5432 -U airflow
psql: FATAL:  database "airflow" does not exist
 8:51AM /Users/paymahn/solvvy/scheduler  ✘ 2 gitlab-ci ✚ ◼
 ❯❯❯ psql -h localhost -p 5432 -U postgres
psql: FATAL:  role "postgres" does not exist

编辑：这是在接受的解决方案中的一个评论中回答的，但我认为值得在这里指出：我已经在本地运行postgres，这引起了各种混乱。

10:12AM /Users/paymahn/solvvy/scheduler gitlab-ci ✚ ◼
 ❯❯❯ ps aux | rg postgres
paymahn          11705   0.0  0.0  4485040    596   ??  Ss   13Feb18   0:00.17 postgres: bgworker: logical replication launcher
paymahn          11704   0.0  0.0  4339972    680   ??  Ss   13Feb18   0:13.88 postgres: stats collector process
paymahn          11703   0.0  0.0  4485040   1404   ??  Ss   13Feb18   0:02.72 postgres: autovacuum launcher process
paymahn          11702   0.0  0.0  4486064    116   ??  Ss   13Feb18   0:06.42 postgres: wal writer process
paymahn          11701   0.0  0.0  4476848    204   ??  Ss   13Feb18   0:02.62 postgres: writer process
paymahn          11700   0.0  0.0  4486064    228   ??  Ss   13Feb18   0:00.58 postgres: checkpointer process
paymahn          11698   0.0  0.0  4478128    592   ??  S    13Feb18   0:12.09 /usr/local/Cellar/postgresql/10.2/bin/postgres -D /usr/local/var/postgres
paymahn          92143   0.0  0.0  4262040     24 s011  S+   10:12AM   0:00.00 rg postgres

删除我的本地postgres实例并更新我的hosts文件，就像接受的答案中提到的那样，一切都清除了。

Answer 1

只需将127.0.0.1 postgres添加到本地PC上的hosts文件中，然后使用命令psql-h postgres-p 5432-u airflow