How to set up Travis CI and postgresql using custom db credentials?

Question

I'm trying to set up custom Postgres credentials with Travis CI as I'd like to avoid the existing credentials definition in the code to be tested.

The testing code defines that the database should be accessed on:

'sqlalchemy.url': 'postgresql://foo:bar@localhost/testing_db'

I've therefore created a database.travis.yml file:

postgresql: &postgresql
adapter: postgresql
username: foo
password: bar
database: testing_db

...and added the following to my .travis.yml:

services:
  - postgresql

before_script:
  - psql -c 'create database stalker_test;' -U postgres
  - mkdir config && cp database.travis.yml config/database.yml

However, I am still getting this during testing:

OperationalError: (psycopg2.OperationalError) FATAL:  role "foo" does not exist

What am I doing wrong?

Answer 1

Adding the following to .travis.yml solved my issue. No need for a database.travis.yml file.

before_script:
  - psql -c "CREATE DATABASE testing_db;" -U postgres
  - psql -c "CREATE USER foo WITH PASSWORD 'bar';" -U postgres