V11 SP8
Loading...

IntelliSnap - Configuration - PostgreSQL iDataAgent

Configuration

The following sections provide the necessary steps required to create and configure the components for a first IntelliSnap backup of a PostgreSQL database.

Enabling IntelliSnap on the Client

Since IntelliSnap backup is supported only for FSBasedBackupSet, so use the default subclient of FSBasedBackupSet to enable IntelliSnap on the client.

  1. From the CommCell Browser:

    Navigate to Client Computers | <Client>.

    Right-click the <Client>and select Properties.

  2. In the Client Computer Properties window:

    Click Advanced.

    Select the Enable IntelliSnap option to enable IntelliSnap backup for the client.

    Click OK.

Creating a New PostgreSQL Instance

  1. From the CommCell Browser, navigate to Client Computers | <Client>.

    Right-click PostgreSQL, point to All Tasks, and then click New PostgreSQL Instance.

  2. In the Instance Name box, type the PostgreSQL instance name.
  3. In the PostGres User Name box, type the user name to access the Postgres application.

    In the PostGres User Password box, type the user account password.

    In the PostGres Confirm Password box, retype the password.

  4. In the Maintenance DB box, type the name of a system database which is used as Maintenance DB.
  5. In the Binary Directory box, type the path to the directory where the PostgreSQL application files are stored.

    For example,

    /opt/bin

    Alternatively, click Browse to select the location.

  6. In the Lib Directory box, type the path to the library directory for the instance.

    For example,

    /opt/PostgreSQL/8.4/lib

    Alternatively, click Browse to select the location.

  7. In the Archive Log Directory box, type the path to the directory where you want to store the archive log files.

    For example,

    /opt/wal

    Alternatively, click Browse to select the location.

  8. In the Port box, type or select the port to open the communication between PostgreSQL Server and the clients.

  9. In the Log Backup Storage Policy box, select a storage policy to be used for the transaction log backup jobs under Log Backup section.
  10. Click OK.
  11. From the CommCell Browser, navigate to Client Computers | <Client> | PostgreSQL | <Instance> | FSBasedBackupSet.

    Right-click the default Subclient, and then click Properties.

  12. Click the Storage Device tab.

    In the Storage Policy box, select a storage policy.

    In the Number of Data Backup Streams box, type the number of streams.

    Note: The data backup streams are used only for backup copy operations.

    Click OK.

    If you do not have Storage Policy created, follow step 16 to create a storage policy.
  13. From the Subclient Properties dialog box,

    Click the IntelliSnap Operations tab.

    Select the IntelliSnap option.

    From the Available Snap Engines list, select the engine that matches your snapshot type. For a list of available engines for your array, see Snapshot Engine.

    From the Use Proxy list, select the MediaAgent where IntelliSnap and backup copy operations will be performed.

    When performing IntelliSnap backup using proxy, ensure that the operating system of the proxy server is either same or higher version than the client computer.

    Click OK.

    For clustered environments, ensure the proxy you want to select is not part of a cluster setup.

    • PostgreSQL application is not required to be installed on the proxy server.
    • The IntelliSnap backup operation backs up the data of the entire server (entire datadir).
    • For an IntelliSnap subclient, the Content tab is disabled, hence the content cannot be discovered or configured.

  14. From the Subclient Properties dialog box,

    Click the Storage Device tab.

    If you do not have Storage Policy created, follow the step given below to create a storage policy.
    1. Click Create Storage Policy.
    2. Follow the prompts displayed in the Storage Policy Wizard. The required options are mentioned below:
      1. Select the Storage Policy type as Data Protection and Archiving and click Next.
      2. Enter the name in the Storage Policy Name box and click Next.
      3. From the Library list, click the name of a disk library to which the primary copy should be associated and then click Next.

        Ensure that you select a library attached to a MediaAgent operating in the current release.

      4. From the MediaAgent list, click the name of a MediaAgent that will be used to create the primary copy and then click Next.
      5. For the device streams and the retention criteria information, click Next to accept default values.
      6. Select Yes to enable deduplication for the primary copy.
      7. From the MediaAgent list, click the name of the MediaAgent that will be used to host the Deduplication database (DDB).

        In the Location box, type the name of the folder in which the DDB must be located or click the Browse to select the folder, and then click Next.

      8. Review the details and click Finish to create the Storage Policy.

Skip this section if you already created a snapshot copy, and continue to the next page.

Creating a Snapshot Copy

The following section provides step-by-step instructions for creating a Snapshot Copy for a Storage Policy.

  1. From the CommCell Browser, navigate to Policies | Storage Policies.

    Right-click the <Storage_Policy> and click All Tasks | Create New Snapshot Copy.

  2. Specify the following to create a Snapshot Copy:
    1. Type the Copy Name in the Copy Name box.
    2. From the Library list, select the name of Library.
    3. From the MediaAgent list, select the name of a MediaAgent.
    4. From the Drive Pool list, select the name of a Drive Pool.
    5. From the Scratch Pool list, select the name of the Scratch Pool.

      Drive Pool and Scratch Pool are not applicable for disk libraries.

    6. Click OK.

The newly created Snapshot Copy can be associated with the subclient from which the snap backup is performed. In this case, the Snapshot Copy acts as the primary copy and therefore will contain only the metadata information associated with the snapshot Backup.

To configure the snapshot copy, see Storage Policy Copy Configuration. Note that alternate data path failover is not supported for IntelliSnap.