postgresql-conf.patch

   1 --- postgresql-8.1.0/src/backend/utils/misc/postgresql.conf.sample.orig 2005-10-08 20:32:58.000000000 +0100
   2 +++ postgresql-8.1.0/src/backend/utils/misc/postgresql.conf.sample      2005-11-11 16:11:18.000000000 +0000
   3 @@ -206,7 +206,7 @@
   4
   5  # - Where to Log -
   6
   7 -#log_destination = 'stderr'            # Valid values are combinations of
   8 +log_destination = 'syslog'             # Valid values are combinations of
   9                                         # stderr, syslog and eventlog,
  10                                         # depending on platform.
  11
  12 @@ -235,8 +235,8 @@
  13                                         # output.  0 to disable.
  14
  15  # These are relevant when logging to syslog:
  16 -#syslog_facility = 'LOCAL0'
  17 -#syslog_ident = 'postgres'
  18 +syslog_facility = 'LOCAL0'
  19 +syslog_ident = 'postgres'
  20
  21
  22  # - When to Log -
  23 @@ -292,10 +292,10 @@
  24  #debug_print_rewritten = off
  25  #debug_print_plan = off
  26  #debug_pretty_print = off
  27 -#log_connections = off
  28 +log_connections = true
  29  #log_disconnections = off
  30  #log_duration = off
  31 -#log_line_prefix = ''                  # Special values:
  32 +log_line_prefix = '<%p> '                      # Special values:
  33                                         #   %u = user name
  34                                         #   %d = database name
  35                                         #   %r = remote host and port