Creating an Instant Clone for PostgreSQL

Updated

You can create a clone from an IntelliSnap backup or a block-level full backup.

Before You Begin

  • The version of PostgreSQL server must be the same on both the source client and the destination client.

  • The PostgreSQL user must have the same user ID on both the source database server and the destination database server.

  • The Commvault package and the MediaAgent must be installed on the destination client.

  • On the destination client, create a working directory to use as the mount path for the database clone files. This directory must be writable by the PostgreSQL user.

  • The working directory must have enough space for the cloned server.

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. On the Instant clones tab, click Instant clone.

    The Instant clone page appears.

  3. Click PostgreSQL.

    The Instant clone dialog box appears.

  4. From the Source server list, select the client that contains the instance that you want to clone.

  5. From the Instance name list, select the instance that you want to clone.

  6. From the Destination server list, select the client where you want to clone the server.

  7. For the Instance name list, specify the binary directory and database user for the clone:

    • To use the binary directory, the library directory and the database user of an existing instance for the clone server, select the instance.

    • To specify the location for the binary directory, the library directory and the database user for the clone server, select Custom.

  8. In the Recover options section, specify the backup to recover:

    • To recover the most recent backup operation, select Most recent backup.

    • To recover a specific backup, select Point in time, and then enter the date and time the backup ran.

  9. In the Destination options section, enter the directory and port information:

    1. In the Clone working directory box, enter the location to create the clone in.

    2. Enter the port that you want the source instance to use.

      Verify that the port is not in use.

  10. In the Clone options section, specify the time period to retain the clone for.

    After the time period expires, the clone server is dismounted and the mount point is deleted. By default, the clone is retained for 24 hours.

  11. To overwrite an existing clone instance that uses the same port number as the clone that you want to create, select the Overwrite if clone exists check box.

  12. To run a script after the clone is created, in the Post clone operation section, enter the path to the script.

  13. Click OK.