gitlab ci: access DB service from docker

Question

I am trying to spin up a Postgres service and access it from within a docker container. This is my .gitlab-ci.yml:

image: docker:dind

stages:
  - build
  
services:
 - docker:dind
 - postgres:11-alpine

variables:
  POSTGRES_HOST_AUTH_METHOD: trust
  POSTGRES_DB: gitlabci

build_and_test:
  when: manual
  stage: build
  script:
    - docker run --rm postgres psql postgresql://postgres@postgres/gitlabci -c "SELECT 1;"

however, when I run this job I get an error:

psql: error: could not translate host name "postgres" to address: Name or service not known

How do I specify hostname from within a docker container?

You might find it easier to create your own docker and docker-compose files that contain some service (postgres) and then do docker-compose up in the ci. The service name you give in docker-compose will be the hostname you can use to connect to it. Then you simply create ci env variables that have those hostnames as the value so your other services can connect to it. — Kay
– Kay, Commented Feb 18, 2021 at 16:43

Alexander Pavlov · Accepted Answer · 2021-02-18 19:16:58Z

0

You can simplify your setup to

build_and_test:
  when: manual
  stage: build
  services:
    - name: postgres:11-alpine
      alias: postgres
  variables:
    POSTGRES_HOST_AUTH_METHOD: trust
    POSTGRES_DB: gitlabci  
    POSTGRES_USER: postgres
  script:
    - apk add postgresql-client
    - psql -h postgres -U postgres -d gitlabci -c "select 1;"

I assume your setup does not work because of different networks. Also, since you are using non-default postgres image, its auto-generated name could be different.

You can do

  services:
    - name: postgres:11-alpine
      alias: postgres

edited Feb 18, 2021 at 19:16

answered Feb 18, 2021 at 19:11

Alexander Pavlov

2,22920 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

kurtgn Over a year ago

your example works, but in my case I need to access service from within docker, see docker run in my example. That is the main problem.

Alexander Pavlov Over a year ago

try give service alias as in my example and run your container with --network host option

Nameless One Over a year ago

I have a similar scenario where the container that can't reach postgres is built in a previous step and the current step is needed to test the image (not just its code). Removing the docker run misses the intent of the question even though the MCVE loses the "why" of the question. I've tried this with --network=host too, and unfortunately it didn't help. It seems that postgresql doesn't have an exposed IP address.

Collectives™ on Stack Overflow

gitlab ci: access DB service from docker

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related