Heroku database restore issue

by

Just found the solution, actually two things were wrong in my case.

One, the uploaded .dump file was not well readable/usable by the heroku.

Two, the heroku postgresql DB complete URL was not required to be provided.

So, the right way that worked for me was that the uploaded file should be accessible without any token and also without any virtual/indirect path, etc. The URL to the file should point to the file directly. In my questioned problem, I was using firebase to host my DB file temporarily to do the heroku operation. And firebase was not giving direct URL to the uploaded physical file.

heroku pg:backups:restore  --app heroku-postgres-f3*** 'https://www.h***.com/dss_iaya_db_dump2.dump' DATABASE_URL

After typing this command, I was asked to retype the heroku app name just to confirm the operation. Once done, everything worked like a charm.

More Related Contents:

  1. Heroku “psql: FATAL: remaining connection slots are reserved for non-replication superuser connections”
  2. Destroying a Postgres DB on Heroku
  3. Error when pushing data to Heroku: time zone displacement out of range
  4. Why the “Group BY” by month didn’t work? [closed]
  5. What to do with null values when modeling and normalizing?
  6. Truncating all tables in a Postgres database
  7. How can I drop all the tables in a PostgreSQL database?
  8. postgres default timezone
  9. How to change PostgreSQL user password?
  10. How to get the count of current month Sunday’s in psql?
  11. quick random row selection in Postgres
  12. Restore a postgres backup file using the command line?
  13. Running PostgreSQL in memory only
  14. Refresh a materialized view automatically using a rule or notify
  15. postgresql – replace all instances of a string within text field
  16. Is it possible to have autoincrement number without it being an ID?
  17. PostgreSQL: Modify OWNER on all tables simultaneously in PostgreSQL
  18. How do I login and authenticate to Postgresql after a fresh install?
  19. pgadmin4 : postgresql application server could not be contacted.
  20. PostgreSQL error ‘Could not connect to server: No such file or directory’
  21. Insert if not exists, else return id in postgresql
  22. Sequences not affected by transactions?
  23. Postgres: check if array field contains value?
  24. PostgreSQL ERROR: canceling statement due to conflict with recovery
  25. Change type of varchar field to integer: “cannot be cast automatically to type integer”
  26. eliminate duplicate array values in postgres
  27. Is there a way to disable updates/deletes but still allow triggers to perform them?
  28. Postgres default sort by id – worldship
  29. Best way to install hstore on multiple schemas in a Postgres database?
  30. Deploying Django to Heroku (Psycopg2 Error)

Leave a Comment