I have moved more variables into the log_* GUC category in an attempt to make log control more understandable. Changes to postgresql.conf attached.
-- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Index: postgresql.conf.sample =================================================================== RCS file: /cvsroot/pgsql-server/src/backend/utils/misc/postgresql.conf.sample,v retrieving revision 1.53 retrieving revision 1.58 diff -c -c -r1.53 -r1.58 *** postgresql.conf.sample 8 Nov 2002 17:37:52 -0000 1.53 --- postgresql.conf.sample 15 Nov 2002 01:57:28 -0000 1.58 *************** *** 34,41 **** #superuser_reserved_connections = 2 #port = 5432 - #hostname_lookup = false - #show_source_port = false #unix_socket_directory = '' #unix_socket_group = '' --- 34,39 ---- *************** *** 112,118 **** # # Message display # ! #server_min_messages = notice # Values, in order of decreasing detail: # debug5, debug4, debug3, debug2, debug1, # info, notice, warning, error, log, fatal, # panic --- 110,116 ---- # # Message display # ! #log_min_messages = notice # Values, in order of decreasing detail: # debug5, debug4, debug3, debug2, debug1, # info, notice, warning, error, log, fatal, # panic *************** *** 122,127 **** --- 120,127 ---- #silent_mode = false #log_connections = false + #log_hostname = false + #log_source_port = false #log_pid = false #log_statement = false #log_duration = false *************** *** 152,164 **** # # Statistics # ! #show_parser_stats = false ! #show_planner_stats = false ! #show_executor_stats = false ! #show_statement_stats = false # requires BTREE_BUILD_STATS ! #show_btree_build_stats = false # --- 152,164 ---- # # Statistics # ! #log_parser_stats = false ! #log_planner_stats = false ! #log_executor_stats = false ! #log_statement_stats = false # requires BTREE_BUILD_STATS ! #log_btree_build_stats = false #
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster