Why both?: /var/log/messages AND /var/log/pgsql.

From: ow <oneway_111(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Why both?: /var/log/messages AND /var/log/pgsql.
Date: 2003-11-29 10:48:43
Message-ID: 20031129104843.61030.qmail@web21408.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Davis 2003-11-29 11:56:01 Re: Misplaced modifier in Postgresql license
Previous Message Randolf Richardson 2003-11-29 04:06:54 Re: [ADMIN] Misplaced modifier in Postgresql license