Step 1: First check if the pg_dump
utility is available:
pg_dump --version
Step 2: if it is, in your Sails project, run:
pg_dump -U DB_USER_NAME DB_NAME > dump.sql
Step 3: Then import the dump to your heroku app database by running:
heroku pg:psql --app APP_NAME < dump.sql
The above will import dump.sql
to your database.