how to push postgres localdb to heroku using dropbox

postgres_localdb_to_heroku.md

1. create dump of your localdb

• PGPASSWORD=yourpass pg_dump -Fc --no-acl --no-owner -h localhost -U username localdb_name > mydb.dump

2. download file to dropbox and get the link
3. change your link from 'https://www.dropbox.com/s/xxx/mydb.dump?dl=0 to 'https://dl.dropboxusercontent.com/s/xxx/mydb.dump'
4. push to heroku:

• heroku pg:backups:restore https://dl.dropboxusercontent.com/s/xxx/mydb.dump DATABASE_URL -a yourAppName

links

• https://stackoverflow.com/questions/35446607/cant-push-database-to-heroku-because-database-is-not-empty-error
• https://stackoverflow.com/questions/19490938/push-database-to-heroku-how-to-use-heroku-pgpush
• http://albertnetymk.github.io/2014/08/28/import_heroku/