Pivotal Knowledge Base

Follow

Email Notifications Not Generated for Greenplum Alerts

Environment

 Product  Version
 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