Search Postgresql Archives

Re: Postgres logs to syslog LOCAL0

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux