The problem may be in your /etc/syslog.conf file. It directs different
classes of messages different places, and can direct them to another
machine.
Rick
"David Klugmann"
<dklugmann@xxxxxxxxxxx> To: pgsql-general@xxxxxxxxxxxxxx
Sent by: cc:
pgsql-general-owner@pos Subject: Problem getting sql statement logging to work
tgresql.org
01/18/2005 10:05 AM
Hi
I am trying to log my sql statements to the syslog file.
I have the following entries in my postgresql.conf file yet it doesn't seem
to log anything.
The OS is Solaris 9
I am looking at /var/adm/messages and can't see anything from Postgres and
I
have run lots of sql.
I saw one article on the web which suggested setting debug_print_query =
on.
Is this an alternative way of setting logging ?
Thanks for any help.
David Klugmann
# - 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_duration = false
#log_pid = false
log_statement = true
#log_timestamp = false
#log_hostname = false
#log_source_port = false
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
