pgSql 7.4.0 on RH7.3
Hi,
It appears that pgSql somehow logs messages to BOTH /var/log/messages and
/var/log/pgsql. I expected that it would only log to /var/log/pgsql.
Any ideas? Thanks
-----------------------------------------------------------------
/etc/syslog.conf
# Save postgresql logs
local0.* /var/log/pgsql
-----------------------------------------------------------------
/var/lib/pgsql/data/postgresql.conf
# - Syslog -
#syslog = 0 # range 0-2; 0=stdout; 1=both; 2=syslog
syslog = 2 # range 0-2; 0=stdout; 1=both; 2=syslog
#syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'
# - When to Log -
#client_min_messages = notice # Values, in order of decreasing detail:
# debug5, debug4, debug3, debug2, debug1,
# log, info, notice, warning, error
#log_min_messages = notice # Values, in order of decreasing detail:
# debug5, debug4, debug3, debug2, debug1,
# info, notice, warning, error, log, fatal,
# panic
#log_error_verbosity = default # terse, default, or verbose messages
#log_min_error_statement = panic # Values in order of increasing severity:
# debug5, debug4, debug3, debug2, debug1,
# info, notice, warning, error, panic(off)
#log_min_duration_statement = -1 # Log all statements whose
# execution time exceeds the value, in
# milliseconds. Zero prints all queries.
# Minus-one disables.
#silent_mode = false # DO NOT USE without Syslog!
# - What to Log -
#debug_print_parse = false
#debug_print_rewritten = false
#debug_print_plan = false
#debug_pretty_print = false
#log_connections = false
log_connections = true
#log_duration = false
log_duration = true
#log_pid = false
log_pid = false
#log_statement = false
log_statement = true
#log_timestamp = false
log_timestamp = true
#log_hostname = false
log_hostname = true
#log_source_port = false
log_source_port = true
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
