Diogo de Lima Gama da Silva diligasi

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.

Grab new backup of database

Command: heroku pgbackups:capture --remote production

Response: >>> HEROKU_POSTGRESQL_COLOR_URL (DATABASE_URL) ----backup---> a712

Get url of backup download

Command: heroku pgbackups:url [db_key] --remote production

	["Africa/Algiers", "West Central Africa"],
	["Africa/Cairo", "Cairo"],
	["Africa/Casablanca", "Casablanca"],
	["Africa/Harare", "Harare"],
	["Africa/Johannesburg", "Pretoria"],
	["Africa/Monrovia", "Monrovia"],
	["Africa/Nairobi", "Nairobi"],
	["America/Argentina/Buenos_Aires", "Buenos Aires"],
	["America/Bogota", "Bogota"],
	["America/Caracas", "Caracas"],