时间戳

首页 > 解决方案 > 与 docker 上运行的 postgress 的连接超时

laravel - 与 docker 上运行的 postgress 的连接超时

问题描述

我有一个使用 laravel 和 postgres 在 docker 上运行的项目。在我的项目中，一切都很好，项目没有问题，但是当我想使用navicat或phpstorm连接到容器上的数据库时，它给了我这个错误：

could not connect to server : connection timed out . is the server running on host "172.18.0.4" and accepting tcp/ip connections on post 5432 ??

我的项目可以毫无问题地使用以下详细信息进行连接：

DB_CONNECTION=pgsql
DB_HOST=project_database_1
DB_PORT=5432
DB_DATABASE=project
DB_USERNAME=postgres
DB_PASSWORD=123456

这是我的 docker compose 文件：

version: '3'
services:

  #PHP Service
  app:
    build:
      context: .
      dockerfile: php/Dockerfile
    image: digitalocean.com/php
    container_name: app
    restart: unless-stopped
    tty: true
    environment:
      SERVICE_NAME: app
      SERVICE_TAGS: dev
    working_dir: /var/www
    volumes:
      - ./:/var/www
      - ./php/local.ini:/usr/local/etc/php/conf.d/local.ini
    networks:
      - app-network


  #Nginx Service
  webserver:
    image: nginx:alpine
    container_name: webserver
    restart: unless-stopped
    tty: true
    ports:
      - "80:80"
      - "443:443"
    volumes:
      - ./:/var/www
      - ./nginx/conf.d/:/etc/nginx/conf.d/
    networks:
      - app-network

  #db
  database:
    image: "postgres" # use latest official postgres version
    ports:
      - "5432:5432"
    env_file:
      - .env
    volumes:
      - database-data:/var/lib/postgresql/data/ # persist data even
    networks:
      - app-network



  #redis
  redis:
    container_name: redis
    image: redis
    tty: true
    ports:
      - "6379:6379"
    volumes:
      - ../data/redis:/data
    entrypoint: redis-server --appendonly yes
    restart: always
    networks:
      - app-network




#Docker Networks
networks:
  app-network:
    driver: bridge

#Docker Volumes
volumes:
  database-data:
    driver: local

知道我无法连接到数据库有什么问题吗？

标签： laravelpostgresqldockerpostgresql-9.3

解决方案

  #PHP Service
  app:
    build:
      context: .
      dockerfile: php/Dockerfile
    depends_on:
      - pgsql
    image: digitalocean.com/php
    container_name: app
    restart: unless-stopped
    tty: true
    environment:
      SERVICE_NAME: app
      SERVICE_TAGS: dev
    working_dir: /var/www
    volumes:
      - ./:/var/www
      - ./php/local.ini:/usr/local/etc/php/conf.d/local.ini
    networks:
      - app-network


  #db
  pgsql:
    image: "postgres" # use latest official postgres version
    ports:
      - "5432:5432"
    env_file:
      - .env
    volumes:
      - database-data:/var/lib/postgresql/data/ # persist data even
    networks:
      - app-network

尝试这个。depends_on你说应用程序应该依赖于pgsql 。首先 pgsql 出现，然后当你进入时你的应用程序出现docker-compose up

推荐阅读