Re: syslog_line_prefix - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: syslog_line_prefix
Date
Msg-id 4AC111E1.3030105@dunslane.net
Whole thread Raw
In response to Re: syslog_line_prefix  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: syslog_line_prefix
List pgsql-hackers

Alvaro Herrera wrote:
> Tom Lane escribió:
>   
>> Alvaro Herrera <alvherre@commandprompt.com> writes:
>>     
>>> Tom Lane escribió:
>>>       
>>>> This is the same issue already raised with respect to syslog versus
>>>> syslogger, ie, some people would rather lose log data than have the
>>>> backends block waiting for it to be written.
>>>>         
>>> That could be made configurable; i.e. let the user choose whether to
>>> lose messages or to make everybody wait.
>>>       
>> Hmm, I guess I missed where you proposed an implementation that would
>> support that?
>>     
>
> syslog uses a nonblocking file descriptor without a retry loop to
> implement their logic.  I see no reason we couldn't do that ourselves.
> Mixing it with regular blocking code could turn out to be nontrivial,
> but I don't think it's impossible.
>
>   

Well, for CSV logs it's a complete non-starter. We go to quite a deal of 
trouble to ensure we don't miss messages, because if we do the CSVs will 
be hopelessly corrupted.

Frankly, if you're generating so much log output that blocking is going 
to become an issue you should probably just be using syslog on Unix anyway.


cheers

andrew



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] DefaultACLs
Next
From: Stef Walter
Date:
Subject: Re: pg_hba.conf: samehost and samenet [REVIEW]