Loading...

Instant Application Recovery for PostgreSQL Server

You can duplicate a source server by cloning the snapshots created during backup. This operation, referred as cloning, utilizes the cloning capability of the storage array hardware, which enables you to duplicate large servers within a short period of time. Clones can be used for multiple purposes, such as:

  • As test environments to troubleshoot issues found in the production server.
  • Quick data retrieval without running resource intensive restores on the production environment and without requiring additional space on destination server.
  • Alleviate load from the production servers for running reports and queries.

Currently, clone restore is supported on Linux platform only. A clone can be created from an existing SnapProtect or a block-level full backup job. During the clone creation, a reservation period is specified by the user. At the end of the period, the system automatically shuts down the clone server and frees up all resources, including snapshot clones on the storage array. The cloning operation can also be scheduled to run periodically to allow the clones to get refreshed from the latest backups on a regular basis.

Prerequisites

  • The PostgreSQL server version on the destination client must be the same as the one in the source client.
  • The PostgreSQL user in both the source and destination database servers must have the same user ID.
  • The PostgreSQL Agent and the MediaAgent must be installed on the destination client.
  • On the destination client where you plan to create the clone database, create a directory to be used as the mount path for the database clone files. This directory must be writable by the PostgreSQL user.
  • The Clone Working Directory should have minimum space for the cloned server.

Procedure

Use the following steps to create a clone environment from existing snapshots:

  1. From the CommCell Browser navigate to the Client Computers | client | PostgreSQL.
  2. Right-click the FSBasedBackupSet, and then click All Task | Clone.
  3. From the Clone Options dialog box, click View Content.
  4. From the browse window, click Clone.
  5. Note: By default, the entire server is selected. You cannot select individual databases here.

    The PostgreSQL Clone Options dialog box is displayed
  6. Under the Clone Options tab, from the Destination Client list, select a client where you want to clone the server.
  7. From the Instance Name list, you can either select an instance from the list or leave the box blank by not selecting any instance.
    • To clone an instance that is added to the CommCell Console, from the list, select the instance name that you want to clone.

      Binary Directory, Library Directory and Unix UserName boxes are grayed out because that information is already present the CommCell Console.

    • To clone an instance that is not added to the CommCell Console, do not select any instance name from the list.

      Type or browse the location for Binary Directory and Library Directory of the instance that you are cloning. Also type the Unix UserName for the instance.

  8. Type or select a port number that the selected instance will use for communication purpose. Verify that the selected port number is not in use.
  9. Type or browse a location for the Clone working directory. The selected instance will be cloned at this location.
  10. Specify the Reservation Period for which you would like to retain the test environment.

    By default, the clone environment will be retained for 24 hours. Once the specified reservation period expires, the clone server is dismounted and the mount point is deleted.

  11. Optional: Select the Overwrite if clone exists check box if you want to overwrite an existing clone instance that uses the same port number as the new clone that you want to create.
  12. From the Restore Time box, select a date and a time. From the Time Zone list, select the time zone of the destination client that you have selected.
  13. Click OK.