Rewinding a PostgreSQL VDB
Datasets / PostgreSQL Environments and Data Sources / Provisioning and Managing VDBs from PostgreSQL dSources / Rewinding a PostgreSQL VDB

Rewinding a VDB rolls it back to a previous point in its Timeflow and re-provisions the VDB.  The VDB will no longer contain changes after the rewind point.

Although the VDB no longer contains changes after the rewind point, the rolled-over Snapshots and Timeflow still remain in Delphix and are accessible through the Command Line Interface (CLI). Refer to CLI Cookbook: Rolling Forward a VDB for instructions on how to use these snapshots to refresh a VDB to one of its later states after it has been rewound.
Delphix clones a new Timeflow from the closest Snapshot older than or equal to the rewind point. This creates a dependency between the new Timeflow and the parent Snapshot and Timeflow. The parent Snapshot and Timeflow cannot be deleted because of this dependency. The VDB must first be refreshed before the parent Snapshot and Timeflow can be removed.

Prerequisites

To rewind a VDB, you must have the following permissions:

A user with Delphix Admin credentials can perform a VDB rewind on any VDB in the system.

Procedure

  1. Login to the Delphix Management application.

  2. Under Datasets, select the VDB you want to rewind.

  3. On the Timeflow tab, select the rewind point as a snapshot or a point in time.

  4. Click Rewind.

  5. If you want to use login credentials on the target environment other than those associated with the environment user, click Provide Privileged Credentials.

  6. Click Yes to confirm.

    Using TimeFlow Bookmarks

    You can use a Timeflow bookmark as the rewind point when using the CLI. Bookmarks can be useful to:

    • Mark where to rewind to – for example, before starting a batch job on a VDB

    • Provide a semantic point to revert back to in case the chosen rewind point turns out to be incorrect.

    For a CLI example using a Timeflow bookmark, refer to CLI Cookbook: Provisioning a VDB from a Timeflow Bookmark.

Related Topics