Pivotal Knowledge Base

Follow

Email Notifications Not Generated for Greenplum Alerts

Environment

Pivotal Greenplum (GPDB): 4.3.x

OS: RHEL 6.x

Symptom

To configure an email notification, customer should use the command below:

http://gpdb.docs.pivotal.io/4320/admin_guide/monitor.html#topic11

The email notification can be tested by using, pg_elog:

$ psql template1
=# SELECT gp_elog('Test GPDB Email',true); gp_elog

Error Message

There is no error message, but the email notification is not sent. 

Cause 

$MASTER_DATA_DIRECTORY/postgresql.conf has an incorrect value for email values.

Resolution

In this case, it was the incorrect value for 'gp_email_from'. The value didn't follow a standard email address name convention.

Change the value from:

gp_email_from = 'mail_address_to_customer_support'

To:

gp_email_from = 'mail_address_to_customer_support@customerdomain.com'

 

Comments

Powered by Zendesk