Getting Started with Azure Database for PostgreSQL

To get started, you need to configure the following clients in the CommCell Console:

  • A MediaAgent

  • A proxy server

  • An Azure virtualization client

Step 1: Before You Begin

Step 2: Install the MediaAgent

You must install a MediaAgent. For more information, see MediaAgent Installations.

Step 3: Create a Proxy Client

  1. Create a Windows or a UNIX client. For more information, see Creating a Proxy Client for Azure Data Protection.

    Note

    If you configure a Linux client computer, the Mono package is required on the client computer.

    For SP17 and more recent service packs, after you install the Virtual Server Agent on a Linux machine and start services, the software checks to see whether Mono is installed and, if necessary, installs the required version of the Mono package. You do not need to install the Mono package manually.

  2. For enhanced performance, configure an Azure database instance on the proxy server. For more information, see Performing the Azure Configuration for the Azure Proxy Server.

  3. Install, and then configure the PostgreSQL Agent software on the proxy client computer.

    The software also installs the PostgreSQL database binaries of versions 12.x to 17.x on the proxy client computer.

    The database application must be of the same major version as the PostgreSQL server instance in the cloud and does not need to be in a running state.

    Installation path for PostgreSQL binaries for Linux is software_installation_directory/CVCloudAddOns/PostgreSQL/postgres_version, and for Windows is software_installation_directory\CVCloudAddOns\PostgreSQL\postgres_version.

Step 4: Initial CommCell Console Configuration

  1. Open the CommCell Console.

  2. Configure a storage device. For more information, see one of the following:

  3. Create a storage policy.

  4. Optional: Decide whether to add the following functionality:

Step 5: Configure the Azure Virtualization Client

  1. Create a virtualization client.

  2. Add the PostgreSQL Agent software to the virtualization client. For more information, see Adding the Commvault Database Agent to the Azure Virtualization Client.

  3. Configure a PostgreSQL instance. For more information, see Configuring a PostgreSQL Server Instance for an Azure Database.

  4. If you want to include a subset of the databases in the backup, then create a subclient for the data. For more information, see Creating PostgreSQL Subclient for an Azure Database.

Note

The supported TLS versions to create Azure SSL encrypted PostgreSQL instances are TLS 1.0, 1.1 and 1.2.

Step 6: Run the First Backup Operation and Restore Operation

Note

  • For Azure database for PostgreSQL Flexible Servers, by default, the pg_cron extension is enabled and the schema that is named as cron is created in the postgres database where the pg_cron metadata is saved. Since the Azure Server administrator will not have the privilege to dump/drop/restore the schema, the postgres database backups fail. Hence, the postgres database backup will be skipped from the backups of Azure PostgreSQL Flexible Servers.

  • If cron.database_name is set to a different database, you must create a new subclient in order to skip the database from backups.

×

Loading...