Restore

Restoring your backup is easy with a few commands.

Local Database

  1. On the Eppalock Dashboard, there's a list of all your backups. Each backup has a 'view' action, click view to open your backup on AWS.

  2. Download your backup from AWS - it will be an encrypted file, with the extension .dump.enc.

  3. Decrypt your backup with the following command (replacing YOUR_FILENAME and YOUR_ENCRYPTION_KEY - click here to find your encryption key):

    openssl enc -d -aes-256-cbc -in YOUR_FILENAME.dump.enc -out YOUR_FILENAME.dump -pass pass:YOUR_ENCRYPTION_KEY

  4. Create a local database if you don't have one already:

    createdb -U postgres eppalock_restore

  5. Restore your decrypted backup to a local database with the following command:

    pg_restore -U username -d dbname -1 YOUR_FILENAME.dump -vxOW

Heroku Database

To restore a backup to your Heroku database:

  1. Download and decrypt a backup following steps 1 - 3 above

  2. Restore the backup following Heroku's official guide

If you've gone any questions or issues with downloading, decrypting or restoring a database, please contact us at support@eppalock.com.

Last updated