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:
ERROR
WARNING
NOTICE
INFO
LOG
DEBUG1
DEBUG2
DEBUG3
DEBUG4
DEBUG5
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