Docker无法与Travis配置项中的postgresql建立连接

Question

我正在尝试将Travis CI集成到我的rails应用程序中。在我的本地机器(ubuntu，windows)上一切工作都很好，但是在travis主机上有一个连接错误。下面是我的配置。

sudo: required

language: ruby

services:
  - docker

env:
  DOCKER_COMPOSE_VERSION: 1.13.0

before_install:
  - sudo rm /usr/local/bin/docker-compose
  - curl -L https://github.com/docker/compose/releases/download/${DOCKER_COMPOSE_VERSION}/docker-compose-`uname -s`-`uname -m` > docker-compose
  - chmod +x docker-compose
  - sudo mv docker-compose /usr/local/bin
  - sudo apt-get update
  - sudo apt-get -y -o Dpkg::Options::="--force-confnew" install docker-engine
  - docker-compose build
  - docker-compose -f docker-compose.commands.yml run --rm website rails db:create db:migrate db:test:prepare

script:
 - docker-compose -f docker-compose.commands.yml run --rm -e RAILS_ENV=test website rspec

development: &default
adapter: postgresql
database: my_app_development
username: postgres
host: postgres
port: 5432

version: '3'

services:
  postgres:
    image: 'postgres:9.6.2'
    ports:
      - "5432"

  website:
    depends_on:
      - 'postgres'
    build: .
    ports:
      - '3000'
  volumes:
    - '.:/my_app'
    - 'bundle_data:/bundle'

 volumes:
  bundle_data:

正在创建myapp_postgres_1

无法连接到服务器：连接被拒绝服务器是否在主机“Postgres”(172.18.0.2)上运行并接受端口5432上的TCP/IP连接？无法为{“adapter”=>“postgreSQL”、“encode”=>“unicode”、“database”=>“my_app_development”、“pool”=>5、“username”=>“postgres”、“host”=>“postgres”、“port”=>5432}rails创建数据库已中止！PG：：ConnectionBad：无法连接到服务器：连接被拒绝服务器是否在主机“Postgres”(172.18.0.2)上运行并接受端口5432上的TCP/IP连接？

Answer 1

感谢@johnharris85和@jbielick我找到了这个解决方案：

website:
    depends_on:
      - 'postgres'
    build: .
    ports:
      - '3000'
    volumes:
      - '.:/my_app'
      - 'bundle_data:/bundle'
    entrypoint: ./wait-for-postgres.sh postgres 5432

  postgres:
    image: 'postgres:9.6.2'
    ports:
      - '5432'

wait-for-postgres.sh:

#!/bin/sh

postgres_host=$1
postgres_port=$2
shift 2
cmd="$@"

# wait for the postgres docker to be running
while ! pg_isready -h $postgres_host -p $postgres_port -q -U postgres; do
  >&2 echo "Postgres is unavailable - sleeping"
  sleep 1
done

>&2 echo "Postgres is up - executing command"

# run the command
exec $cmd