Skip to content

Instantly share code, notes, and snippets.

View johnsaltarelli's full-sized avatar

John Saltarelli johnsaltarelli

View GitHub Profile
@johnsaltarelli
johnsaltarelli / Heroku App Database Copy
Last active October 25, 2018 15:43 — forked from kosyfrances/heroku_database_copy.md
To copy heroku database from one app to another and from local to heroku
To copy database from one heroku app to another -
```
heroku pg:backups capture [database_name]
heroku pg:backups restore $(heroku pg:backups public-url --app source_app) DATABASE_URL --app target_app
```
You can refer to https://devcenter.heroku.com/articles/heroku-postgres-backups for more information.
To copy database from local to heroku -
Dump your local database in compressed format using the open source pg_dump tool: `PGPASSWORD=mypassword pg_dump -Fc --no-acl --no-owner -h localhost -U myuser mydb > mydb.dump`
where `myuser` is your database username and `mydb` is the database name.
# Purge the Heroku Build Cache using the terminal. This requires a new deployment FYI.
# Replace appname with name of application on Heroku.
heroku plugins:install heroku-repo
heroku repo:purge_cache -a appname
git commit --allow-empty -m "Purge cache"
git push heroku master
@johnsaltarelli
johnsaltarelli / GitHub SSH Config
Created February 16, 2020 01:09
Force GitHub via SSH instead of HTTPS
# Forces all Git connections to use SSH instead of HTTPS when accessing GitHub.com
git config --global --add url."git@github.com:".insteadOf "https://github.com/"