Eppalock
  • Eppalock
  • Install via Heroku Elements
  • Heroku Documentation
    • Provisioning the Addon
    • Setup
  • Backups
    • Restore
    • Encryption Key
  • Support
    • Contacting Support
    • Changelog
Powered by GitBook
On this page
  • Local Database
  • Heroku Database
  1. Backups

Restore

PreviousEppalockNextEncryption Key

Last updated 5 months ago

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. following Heroku's official guide

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

Restore the backup
support@eppalock.com