client_min_messages
client_min_messages is a system parameter controlling message levels sent to the client.
client_min_messages was added in PostgreSQL 7.3.
Usage
client_min_messages can be set to one of the following values, in order of increasing amount of messages which will be generated:
ERRORWARNINGNOTICEINFOLOGDEBUG1DEBUG2DEBUG3DEBUG4DEBUG5
Each level includes the messages of the preceding levels, i.e. it is not possible to receive messages only for a particular log level.
FATAL and PANIC log levels cannot be set for client_min_messages, as these messages will never be sent to the client.
LOG level messages have a lower "rank" for client_min_messages than they do with log_min_messages. The documentation does not mention a reason for this, but given that LOG level messages can be quite frequent, it does make sense to rank them lower than more important messages.
Note that regardless of setting, INFO level messages are always sent to the client.
Default value
The default value for client_min_messages is: NOTICE.
Change history
- PostgreSQL 7.3
- added (commit a033daf5)
Examples
INFO level messages are always sent, even if client_min_messages is set to a higher level:
postgres=# SHOW client_min_messages; client_min_messages --------------------- notice (1 row) Time: 0.711 ms postgres=# REINDEX (VERBOSE) TABLE foo; INFO: index "foo_pkey" was reindexed DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s REINDEX
References
- PostgreSQL documentation: client_min_messages