Re: What does log_destination = csvlog mean? - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: What does log_destination = csvlog mean?
Date
Msg-id 4A369D91.4030201@dunslane.net
Whole thread Raw
In response to What does log_destination = csvlog mean?  (Bruce Momjian <bruce@momjian.us>)
Responses Re: What does log_destination = csvlog mean?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers

Bruce Momjian wrote:
> In reading through our documentation, I am unclear how "log_destination
> = csvlog" works.  It seems to me that 'cvslog' is a format-output type,
> not a real destination, or rather it is a special output format for
> stderr.  Is this accurate?  I would like to clarify our documentation.
>
>   

CSV logs can in fact only be delivered via redirected stderr, i.e. 
csvlog requires that logging_collector be on. So in a sense it's both a 
format and a destination.

There is a strong technical reason for that, namely that only by doing 
that can be be sure that CSV logs won't get lines multiplexed, which 
would make loading them back into a table impossible. We invented a 
whole (simple) protocol between the backends and the syslogger just to 
handle that.

cheers

andrew


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: What does log_destination = csvlog mean?
Next
From: Bruce Momjian
Date:
Subject: Re: What does log_destination = csvlog mean?