trace_recovery_messages Developer Parameter

Type: enum
Default: log
Context: sighup
Restart: false
Values: [debug5, debug4, debug3, debug2, debug1, log, notice, warning, error]

Enables logging of recovery-related debugging output that otherwise would not be logged. This parameter allows the user to override the normal setting of log_min_messages, but only for specific messages. This is intended for use in debugging hot standby. Valid values are DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, and LOG. The default, LOG, does not affect logging decisions at all. The other values cause recovery-related debug messages of that priority or higher to be logged as though they had LOG priority; for common settings of log_min_messages this results in unconditionally sending them to the server log. This parameter can only be set in the postgresql.conf file or on the server command line.

Recommendations

For troubleshooting replication/PITR failures.

Comments