client_min_messages

A system parameter controlling message levels sent to the client

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

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

Categories

GUC configuration item, Logging

See also

log_min_messages