database backup and recovery strategy - restarone/violet_rails GitHub Wiki
So you accidentally deleted something, and need it back. Follow the steps below to restore from a snapshot, export missing data and restore it to the production instance.
Step 1
Find the latest snapshot
Step 2
Select the snapshot and click on "restore snapshot"
Step 3
Now you have a DB instance that has the latest snapshot (that hopefully contains the data you are missing)
Step 4
Connect to it with PG admin and navigate to the database, schema and table you need. Select backup. Make sure to save the backup in a place you can find
Step 5
Connect to the production database, select the schema and table you need, select restore