Step 4: Adjust Postgres log_line_prefix
By default Azure uses
%t-%c- as the
log_line_prefix setting. Whilst we support this setting,
we recommend you utilize the following
log_line_prefix parameter value instead:
log_line_prefix = '%m [%p] %q[user=%u,db=%d,app=%a] '
You can change this setting in the "Server parameters" section of your database. Please note the trailing space in the parameter value, which is required.
The correct setting for
log_line_prefix ensures that the collector can associate each log line
to the correct session, database and username.
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →