Postgres logs to syslog LOCAL0

From: han(dot)holl(at)informationslogik(dot)nl
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres logs to syslog LOCAL0
Date: 2005-10-14 10:24:31
Message-ID: 200510141224.31711.han.holl@informationslogik.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general


Hi,

I've noticed that, even though I specified LOCAL5 as syslog facility, postgres
nevertheless logs _some_ events to LOCAL0.
Log lines look like:
Oct 14 08:55:02 pavenlo root palga [local] SELECT: [17-1] LOG: duration: \
2953.658 ms statement: select rapnaam from udps where ((geboortedatum = \
'1954-01-21') and (naamman ~ '^thie'))
Oct 14 08:55:02 pavenlo root palga [local] SELECT: [17-2] limit 1000

(It's a bit messy). Anyway, the essentila difference is the SELECT: entry
which is not present in regular logging to LOCAL5.
These events are _not_ reported in LOCAL5.

Because it's shorter that a complet postgresql.conf,here's the diff against
/usr/share/pgsql/postgresql.conf.sample, from postgresql-8.0.3-1PGDG for RH9.

Have I missed something ?

Cheers,

Han Holl

--- /usr/share/pgsql/postgresql.conf.sample 2005-09-22 15:49:14.000000000
+0200
+++ /u/postgres/postgresql.conf 2005-10-14 00:08:55.000000000 +0200
@@ -45,7 +45,7 @@

# - Connection Settings -

-#listen_addresses = 'localhost' # what IP interface(s) to listen on;
+listen_addresses = '*' # what IP interface(s) to listen on;
# defaults to localhost, '*' = any
#port = 5432
#max_connections = 100
@@ -86,7 +86,7 @@
# - Kernel Resource Usage -

#max_files_per_process = 1000 # min 25
-#preload_libraries = ''
+preload_libraries =
'/usr/prod/postgres/rubriek:rub_initialize,/usr/prod/postgres/drap,/usr/prod/postgres/naam'

# - Cost-Based Vacuum Delay -

@@ -173,7 +173,7 @@

# - Where to Log -

-#log_destination = 'stderr' # Valid values are combinations of stderr,
+log_destination = 'syslog' # Valid values are combinations of stderr,
# syslog and eventlog, depending on
# platform.

@@ -197,7 +197,7 @@
# so many kilobytes of log output. 0 to disable.

# These are relevant when logging to syslog:
-#syslog_facility = 'LOCAL0'
+syslog_facility = 'LOCAL5'
#syslog_ident = 'postgres'


@@ -218,7 +218,7 @@
# debug5, debug4, debug3, debug2, debug1,
# info, notice, warning, error, panic(off)

-#log_min_duration_statement = -1 # -1 is disabled, in milliseconds.
+log_min_duration_statement = 500 # -1 is disabled, in milliseconds.

#silent_mode = false # DO NOT USE without syslog or redirect_stderr

@@ -239,7 +239,7 @@
# %s=session start timestamp %x=transaction id
# %q=stop here in non-session processes
# %%='%'
-#log_statement = 'none' # none, mod, ddl, all
+log_statement = 'none' # none, mod, ddl, all
#log_hostname = false


@@ -278,7 +278,7 @@

# - Locale and Formatting -

-#datestyle = 'iso, mdy'
+datestyle = 'iso, dmy'
#timezone = unknown # actually, defaults to TZ environment setting
#australian_timezones = false
#extra_float_digits = 0 # min -15, max 2

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2005-10-14 11:52:21 Re: [PATCHES] [BUGS] BUG #1962: ECPG and VARCHAR
Previous Message tadayoshi sato 2005-10-14 08:17:58 BUG #1967: Respons(Binary) is not correctly by PQexecParams

Browse pgsql-general by date

  From Date Subject
Next Message Zlatko Matic 2005-10-14 10:30:06 Re: user privilages for executing pg_autovacuum?
Previous Message Richard Huxton 2005-10-14 07:34:31 Re: installation guide