Have Gitlab CI/CD use different PostgreSQL server than local development?

Question

I've just set up my Python and Django project on Gitlab. Now when I make a commit and push it to Gitlab, it automatically runs my unit tests which is a good thing.

The problem is that to get it to work; I have to set my database host in Django to "postgres" which obviously won't work.

I want my local development environment to use 127.0.0.1 and the Gitlab environment to use "postgres", but I'm not sure how to go about and do that.

Here is my Gitlab configuration file:

https://gitlab.com/glamorous-systems/seductive/blob/master/.gitlab-ci.yml

Any help would be much appreciated. It took me quite awhile to get things working as I wanted them so if I can solve this problem I think everything will work out quite nicely.

yuppie-flu · Accepted Answer · 2018-03-26 12:23:03Z

1

You can set your database host like this

'HOST': os.environ.get('DATABASE_HOST', '127.0.0.1')

and define another env variable DATABASE_HOST=postgres in gitlab-ci.yml

This way you'll get what you want.

answered Mar 26, 2018 at 12:23

yuppie-flu

1,51014 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Have Gitlab CI/CD use different PostgreSQL server than local development?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related