database backup and recovery strategy

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