Important Notice: ElephantSQL is shutting down. Read all about it in our End of Life Announcement

Point in time restore

Written by Anders Bälter

In addition to resetting and restoring to pg_dump backups you can now restore your instance to any point in time. This is done by resetting to our most recent base backup before the chosen time and then replaying the WAL. You find this option under the "Backup" tab.

You may also create new instances as a point in time recovery of a running instance. The most recent base backup, before the chosen time, will be restored on the target instance, WAL will be replayed until the target time is reached and promotion will take place.

From our customer portal fork your GCE instance into an AWS instance, or set up a Softlayer leader with an Azure follower.

Point-in-time recovery