Skip to main content
SnapCenter software

Configure credentials for the PostgreSQL cluster

Contributors netapp-yvonneo
PDFs

You must configure the cluster user credentials for the PostgreSQL cluster to perform data protection operations.

Before you begin

  • If the PostgreSQL cluster does not have valid credentials configured, a red padlock icon appears only for the autodiscovered resources. If during a subsequent discovery operation, the configured credentials were found to be incorrect or did not provide access to the cluster itself, then the red padlock icon will reappear.

  • You must configure valid PostgreSQL cluster credentials to be able to protect the resource or add it to a resource group to perform data protection operations.

  • The PostgreSQL user configured in the credentials must have sufficient privileges to access the cluster and perform backup and restore operations. At a minimum, the user should have the SUPERUSER role or equivalent privileges (such as pg_read_all_data, pg_write_all_data, and replication permissions).

  • SnapCenter uses the configured credentials to connect to the PostgreSQL instance via the psql or libpq client. Ensure that the PostgreSQL client tools are installed on the plug-in host.

Note Before configuring the cluster, you must first add the PostgreSQL credentials to SnapCenter.
Steps

  1. In the left navigation pane, select Resources and then select SnapCenter Plug-in for PostgreSQL cluster from the list.

  2. In the Resources page, select the resource type from the View list.

  3. (Optional) Select filter icon and select the host name.

    You can then select filter icon to close the filter pane.

  4. Select the cluster, and then select Configure credentials.

  5. Select the credential that has been configured in SnapCenter for the PostgreSQL cluster user. The credential must include a valid username and password with sufficient privileges to perform data protection operations.

  6. Select OK.

You can modify the cluster configuration from the Topology page.