Run postgreSQL gitlab docker

Question

I'm trying to run a pipeline on gitlab of a python webapp made with Django, that uses a postgre database. After installing postgre, the psql command gives the error:

psql: error: could not connect to server: No such file or directory

Here's (part of) my .gitlab-ci.yml file:

image: python:latest

# Install postgreSQL service on container
services:
    - postgres:12.2-alpine

# Change pip's cache directory to be inside the project directory
variables:
  PIP_CACHE_DIR: "$CI_PROJECT_DIR/.cache/pip"
  DJANGO_SETTINGS_MODULE: "my_app.settings"
  POSTGRES_DB: $POSTGRES_DB
  POSTGRES_USER: $POSTGRES_USER
  POSTGRES_PASSWORD: $POSTGRES_PASSWORD
  POSTGRES_HOST_AUTH_METHOD: trust

# Let's cache also the packages
# Install packages in a virtualenv and cache it as well
cache:
  paths:
    - .cache/pip
    - venv/

before_script:
  - pip install virtualenv --upgrade pip
  - virtualenv venv
  - source venv/bin/activate
  - apt-get update
  #- apt-get install -y postgresql postgresql-client libpq-dev # postgre db requirements

stages:          # List of stages for jobs, and their order of execution
  - build
  - verify
  - unit_test
  - integration_test
  - package
  - release
  - deploy

build:
  stage: build
  script: 
    - pip install -r requirements.txt
    - echo "Build stage finished"

verify:
  stage: verify
  script:
    - prospector -X ./my_app  # static code analysis
    - bandit -r ./my_app     # static code analysis pt. 2
    - echo "Verify stage finished"

unit_test:
  stage: unit_test
  script:
    - echo "Running unit_test 1"
    - pytest ./my_app/unit_test.py #running unit_test    
    - echo "Creating db"
    - apt-get install -y postgresql postgresql-client libpq-dev # postgre db
    - psql -U postgres
    - psql -d "CREATE USER $POSTGRES_USER WITH PASSWORD $POSTGRES_PASSWORD CREATEDB;"
    - psql -d "CREATE DATABASE $POSTGRES_DB OWNER $POSTGRES_USER;"
    - echo "Unit testing stage finished"

How can I make psql work on gitlab CI/CD pipeline?

Patrick · Accepted Answer · 2021-10-19 03:09:03Z

2

You're on the right track with the "services" keyword, which will cause a postgres database to run on the host "postgres" (the DNS of the service is based on the name of the container unless you specify an "alias" with the service).

Your issue is that psql attempts to connect to localhost unless you specify otherwise, so your psql -U postgres attempts to connect on localhost. Try using psql -U postgres -p 5432 -h postgres instead.

answered Oct 19, 2021 at 3:09

Patrick

3,2781 gold badge17 silver badges21 bronze badges

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

2 Comments

IDK Over a year ago

Your answer allowed me to move forward a bit, but now I get psql: error: FATAL: role "postgres" does not exist. Thing is ,I don't think I'm able to create a user up unitl I enter into psql, so... Is there a default user specified somewhere?

Patrick Over a year ago

You can set the default user with an environment variable passed into the postgres container, which you can set in a variable block in your ci.yml: hub.docker.com/_/postgres

Collectives™ on Stack Overflow

Run postgreSQL gitlab docker

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related