21: PostgreSQL VDB Management

In the VDB work area, you do tasks for a golden image, a duplicate golden image, a VDB, and database snapshots. A golden image is a full synchronized copy of the source database files. A golden image is used to create VDBs. A snapshot is a read/write point-in-time copy of the golden image. This section describes how to do these tasks.

To open the VDB work area:

On the navigation bar, click VDB.

The VDB Management window appears.

To create VDB:

To create a VDB, see 21: PostgreSQL Initial Setup | Create and start a VDB.

To activate a GI:

Select the GI in the list.
Click Activate volume.

To remove a GI:

Select a GI in the list.
Click Remove Golden Image.

3. Click Remove to confirm the deletion or Cancel to exit with deleting the volume.

After the GI is removed, the following message appears: Golden Image (live) has been deleted.

To edit a GI:

Select the GI in the list.
Click Modify volume.

3. Enter a new Name.

4. To save your changes, click Modify. Otherwise, click Cancel.

After the change is done, the following message appears: Volume has been updated.

To see information about a GI:

Select the GI in the list.
Click Volume info.

The Info window appears.

3. To see the last logs, click Last Logs or click Cancel to return to the VDB Management window.

4. Click Auto-refresh to do an auto refresh.

5. To download the last logs, click Download or click Close to return to the VDB Management window.

6. To see the log history, click Log History or click Cancel to return to the VDB Management window.

7. Click Back or Cancel to return to the Info window.

List of snapshots

The list of snapshots is displayed on the right pane. The list is updated every time you select GI or VDB on the left pane. The snapshots are grouped by day. You can search for a specific snapshot using time filter or free text.

To recover to the first snapshot:

Select the source DB.
Click Recovery to first snapshot.

3. Click Recovery to confirm the recovery or Cancel to exit with recovering the snapshot.

To recover to this snapshot:

Select the snapshot.
Click Recovery to this snapshot.

3. Click Recover to confirm the recovery or Cancel to exit with recovering the snapshot.

To create a duplicate VDB from a snapshot:

Select the snapshot.
Click Create duplicate.

3. Enter a Name.

4. Click Create. Otherwise, click Cancel to exit without creating a duplicate VDB.

The VDB Management window displays the duplicate GI that has been created.

To remove a snapshot:

Select the snapshot.
Click Remove Snapshot.

3. Click Remove to confirm the deletion or Cancel to exit with deleting the snapshot.

VDB

This section describes additional tasks that are available to manage VDBs.

To start a VDB:

Select the VDB.
Click Start VDB.

3. Enter the VDB configuration parameters.

4. Enter Advanced Parameters if necessary.

5. Click Start VDB. Otherwise, click Cancel to exit.

To force stop the refresh of a VDB:

Select the VDB.
Click Force stop VDB.

To stop the refresh of a VDB:

Select the VDB.
Click Stop VDB.