I would like to connect to my production database from my local
machine, so that I can import/export data using rake commands. (for
example: RAILS_ENV=production rake db:fixtures:load)
My database.yml file is typical:
The production database works for the rails app itself, presumably
because the app and the db run on the same machine, and hence the
‘localhost’ to the app is indeed the db server, but I cannot access
the db from local rake tasks. I’ve tried setting the production host
to the ip of the server, but that didn’t work either.
Any thoughts on how to establish this remote production db connection
would be greatly appreciated.