How can I restore my database data with only postgres dump on heroku
I reached to the build limit on my heroku app while there was a lot changes I still wanted to make and I came up with the tought of creating another app and use the same database as the first app and thereafter delete the first app and rename the second app I created to the deleted first app's name but when I deleted the first app I ran into an issue database was also deleted but before deleting that app I downloaded postgres dump for backup so now I uploaded it to my github to just restore my data.
And now I'm running the following command
heroku pg:backups:restore 'https://github.com/myusername/repo/path/branch/latest.dump' --app myappname --c
onfirm myappname
but I'm getting the following error
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
!
So I want to know if there is anything I can do to perfome backup or I'm just wasted, realy need your help
Thanks in advance
You are using an incorrect URL to point the dump file,
https://github.com/myusername/repo/path/branch/latest.dump is a blob_url which is like a URL of the web page, we get a rendered HTML version of the file by accessing the blob_url.
You should use a raw_url to point the dumb file, to get the raw_url click on the Raw button on the blob page of the respected file
Hope that should work
- Does calling a method from template query the database each time?
- Sort by display name instead of actual value
- What is gettext_lazy on django for?
- Custom Django Rest Framework Serializer Field not running `to_representation()` if value is null
- NumPy array is not JSON serializable
- How To Run Arbitrary Code After Django is "Fully Loaded"
- Django How to FormView rename context object?
- Filter by time in DRF
- Python mock to create a fake object return a dictionary when any of its attributes are used
- django managers vs proxy models
- Generating a non-sequential ID/PK for a Django Model
- Celery infinite retry pattern issue
- django select_related - when to use it
- How should I set my DATABASE_URL?
- How can I use composite primary keys in django?
- How do I get the object if it exists, or None if it does not exist in Django?
- Django Allauth's Google Login Redirect and Page Design
- Can I define an Alias to a foreign field in Django?
- Django ManytoManyField and widgets
- How to handle redirect for login_required in htmx partial view?
- How to Paginate within an action in Django Rest Framework
- Django imported database -- am I doing it wrong? Is Django not fit to purpose here?
- Cannot open include file: 'mysql.h': No such file or directory
- How do you change a model name when it shows up in Django admin?
- How to translate a model label in Django Admin?
- Dynamic File Path in Django
- Generate PDF with WeasyPrint having common header/footer and pagination
- DeleteView marking inactive instead deleting?
- GeoDjango, difference between dwithin and distance_lt?
- When we should use "db_index=True" in Django?