windows - 无法连接到 Windows 10 上的 postgres

Question

我正在我的 Windows PC 上设置项目，但我遇到了 postgres 的问题。项目设置在docker上。当我运行 docker-compose up 时收到错误

: *** Failed to connect to database dev; trying to create database    
/usr/local/bundle/gems/sequel-4.48.0/lib/sequel/adapters/postgres.rb:224:in `initialize': PG::ConnectionBad: could not connect to server: Connection refused (Sequel::DatabaseConnectionError)
Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?
could not connect to server: Cannot assign requested address
Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?

我不知道该怎么办。我已经为 TCP-IP 安装了 Microsoft easy-fix，关闭了 Windows 防火墙，将 pg_hba.conf 中的所有连接更改为信任。没有任何帮助。我没有安装任何防病毒软件。

nmap 报告:

Nmap scan report for localhost (127.0.0.1)
Host is up (0.0027s latency).
Other addresses for localhost (not scanned): ::1
Not shown: 995 closed ports
PORT     STATE SERVICE
135/tcp  open  msrpc
445/tcp  open  microsoft-ds
2068/tcp open  avocentkvm
2179/tcp open  vmrdp
5432/tcp open  postgresql

编辑:我运行 psql -h localhost 并收到

psql: CATASTROPHIC: role "Kamil" does not exist

Kamil 是我的 PC 名称。

编辑2:

docker 是否有可能无法访问本地主机上的 postgres？

Answer 1

问题解决了

我必须将环境变量设置为 DB_HOST=docker.for.win.localhost