Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lJbWM-0000MD-4l for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Mar 2021 12:31:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lJbWL-0002gQ-3q for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Mar 2021 12:31:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lJbWK-0002fu-8X for pgsql-hackers@lists.postgresql.org; Tue, 09 Mar 2021 12:31:28 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lJbWH-0008Fg-Ml for pgsql-hackers@lists.postgresql.org; Tue, 09 Mar 2021 12:31:27 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id 608F62551; Tue, 9 Mar 2021 07:31:23 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Tue, 09 Mar 2021 07:31:23 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=+CA42Z+aDb7hEha7uGx8rZYCZm0 khD4LLAYyPlW21A4=; b=L3ssXZ4rE0bArvSRz8f9JCaeEaoN6uw4YSrPONJgZHz lNGx66DNaXMqOsQFgxpWtUQXdRE8juUPpAj4YDZhgQduL1MhqW4SGsl9uHnO2E+u PGNblaSVwH/eSKqF3voat6b7UxRdiHgOUFDTNlQ1hLJGYExf3wU7cYA+ai5PAtU3 HQFkobU6qbVe4NajUiGcvw06s9HYAMJwKy3+d70gyUiUJgLl6FjzsEukcNBqUFl2 QqbHlaMia1ZAuzbSE6hFxjPetPwq7pCTftMejSmxhC3cCSfn9Kl4jb4jwZa6lxCT wW6p9ijmZCqGTQzK5AqpV6zd6Ya695L2QKK9orfqjqw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=+CA42Z +aDb7hEha7uGx8rZYCZm0khD4LLAYyPlW21A4=; b=DK/EF8r1plRxYh5rNNE+xq eX6AUggx3SEJtfTpJgtjNUNcWtKi9YggAkm+dSU1ePkK3T8YsBnttBX62DukR9fb C2Aw3SdrluqnknizMiCZbBWk4hV3qWXPrQ1cKGShjzwIWbFeolhIWifDeMhXgZYR +1ac2PUTXjXIg0a7uebO9hlrBsQ5dc/H3o37sayVikqsHcmMfiElGZ3HO056wL0Q KqDBj5NM6aiLZbNrkJbSLUsCiJABi9/nwJDlvFf2VPj6JsnIGhA1sccVa/3MUA64 DllFiyZI8R4PTIGAWbpn18tNErzpVS2buIFsyshEvpgULsm5OLQxlDTa/hgF7ZJA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrudduiedggeduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvgeduuefhtdeuleettdevjeeh heeiveeuieegleetgeeljeelieeuieehgeevhfenucfkphepudduuddruddtvddrudektd drudekheenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhm pehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 2DDC6108005C; Tue, 9 Mar 2021 07:31:19 -0500 (EST) Date: Tue, 9 Mar 2021 21:31:16 +0900 From: Michael Paquier To: Tomas Vondra Cc: Euler Taveira , Anastasia Lubennikova , Tomas Vondra , PostgreSQL Hackers , Tom Lane Subject: Re: cleanup temporary files after crash Message-ID: References: <20201028184252.5vpoe65kcfebbmmf@development> <20201101012555.GC3000@paquier.xyz> <1982ee3c-54c3-280a-806a-fd28ad8f19e6@postgrespro.ru> <363cb85c-3a03-9a49-b830-8b645c1241d9@enterprisedb.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="gSNgoU/Uv7IScV9Z" Content-Disposition: inline In-Reply-To: <363cb85c-3a03-9a49-b830-8b645c1241d9@enterprisedb.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --gSNgoU/Uv7IScV9Z Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Mar 09, 2021 at 02:28:43AM +0100, Tomas Vondra wrote: > Let's move this patch forward. Based on the responses, I agree the > default behavior should be to remove the temp files, and I think we > should have the GUC (on the off chance that someone wants to preserve > the temporary files for debugging or whatever other reason). Thanks for taking care of this. I am having some second-thoughts about changing this behavior by default, still that's much more useful this way. > I propose to rename the GUC to remove_temp_files_after_crash, I think > "remove" is a bit clearer than "cleanup". I've also reworded the sgml > docs a little bit. "remove" sounds fine to me. > Attached is a patch with those changes. Barring objections, I'll get > this committed in the next couple days. + When set to on, PostgreSQL will automatically Nit: using a markup for the "on" value. +#remove_temp_files_after_crash = on # remove temporary files after +# # backend crash? The indentation of the second line is incorrect here (Incorrect number of spaces in tabs perhaps?), and there is no need for the '#' at the beginning of the line. -- Michael --gSNgoU/Uv7IScV9Z Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmBHapQACgkQnvQgOdby QH05ZA//SkEGQxGq63YSauVgnKcsKEJ2yZ6lzmIyQrv8ctpdzbVKx7NKl4pwXYsr IMc73Jm5j05YSLYoOS9V8ezGl3AkrEXDgaMrfYdVOqcNdrpJ4OJFszB6P9mjl3hS dekTfFoywvY78VZ7eYjsPot8cpTCgnBvUDkhCIpU5Dm19uTjyvBIQ9IjnfuuqZss PIUlcTcFPEKi+ACpCXj9ao5Sg0l22wOOD3sCkmnPtkEmkRMnfZD7JxTOdvi2Blo4 6Q5h7Kg6GYsvyZZrfqgwqkT7Xb28skFyj+3J4CoL65O1+zaKbktRR3+OsVksnMcN M9m98kh7bFgKFL2YitNIJXaqRhvgKwSInvfTe5OmPxEi2T9xlhGsd5DoowSnCcrM 5ya4FEAlWfE1LT8PDAHf5O7TIPqOU1Ka4nr8LVeXNj7syUo+OhnniWtVW2iTuP8U fWfHz1V1kXL4vAfEK89J5GX+w7+XiB/Qz+0dfG3sRIy3HrFA7G/LisW5mve0MlfS Ez6EzlqGDbIqKLSc2UIARLfNiFi+gaHC7GeRrkd/XtQ8GnQX6lSo8++x0swbwNnH 7nMkj2EHipmKAHnmCxO3vOaW5Qe+kis5TOfnsmon1dpQuSbasVdBsA+vEUHoIU1s udeAcKRuf+Pbnyudw/hzg2VYO5gPbFLTz0BISP7pvF76FMwp8tQ= =MsGk -----END PGP SIGNATURE----- --gSNgoU/Uv7IScV9Z--