时间戳

首页 > 解决方案 > 试图创建一个新的 Postgres 连接

postgresql - 试图创建一个新的 Postgres 连接

问题描述

我使用 postgres 作为数据库实现了一个部署在 docker 下的 java 微服务应用程序。我在MAC上。昨天我使用我的 MAC 主机在 DBeaver 上成功创建了一个连接：192.168.1.73。今天，我无法连接到该主机。

我试过 $ telnet 192.168.1.73 5432 并有以下输出

Trying 192.168.1.73...
telnet: connect to address 192.168.1.73: Connection refused
telnet: Unable to connect to remote host

我能做些什么 ？

编辑

我运行 docker-compose.yml

这是数据库的摘录

  database:
    image: postgres:9.5
    ports:
      - "5432:5432"
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=Esprit292948
      - POSTGRES_DB=immo_db_local

这是 docker-compose.yml 的开头。我自愿隐藏细节

version: '2'
services:
  eurekaserver:
    image:   ...
    ports:
      - ...
  configserver:
    image: ...
    ports:
      - ...
    environment:
      EUREKASERVER_URI: ...
      EUREKASERVER_PORT: ...
      ENCRYPT_KEY:       ...
  gateservice:
    image: ...
    ports:
      - ...
    environment:
      PROFILE: ...
      SERVER_PORT: ...
      CONFIGSERVER_URI: ...
      EUREKASERVER_URI: ...
      EUREKASERVER_PORT:        ...
      DATABASESERVER_PORT:      "5432"
      CONFIGSERVER_PORT:        "8888"
      AUDIT_PORT:               "8087"
      DB_PORT:                  "8930"
  database:
    image: postgres:9.5
    ports:
      - "5432:5432"
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=Esprit292948
      - POSTGRES_DB=immo_db_local
  optimisationfiscaleservice:
    image: ...
    ports:
      - ...
    etc......

这是 ifconfig 结果

$ ifconfig
lo0: flags=8049<UP,LOOPBACK,RUNNING,MULTICAST> mtu 16384
    options=1203<RXCSUM,TXCSUM,TXSTATUS,SW_TIMESTAMP>
    inet 127.0.0.1 netmask 0xff000000 
    inet6 ::1 prefixlen 128 
    inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1 
    nd6 options=201<PERFORMNUD,DAD>
gif0: flags=8010<POINTOPOINT,MULTICAST> mtu 1280
stf0: flags=0<> mtu 1280
en0: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500
    options=50b<RXCSUM,TXCSUM,VLAN_HWTAGGING,AV,CHANNEL_IO>
    ether a8:20:66:31:0a:2a 
    nd6 options=201<PERFORMNUD,DAD>
    media: autoselect (none)
    status: inactive
en1: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500
    options=400<CHANNEL_IO>
    ether 20:c9:d0:e0:5d:a1 
    inet6 fe80::41:83de:7236:ba7a%en1 prefixlen 64 secured scopeid 0x5 
    inet 192.168.1.73 netmask 0xffffff00 broadcast 192.168.1.255
    nd6 options=201<PERFORMNUD,DAD>
    media: autoselect
    status: active
en2: flags=8963<UP,BROADCAST,SMART,RUNNING,PROMISC,SIMPLEX,MULTICAST> mtu 1500
    options=460<TSO4,TSO6,CHANNEL_IO>
    ether 82:0a:60:f7:bc:80 
    media: autoselect <full-duplex>
    status: inactive
fw0: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 4078
    lladdr a8:20:66:ff:fe:83:de:f2 
    nd6 options=201<PERFORMNUD,DAD>
    media: autoselect <full-duplex>
    status: inactive
bridge0: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500
    options=63<RXCSUM,TXCSUM,TSO4,TSO6>
    ether 82:0a:60:f7:bc:80 
    Configuration:
        id 0:0:0:0:0:0 priority 0 hellotime 0 fwddelay 0
        maxage 0 holdcnt 0 proto stp maxaddr 100 timeout 1200
        root id 0:0:0:0:0:0 priority 0 ifcost 0 port 0
        ipfilter disabled flags 0x0
    member: en2 flags=3<LEARNING,DISCOVER>
            ifmaxaddr 0 port 6 priority 0 path cost 0
    nd6 options=201<PERFORMNUD,DAD>
    media: <unknown type>
    status: inactive
p2p0: flags=8843<UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST> mtu 2304
    options=400<CHANNEL_IO>
    ether 02:c9:d0:e0:5d:a1 
    media: autoselect
    status: inactive
awdl0: flags=8943<UP,BROADCAST,RUNNING,PROMISC,SIMPLEX,MULTICAST> mtu 1484
    options=400<CHANNEL_IO>
    ether 0e:b6:7e:12:5d:fb 
    inet6 fe80::cb6:7eff:fe12:5dfb%awdl0 prefixlen 64 scopeid 0xa 
    nd6 options=201<PERFORMNUD,DAD>
    media: autoselect
    status: active
utun0: flags=8051<UP,POINTOPOINT,RUNNING,MULTICAST> mtu 1380
    inet6 fe80::3b2:bb0f:18:dcb7%utun0 prefixlen 64 scopeid 0xb 
    nd6 options=201<PERFORMNUD,DAD>
utun1: flags=8051<UP,POINTOPOINT,RUNNING,MULTICAST> mtu 2000
    inet6 fe80::b744:4974:1dd2:5fda%utun1 prefixlen 64 scopeid 0xc 
    nd6 options=201<PERFORMNUD,DAD>

标签： postgresqldockerdbeaver

解决方案

没注意，有错误提示

Name does not resolve

因此，根据这篇文章，我在 docker 文件中添加了“apk add bind-tools”以获取日志：Docker Compose and Postgres: Name does not resolve

之后我又犯了一个错误

Docker error : no space left on device

所以根据这篇文章Docker error : no space left on device : I run

docker system prune

然后，我成功连接到 DBeaver

推荐阅读