Setting up travis.ci with Rails and Postgres

Question

I'm having trouble getting Rails, postgres travis to work. Keep getting a database connection error when the tests start running.

Errno::ECONNREFUSED: Connection refused - connect(2)

.travis.yml

language: ruby
rvm:
  - "1.9.3"
before_script:
  - cp config/database.travis.yml config/database.yml
  - psql -c 'create database myapp_test;' -U postgres
  - bundle exec rake db:migrate --trace
  - bundle exec rake db:test:prepare --trace
script:
  - RAILS_ENV=test bundle exec rake spec

gemfile: Gemfile.ci

and database.travis.yml

test:
  adapter: postgresql
  database: myapp_test
  username: postgres

I have to use separate database config.

Any clue what I'm doing wrong? Following the documentation almost exactly in http://about.travis-ci.org/docs/user/database-setup/ except I have to copy database config over to the right place.

Peter Goldstein · Accepted Answer · 2013-10-15 03:30:57Z

2

Why are you doing the

bundle exec rake db:migrate
bundle exec rake db:test:prepare

The db:test:prepare is going to try and access the development database, which doesn't exist. And the rake db:migrate should be automatically run by Travis.

answered Oct 15, 2013 at 3:30

Peter Goldstein

4,5552 gold badges21 silver badges17 bronze badges

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

6 Comments

rb512 Over a year ago

close, both the above commands will be run for the dev environment.

mehulkar Over a year ago

rake db:test:prepare does not access the development db I don't think. stackoverflow.com/a/15170024/986415

mehulkar Over a year ago

Yeah, without running migrations, travis doesn't do anything. travis-ci.org/collegedesis/collegedesis.com/builds/12551777

Peter Goldstein Over a year ago

Travis runs in the test environment. rake db:test:prepare will attempt to dump the dev database and load the schema into the test environment. It shouldn't be necessary. Travis should run migrations directly against the test db.

Peter Goldstein Over a year ago

Just to be clear, run the bundle exec rake db:migrate, leave out the db:test:prepare

|

mehulkar · Accepted Answer · 2013-12-05 23:27:59Z

1

The problem was that I needed to enable the elasticsearch service on travis. Adding records to the database requires indexing and the refused connection was to a nonexistent elasticsearch server.

answered Dec 5, 2013 at 23:27

mehulkar

4,9847 gold badges39 silver badges58 bronze badges

3 Comments

Mario Uher Over a year ago

Is there anywhere explained why you need an elasticsearch server?

mehulkar Over a year ago

@MarioUher my test suite had tests that was expecting a server avaiable

Mario Uher Over a year ago

Ah ok. Wasn't mentioned anywhere and the the official docs included a link to an elastic search package as well. So I was very confused. But thankful the support from Travis is really good, and helped me with my problem.

zhaoqing · Accepted Answer · 2016-09-10 17:37:23Z

Based on the doc, you should turn on the postgresql service first

services:
  - postgresql

And specify the DB type with (optional) :

    env:
      - DB=pgsql

NOTE: postgresql and postgres WILL NOT WORK. Please use pgsql !!!

Here is the full code that worked for me:

.travis.yml

language: ruby

rvm:
  - 2.2

env:
  - DB=pgsql

services:
  - postgresql

script:
  - RAILS_ENV=test bundle exec rake db:migrate --trace
  - bundle exec rake db:test:prepare
  - bundle exec rake

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

config/database.yml.travis

default: &default
  adapter: postgresql
  encoding: unicode
  pool: 5

development:
  <<: *default
  database: courseselect_development

test:
  <<: *default
  database: courseselect_test

production:
  <<: *default
  database: courseselect_developement

BTW, I also have the file database.yml with the same content as config/database.yml.travis

Collectives™ on Stack Overflow

Setting up travis.ci with Rails and Postgres

3 Answers 3

6 Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related