Bruce Momjian wrote:Advertising
Do people want the server file logging/rotating patch applied if it is Unix-only? Right now the patch is ifdef'ed so Win32 use of it is disabled.
How is logging typically handled on Windows?
It is done using the eventlog service (which is supported as replacement for syslog now) or in case of MSSQL as file logging.
MSSQL in more detail:
In eventlog only the most important MSSQL messages will appear (start/stop, PANIC), while the rest is done in logfiles (retrievable over client tools, rotatable using sp_cycle_errorlog) and may grow much larger than eventlog (which will receive messages from all apps/services).
This handling is so throughout M$ apps, like webserver etc: fatals to eventlog, the rest to files.
Regards, Andreas
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
