This document outlines the steps to configure the PostgreSQL Plug-in in SnapCenter Server.
Perform the following steps to configure the PostgreSQL plug-in:
1.Upload plug-in: Upload PostgreSQL plug-in package to SnapCenter Server from the Add or Modify host
page.
2.Add or Modify host: Add PostgreSQL host and select the PostgreSQL plug-in to upload to the host.
3.Add resource: After the host is added, add the resource.
•Resource Name: For Tablespace resource type, the resource name should be the same as the tablespace name present on the host. For Cluster resource type, there is no restriction for the resource name.
•Resource Type: Following are the two types of resources available in PostgreSQL plug-in:
Tablespace: Individual tablespaces can be configured to be on a mount point.
Cluster: Database cluster is a single directory (mount point) where all the data will be stored.
4.Storage Footprint Details: The resource should contain storage details of all the databases it contains.
5.Resource Settings: The path of psql should be set in the PATH variable of the host. For example, echo $PATH /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/opt/PostgreSQL/10/bin/psql
----------------------
Available parameters:
----------------------
USER: PostgreSQL username specifies the operating system user who can run the psql command.
PSQL_CMD: Specifies the path to the PostgreSQL psql command. For example, /opt/PostgreSQL/10/bin/psql
NO_PASSWORD_OPTION(Y|N): Enables or disables the use of PostgreSQL user password. If this option is set to Y, the database user will not require a password, if it is set to N, it will read the password from PostgreSQL configuration. By default, the value is set to “N”.
ARCHIVE_LOGGING_ENABLED (Y|N): Enables or disables archiving of the database data files, which are required to achieve point-in-time recovery. As the data files are created at cluster level, this option applies to Cluster Resource Type only. PostgreSQL does not support point-in-time recovery at Tablespace level and hence for Resource Type Tablespace, there is no usage of this parameter. By default, the value is set to "Y". |