3 months ago
Hi
I have configure backups in my database postgres in my proyecto production. I just download this backup to restoure only some data of one user. there are any way to achieve this?
Best Regard,
Tomas,
Pinned Solution
3 months ago
Ok, I've come up with a workaround!
1. Find the backup you want to restore
2. Click the "Restore" button. This will create a new volume with your restored data and stage the changes to replace your database's current volume with this new one
Click the "Details" button to see the staged changes
Remove the staged changes replacing your database's volume location. You should end up with only one staged change: adding the new volume to your environment
Create a new database in your environment
Drag the unmounted volume (your restored data) on to the new database. You can delete the volume that was originally added to the new database.
Now you can connect to the new database to run queries or
pg_dumpwithout affecting the original database or its volume
I've attached some screenshots so you know what to expect to see during the steps above.
4 Replies
3 months ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open brody • 3 months ago
3 months ago
How timely! I just ran into a situation where I'd like to download a backup to restore it locally and find some deleted data.
trevorblades
How timely! I just ran into a situation where I'd like to download a backup to restore it locally and find some deleted data.
3 months ago
very neat trevor blades i hope you were successful in your timely attempt
fullsizemalt
very neat trevor blades i hope you were successful in your timely attempt
3 months ago
Oh, I wasn't successful. I was just saying how I'd also like a way to download a database backup.
3 months ago
Ok, I've come up with a workaround!
1. Find the backup you want to restore
2. Click the "Restore" button. This will create a new volume with your restored data and stage the changes to replace your database's current volume with this new one
Click the "Details" button to see the staged changes
Remove the staged changes replacing your database's volume location. You should end up with only one staged change: adding the new volume to your environment
Create a new database in your environment
Drag the unmounted volume (your restored data) on to the new database. You can delete the volume that was originally added to the new database.
Now you can connect to the new database to run queries or
pg_dumpwithout affecting the original database or its volume
I've attached some screenshots so you know what to expect to see during the steps above.
Status changed to Solved brody • 2 months ago