Email notifications not generated for Greenplum Alerts

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:

Email notifications for Greenplum Alerts are not generated or sent.

Environment

Cause

$MASTER_DATA_DIRECTORY/postgresql.conf has incorrect email values.

Resolution

See Monitoring a Greenplum System for more detailed information regarding Greenplum database monitoring.

To configure an email notification, follow the instructions described in Enabling Email Notifications.

To test email notifications, follow the instructions in Testing Email Notifications.

NOTE: The email address specified in gp_email_to must be in the correct format. Refer to the correct email format below:

[email protected]

This configuration will not affect email notifications from the gpbackup and gpcrondump Greenplum utilities.

These utilities use the OS commands to send emails and will require OS email relays, such as sendmail, to be configured.

The configuration of sendmail or other email relay services should be done in consultation with the host System Administrator.