Gitlab CI cannot connect spring application to postgres

Question

I have following stage in gitlab yml file.

    integration-tests:
      image: mydocker-hub-id/mvn-intergration-tests-image:latest
      stage: test
      services:
        - postgres
      script:
        - export PGPASSWORD=$POSTGRES_PASSWORD
        - psql -h "postgres" -U "$POSTGRES_USER" -d "$POSTGRES_DB" -c "SELECT 'OK' AS status;"
        - cd source_code
        - pg_isready
        - mvn verify -P test-ci -DskipUTs=true

When job is executed for command pg_isready I have response 5432 no response. When tests are executed from each intergration test I have error:

org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

Image used in this stage is built based on postgres image which has additionally installed maven and java 11.

What could be the issue that spring application cannot connect with postgres server. Command postgres --version displays proper version. Also command

"psql -h "postgres" -U "$POSTGRES_USER" -d "$POSTGRES_DB" -c "SELECT 'OK' AS status;"

returns the OK result.

Spring db connection in app.properties is following:

spring.datasource.url=jdbc:postgresql://localhost:5432/test

maciejka · Accepted Answer · 2020-08-18 16:02:09Z

1

I found in gitlab documentation details about postgres service configuration

https://docs.gitlab.com/ee/ci/services/postgres.html?fbclid=IwAR1eDlOQ4ACn6zqw1auIetB07JRcCGi1Pjl-hpfGBM45ujvkImm6fHSSbgg

The db url should contain the name of host postgres instead of localhost.

answered Aug 18, 2020 at 16:02

maciejka

9583 gold badges20 silver badges45 bronze badges

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

2 Comments

Lutosław Over a year ago

I've been fighting it for hours. Can you share an exact configuration? I tried "jdbc:postgresql://postgres/dbname" in application.properties but still get the same error.

Lutosław Over a year ago

I tried "jdbc:postgresql://postgres:5432/dbname" too.

Ricardo Bermudez Osorio · Accepted Answer · 2020-12-04 20:05:19Z

0

I found gitlab-runner is running the postgresql docker image as postgres and this is working changing jdbc:postgresql://localhost:5432/dbname into jdbc:postgresql://postgres:5432/dbname.

answered Dec 4, 2020 at 20:05

Ricardo Bermudez Osorio

33 bronze badges

Collectives™ on Stack Overflow

Gitlab CI cannot connect spring application to postgres

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related