I tried to transfer a snapshot file from my local Postgrel database (which I uploaded to Google Drive and which is publicly accessible) to my remote Heroku database with the following URL:
heroku pg:backups:restore 'https://drive.google.com/open?id=dump_id_link_here' DATABASE_URL
I'm already logged into my Heroku app through the terminal I'm running the command on.
but I got the same mistake twice. I searched online and found threads like pg_restore: (archiver) did not find a magic string in the file header, but I could not help linking the two, since I'm two very new postgrel. I hope you draw my attention to the problems. Very appreciated.
Starting restore of https://drive.google.com/open?id=dump_id_link_here to postgresql-symmetrical-52186... done Stop a running restore with heroku pg:backups:cancel. Restoring... ! ▸ An error occurred and the backup did not finish. ▸ ▸ waiting for restore to complete ▸ pg_restore finished with errors ▸ waiting for download to complete ▸ download finished with errors ▸ please check the source URL and ensure it is publicly accessible ▸ Run heroku pg:backups:info r002 for more details. === Backup r002 Database: BACKUP Started at: 2019-09-14 21:14:26 +0000 Finished at: 2019-09-14 21:14:27 +0000 Status: Failed Type: Manual Backup Size: 0.00B (0% compression) === Backup Logs 2019-09-14 21:14:27 +0000 pg_restore: (archiver) did not find magic string in file header 2019-09-14 21:14:27 +0000 waiting for restore to complete 2019-09-14 21:14:27 +0000 pg_restore finished with errors 2019-09-14 21:14:27 +0000 waiting for download to complete 2019-09-14 21:14:27 +0000 download finished with errors 2019-09-14 21:14:27 +0000 please check the source URL and ensure it is publicly accessible