Hi List;

Anyone have any thoughts per which logging method (SYSLOG vs STDERR) is the
better approach ?

Thanks in advance...

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Kevin Kempter sayeth...
>
> Hi List;
>
> Anyone have any thoughts per which logging method (SYSLOG vs
> STDERR) is the
> better approach ?
>

From looking at 8.2.1 source the internal postgres stderr redirect
method only does line buffering which explains why we see a performance
gain when we turn logging off or have it use syslog instead.

Syslog with the '-' option in front of the log file in syslog.conf is a
good option. As I understand it, ulog is also a good option but I
haven't any experience with it.

Logging when the individual log entry is buffered does present a risk of
losing a log entry on a system crash but for the purposes of Postgres I
would think that such a system crash would have been caused by something
external to Postgres and the loss of any logs in this case is okay.

Greg

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings