This section explains the settings necessary to monitor errors in applications and operations, and to make discovering the causes easier.
Make error log settings only when instances are created with the initdb command.
When creating instances with WebAdmin, these settings are already made and hence do not need to be set.
Furthermore, some parameters are used by WebAdmin, and if changed, may cause WebAdmin to no longer work properly. Refer to "Appendix D Configuring Parameters" for details.
Note
Set the output destination for the system log to the server log so that it cannot be viewed by administrators of other instances.
Application errors are output to the system log or server log. The output destination directory for the system log and server log should have access permissions set so that they cannot be viewed by people other than the instance administrator.
Edit the following parameters in postgresql.conf:
Parameter name | Parameter description | How to enable the settings |
|---|---|---|
syslog_ident | Used to specify labels to attach to messages, so that these can be identified when output to the system log if more than one Fujitsu Enterprise Postgres is used. | reload option of the pg_ctl mode |
logging_collector | Specify "on" to ensure that messages are output by Fujitsu Enterprise Postgres to the server log file. The server log file is created in the log directory in the database cluster. | restart option of the pg_ctl mode |
log_destination | Specify "stderr,syslog" to output messages from Fujitsu Enterprise Postgres to the screen and either the system log or the event log. | reload option of the pg_ctl mode |
log_line_prefix | Specify information to be added at the start of messages output by an instance. This information is useful for automatic monitoring of messages. You can output the SQLSTATE value, output time, executing host, application name, and user ID. Refer to "What To Log" in the PostgreSQL Documentation for details. Example: log_line_prefix = '%e: %t [%p]: [%l-1] user = %u,db = %d,remote = %r app = %a ' | reload option of the pg_ctl mode |
Point
If you want fewer application errors being output to the system log, refer to "When To Log" and "What To Log" in the PostgreSQL Documentation for information on how to reduce the output messages.
If you want to separate errors output from other software, refer to "Where To Log" in the PostgreSQL Documentation to change the output destination to the server log file rather than the system log.
