Heroku postgres: dump and restore

heroku_postgres.sh

# Details: https://devcenter.heroku.com/articles/heroku-postgres-import-export

# Create postgres role (v13) if not existing yet
createuser -s postgres -U <os-username>

# Dump
heroku pg:backups capture
curl -o latest.dump `heroku pg:backups public-url`

# Restore to local db
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U postgres -d mydb latest.dump

# Restore to another DB on Heroku (DATABASE_URL represents the HEROKU_POSTGRESQL_COLOR_URL on the app-2)
heroku pg:backups restore `heroku pg:backups public-url -a app-1` DATABASE_URL -a app-2