rake db:migrate fails in db:structure:dump with no error output

Question

I currently changed my ActiveRecord schema format to :sql and when migrating (rake db:migrate), I get the following error with no real explanation as to what is wrong:

$ bundle exec rake db:migrate
rake aborted!
Error dumping database

Tasks: TOP => db:structure:dump
(See full trace by running task with --trace)

I'm using Rails 4.2.4 and PostgreSQL 9.4.

Community · Accepted Answer · 2017-05-23 11:52:50Z

1

After following the debug trail in the Rails code, I finally discovered the error.

The pg_dump command is being executed in activerecord/lib/active_record/tasks/postgresql_database_tasks.rb#54. After printing the output of the command execution with $?, I realized it was returning a 127 exit code, which means that the command was not found.

It turns out that the pg_dump command was not in my executable PATH. I simply added it by creating a symbolic link and it all worked fine:

ln -s /opt/local/lib/postgresql94/bin/pg_dump /usr/local/bin

NOTE: I also found out that the issue of not printing out the error has already been fixed in Rails 4.2.5

edited May 23, 2017 at 11:52

CommunityBot

11 silver badge

answered Jan 20, 2016 at 10:14

mrstif

2,9662 gold badges29 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

rake db:migrate fails in db:structure:dump with no error output

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related