Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: > > ... I was running postmaster -d4, yet the only > > query I saw was the last LOG one. I pretty sure that I would see all queries > > with -d3 before.. > > It looked to me like you were just running with the recently-added > frill to log only queries that cause errors; which is on by default. > > (Looks at code...) Ah. It looks like -d to the postmaster no longer > means anywhere near what it used to. Bruce --- compare the handling > of -d in the backend (postgres.c lines 1251ff) with its handling in > the postmaster (postmaster.c lines 444ff). Big difference. Are we > going to make these more alike? If so, which one do we like?
I am sorry but I don't understand. They look like they both set server_min_messages. There was a comment in one that said client_min_messages but I just fixed that. -- 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: src/backend/tcop/postgres.c =================================================================== RCS file: /cvsroot/pgsql-server/src/backend/tcop/postgres.c,v retrieving revision 1.294 diff -c -c -r1.294 postgres.c *** src/backend/tcop/postgres.c 25 Sep 2002 20:31:40 -0000 1.294 --- src/backend/tcop/postgres.c 26 Sep 2002 01:57:48 -0000 *************** *** 1258,1267 **** sprintf(debugstr, "debug%s", optarg); SetConfigOption("server_min_messages", debugstr, ctx, gucsource); pfree(debugstr); - /* * -d is not the same as setting ! * client_min_messages because it enables other * output options. */ if (atoi(optarg) >= 1) --- 1258,1266 ---- sprintf(debugstr, "debug%s", optarg); SetConfigOption("server_min_messages", debugstr, ctx, gucsource); pfree(debugstr); /* * -d is not the same as setting ! * server_min_messages because it enables other * output options. */ if (atoi(optarg) >= 1) *************** *** 1275,1288 **** if (atoi(optarg) >= 5) SetConfigOption("debug_print_rewritten", "true", ctx, gucsource); } - else - - /* - * -d 0 allows user to prevent postmaster debug - * from propagating to backend. - */ - SetConfigOption("server_min_messages", "notice", - ctx, gucsource); } break; --- 1274,1279 ----
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])