0

In my Nitrous box I use a heroku postgres database as development database. Now I have a data.dump file I want to export to this postgres database. How can I do that, because it is only a database without an app on Heroku, you can't just use a pg_restore command right?

John
  • 6,404
  • 14
  • 54
  • 106
  • Which format has your dump? Is it in SQL format (plain text SQL statements) or in the so called "custom dump format" (compressed binary stuff)? – stefan.schwetschke Aug 13 '13 at 12:56

1 Answers1

0

Solved it, you can use just the normal pg_restore command, but need to change the port in database.yml to 5572 (secure port)

John
  • 6,404
  • 14
  • 54
  • 106