Pivotal Greenplum (GPDB): 4.3.x
OS: RHEL 6.x
To configure an email notification, customer should use the command below:
The email notification can be tested by using, pg_elog:
$ psql template1 =# SELECT gp_elog('Test GPDB Email',true); gp_elog
There is no error message, but the email notification is not sent.
$MASTER_DATA_DIRECTORY/postgresql.conf has an incorrect value for email values.
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'
gp_email_from = 'email@example.com'