heroku pgbackups:restore: an error occurred and your restore did not finish

Question

I am attempting to restore a local snapshot of a database into a heroku dev instance.

heroku pgbackups:restore --app app_name HEROKU_POSTGRESQL_AMBER_URL https://www.dropbox.com/etc

But I consistently receive the following error

HEROKU_POSTGRESQL_AMBER_URL  <---restore---  db.dump

Retrieving... done
!    An error occurred and your restore did not finish.

The database snapshot was captured using the pg_dump string in the heroku docs:

PGPASSWORD=pwd pg_dump -Fc --no-acl --no-owner -h localhost -U postgres db > db.dump

and the dump file is in a dropbox share (so available with direct URL access)

Both Heroku and the local database are PG 9.2.

Have you looked at what the error says in `heroku logs` ? – Will Jan 06 '13 at 01:33 — Will, Jan 06 '13 at 01:33
Well, there you go. Check the logs, stupid! Thanks man. – Toby Hede Jan 06 '13 at 01:55 — Toby Hede, Jan 06 '13 at 01:55

score 3 · Accepted Answer · answered Jan 09 '13 at 06:44

3

Heroku logs contain all of the output from pgbackups, which will help track down the issue.

answered Jan 09 '13 at 06:44

Toby Hede

1

@Thermech Just type the command `heroku pg:backups:info ` where backupkey is the key generated for the current backup. – Ahtisham Sep 02 '18 at 17:54

1 Answers1