I tested LOCAL5 here and got lines like: Oct 14 08:41:06 candle postgres[8668]: [1-1] LOG: duration: 1.210 ms statement: select 100; I don't see any SELECT: entry in there. In fact, SELECT: is coming from syslog, not from PostgreSQL. We only generate the stuff after the closing ]. --------------------------------------------------------------------------- han.holl@xxxxxxxxxxxxxxxxxxxx wrote: > > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > -- Bruce Momjian | http://candle.pha.pa.us pgman@xxxxxxxxxxxxxxxx | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
