Running Postgres as a build requirement in TeamCity build

Fixing gaps in TeamCity's documentation. How to make sure that Postgres is running and how to configure the credentials to connect to the database.

Running Postgres as Requirement in TeamCity Build.

We use different Continuous Integration tools in our projects. One of them is TeamCity software. A pipeline for TeamCity can be configured easily and has two steps, such as run tests and build a docker image for further deployment. However, I needed to run Postgres before running tests. I made a research, I read the documentation and this article may be useful to close a gap for team city’s documentation.

Image.

How to run Postgres before running tests

The documentation says that you can enable it using a docker-compose plugin. Okay, let’s configure it.

Go to Build settings -> Build steps -> Add build step

Runner type: Docker compose
Step name: Choose your own name
Execute step: If all previous steps finished successfully
Docker-compose file: your-compose.yml

How to run Postgres before running tests.

Seems pretty easy, huh? Yes, but I found the following problems:

  1. It’s unclear how to be sure that Postgres is up and running.
  2. How to configure credentials to connect to the Postgres database.

How to be sure that Postgres is running

The documentation says that we can use HEALTHCHECK configuration settings. Full configuration in docker-compose listed below:

With such configuration, TeamCity waits when a Postgres container will be ready to accept new connections and adds created network to TEAMCITY_DOCKER_NETWORK environment variable. NB! We should to work with our dependencies like we were inside docker-compose. E.g in our case we need to specify host: postgresand port: 5432 to connect to our database

Configuring credentials to connect to Postgres database

As I said before, remember to choose the right hostname to connect to the database. I wasted about one hour to realize it.

To configure it, go to Build settings -> Parameters -> Add new parameter

I use PG_HOSTNAME and PG_PORT environment variables for Postgres connection configuration and I set them in the Parameters section

Environment Variables.

Conclusion

I hope this article will help you to use docker-compose as a build step inside TeamCity. You can run more compose dependencies inside TeamCity and use them in your tests. If you have any questions feel free to ask them.

Custom Software and Mobile App Development.
WebRTC.

What to choose to implement audio/video calls solution...

What to choose to implement...

What to choose to implement audio/video calls solution using WebRTC?

Mad Devs have been working with WebRTC since 2013. We have implemented several projects with video or audio calls enabled. That’s why I want to share...

Yellow Taxi Car.

How we built failover architecture for a taxi service...

How we built failover architecture...

How we built failover architecture for a taxi service part 1 (intro)

This article is the Part 1 of detailed description of my talk at HighLoad++ 2015.Today Namba Taxi is the leading passenger transportation company in...

Uber-like Map with Animated Cars.

How we built a backend system for Uber-like map with...

How we built a backend system for...

How we built a backend system for Uber-like map with animated cars using Go

Hello there. It’s my first blog post in English and I’m going to tell you how we built simple in-memory storage for animated cars. We show animated...