backup: Initial support for 'restore'.

Still needed:
 - Postgres truncate/reset support.
 - Unittests.