# Adding a PostgreSQL Database Server

You can add a new database server so that you can protect PostgreSQL databases.

## Procedure

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

   The database Overview page appears.

2. Click Add server from the upper-right corner of page.

   The Select Database Type page appears.

3. Select PostgreSQL, and then click Next.

   The Configure database server page appears.

4. Install the database server package using either the Interactive installation or Push installation method:

   - To install software interactively on database servers, select Interactive installation and then complete the following steps:

     1. To select a backup gateway, move the Select backup gateway toggle key to the right and select a backup gateway from the list, or add a new backup gateway and then select it.

     2. Download and install the PostgreSQL database server package on the PostgreSQL database server to be protected.

     3. Install the PostgreSQL database server package on the server you want to back up and authenticate using the authcode.

     4. Return to this window after the agent installation has completed.

     5. From the Server name list, select the newly installed servers after completing the agent installations.

   - To install client software on database servers using the push method, select Push installation and then complete the following steps:

     1. Click Add.

        The Add database server dialog box appears.

     2. In the Host name box, enter the host name of the database.

     3. Select the OS type.

        - Windows:

          1. To select a software cache from which to push agent packages, from the Software cache list select a server.

          2. To use saved credentials, move the Use saved credentials toggle key to the right.

             From Credential list, you can select a saved credential or add a new credential.

             Steps to add a credential

             1. Click +.

                The Add Credential dialog box appears.

             2. From the Credential Vault list, select a credential vault to store, share, and update account credentials with shared resources in your environment.

             3. In the Credential name box, enter a unique name to access the credential.

             4. In the User account box, enter the user account that has access to the PostgreSQL server.

             5. In the Password box, enter the password for the user account.

             6. In the Description box, enter a brief description for the credential.

             7. Click Save.

        - Unix and Linux:

          1. To select a software cache from which to push agent packages, from the Software cache list select a server.

             The software cache works as a network gateway between the server and client.

          2. To use saved credentials, move the Use saved credentials toggle key to the right.

             From the Credential list, you can select a saved credential or add a new credential.

             Steps to add a credential

             1. Click +.

                The Add Credential dialog box appears.

             2. From the Credential Vault list, select a credential vault to store, share, and update account credentials with shared resources in your environment.

             3. In the Credential name box, enter a unique name to access the credential.

             4. In the User account box, enter the user account that has access to the PostgreSQL server.

             5. To use an SSH key, move the Use SSH key toggle to the right and then enter the SSH key path.

             6.In the Password/Passphrase box, enter the password for the user account.

             1. Click Save.

          3. In the SSH port number box, enter the port number.

          4. To use an SSH key, move the Use SSH key toggle to the right and then enter the SSH key path.

          5. To grant write access to processes that belong to a specific group, in the UNIX group box, enter the UNIX group name.

     4. In the Installation location box, enter the installation path of the server.

     5. You can configure the following option during installation by moving the corresponding toggle keys:

        1. Install MediaAgent

        2. Restore only agent

        3. Reboot if required

     6. Click Install.

     7. When the install jobs are complete, from the Server name list, select the newly installed servers.

5. Click Next.

   The Select A Plan dialog box appears.

6. Select an existing backup plan or create a backup plan for PostgreSQL. For more information about backup plan backup plan creation, refer to create backup plan.

   The backup plan defines how often the software backs up the database and the log files, and where it stores the backups.

7. Click Next.

   The Summary page appears.

8. Review the summary and click Finish to add the PostgreSQL database server.

## Result

The system does the following:

- Installs the appropriate Commvault software packages on the server.

- Discovers the database instances and adds them to the Commvault configuration.

- Creates the appropriate database groups for the instance.

×

Loading...