To monitor messages output by Symfoware Server using software, configure the product to monitor SQLSTATE, instead of the message text - this is because the latter may change when Symfoware Server is upgraded.
Configure Symfoware Server to output messages in a format that can be read by the message-monitoring software by specifying "%e" in the log_line_prefix parameter of postgresql.conf to output the SQLSTATE value.
A setting example is shown below - it outputs the output time, executing host, application name, and user ID, in addition to the SQLSTATE value.
log_line_prefix = '%e: %t [%p]: [%l-1] user = %u,db = %d,remote = %r app = %a '
See
Refer to "What To Log" in the PostgreSQL Documentation for information on how to configure the settings.
