Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vStYm-008Y1C-23 for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Dec 2025 08:59:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vStYl-003pbD-0X for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Dec 2025 08:59:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vStYk-003pb4-1W for pgsql-hackers@lists.postgresql.org; Tue, 09 Dec 2025 08:59:03 +0000 Received: from fout-b4-smtp.messagingengine.com ([202.12.124.147]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vStYh-0040iX-0L for pgsql-hackers@lists.postgresql.org; Tue, 09 Dec 2025 08:59:02 +0000 Received: from phl-compute-06.internal (phl-compute-06.internal [10.202.2.46]) by mailfout.stl.internal (Postfix) with ESMTP id 6C5F81D0016B; Tue, 9 Dec 2025 03:58:56 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-06.internal (MEProxy); Tue, 09 Dec 2025 03:58:56 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1765270736; x=1765357136; bh=K DD+bqAAY9+6LTPfnH7OqbFugmCY6TbQw3ALco+Xa3Y=; b=v/UpH3xy3P7U9H8OM 1lSBLXux3fizbgF6xf8+8Gep298OK4nQIwhiwM9oGkATyp1CX2oJzM0HYsRlNJ5z dj/r+1+xmKyF6IFOM3UG7VPCpC6iHYQ+WxoQfhjyL/cH9chWOvVb2MaXSiIvVff4 d8LLIb1sX+ZRp0A6Iix3ww7a7CM0JDaaCtbbccTvXFkEEP3nyF6lhpiB6SomlLOT d8PAlird8VUTCe3ZTnJrpJwuDmeygRh0P3Qg4UNGXnZ4Cc9K8TuqTEpsp6fKpSbL T5jembfXxXzFikHrmsuFgzMNleTu3r66LqPtuPRHhxavu7MTmexVeQiWmVDBIbVv lZgbQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgdduledugecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpeffhffvvefukfggtggugfgjsehmkeerredttdejnecuhfhrohhmpeetlhhvrghrohcu jfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqeenuc ggtffrrghtthgvrhhnpeduleekkefgtddttedtkefguddvieffleetgeejiefhteehkeev feettdduvdfhueenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmnecuve hluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghr rhgvsegrlhhvhhdrnhhoqdhiphdrohhrghdpnhgspghrtghpthhtohephedpmhhouggvpe hsmhhtphhouhhtpdhrtghpthhtoheprghnughrvghssegrnhgrrhgriigvlhdruggvpdhr tghpthhtohepvghulhgvrhesvghulhgvrhhtohdrtghomhdprhgtphhtthhopehlihdrvg hvrghnrdgthhgrohesghhmrghilhdrtghomhdprhgtphhtthhopehjrghpihhnlhhisehh ohhtmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqhhgrtghkvghrsheslhhish htshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 9 Dec 2025 03:58:55 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1765270732; bh=C0yYcthctYt6sdvIkTfCK5XalayCPi3bfq6yLNFk9UI=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=Bcs0IdgPbdvw+IKrAZEJ9C+a6MQgvpTOLn9YWchKIYjxGpbeiBDYEyuP/7MuyWQLL 71NZ2t/PfJHV70W7O4LsJE5YvFIA1i0vA6qYJIhY6eBNP+TQEBfpn71HGCnaJRhqvC RYJ09Xna9UcDb3It1YLRY6tQqSAGPGRDLWbFwYzQ2jK8ix9V5mHBuzduK8YVDmL+Nc VEPPka3/gyY6FZaaWC3vf/jIeEtNyeAUALFkKiOstaI9e5F7Bmu7v9weJvE7ELgR23 +smKUct5W488WhupbwflYQuW8nW9v1sDtWBrrW5wr25JDENbKU7BB87CwhEUZ6R62w eSQPEJTltFDug== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id A3DD77B; Tue, 09 Dec 2025 09:58:52 +0100 (CET) Date: Tue, 9 Dec 2025 09:58:52 +0100 From: Alvaro Herrera To: Euler Taveira Cc: japin , Andres Freund , pgsql-hackers@lists.postgresql.org, Chao Li Subject: Re: log_min_messages per backend type Message-ID: <202512090853.hk6e6t56bq5z@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="grg2fqqi6tkdt5me" Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <144f0f96-c6d3-4ad6-a236-00200513e2e0@app.fastmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --grg2fqqi6tkdt5me Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit Hello I noticed failures under Windows, and realized that the EXEC_BACKEND case was busted. That's easy to fix -- just assign MyBackendType in SubPostmasterMain() as well. With that fix I was still getting some crashes in three test modules, and after some debugging it turned out that if you have shared_preload_library with a background worker and use %b in the log_line_prefix, you get a crash trying to expand a name that hasn't been set up yet. I figured we can use a constant string in that case. Better ideas for that string welcome. So here's your v6 again with those fixes as 0003 -- let's see what CI thinks of this. I haven't looked at your doc changes yet. BTW with %b in log_line_prefix, the log file looks ... interesting. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "Before you were born your parents weren't as boring as they are now. They got that way paying your bills, cleaning up your room and listening to you tell them how idealistic you are." -- Charles J. Sykes' advice to teenagers --grg2fqqi6tkdt5me Content-Type: text/x-diff; charset=utf-8 Content-Disposition: attachment; filename="v7-0001-log_min_messages-per-process-type.patch"