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 1wuCVG-000WrO-39 for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Aug 2026 17:12:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wuCVE-009C19-2O for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Aug 2026 17:12:33 +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 1wuCVE-009C10-1S for pgsql-hackers@lists.postgresql.org; Wed, 12 Aug 2026 17:12:33 +0000 Received: from mail-oo1-xc2b.google.com ([2607:f8b0:4864:20::c2b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wuCVC-00000000OMk-3cxy for pgsql-hackers@lists.postgresql.org; Wed, 12 Aug 2026 17:12:33 +0000 Received: by mail-oo1-xc2b.google.com with SMTP id 006d021491bc7-6b0b7464c99so498179eaf.3 for ; Wed, 12 Aug 2026 10:12:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1786554749; x=1787159549; darn=lists.postgresql.org; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:from:to:cc:subject :date:message-id:reply-to:content-type; bh=TPra4XR+rZ8UZYyfFH/xfGKDRTBGz/139xu8/0odzyg=; b=SM9K2KKtMZYn8JHDWpUleR1rm/mdAisQwycvPZEgydlllIOgs9T+p1PxDrOxlaVU09 xzMxwTssDOpf95+oLLVh/9/isEx5YOcQicvgzLz97JEssOZOHCowL/jkZQQYEDyTkQPy xvxf5FzzKf/Ff8bDP6vr84RiwASt/qMz2caSTIBzX3eDnV/aSjrMROFGrnwcbhDie0rg W4jiXOUwEeS6Obe+6GDhh5LpwsBhv03zVZX68ln5HsbaPfoVQAQ90dVrRlcarL6z/Zs4 HlilqBmhx1ycKD7sOotVFDrxlc4TWRx+hCJE/g1VQdGGdMJK3RNE1wGd0LwssyVgase8 HAMQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1786554749; x=1787159549; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=TPra4XR+rZ8UZYyfFH/xfGKDRTBGz/139xu8/0odzyg=; b=XBPYP4nFYNoS81GuXxWGa4frNgCkYkL2V6127pDprM3rr2RKaA0Tjv5uekhJcU/uUY pRBOtKXb+9R0NQWpA84K2zjID2ZU0uSMeg4DQIdu1RP/w4O6TY0NPp9kpXDnqfFq9LU7 tdyalYKMOLRV+LT+n4PJ7jdkKo2rKfa6a5rUNovgt6PX0be46aQkIofxeVq7XCrp77Yf BchoT4+OohZfYKvE//eckc8nbnbo5+8rVMXMkyS39wgoxEK3fKMCPYM6nKldnIGIPAoA jq8y1tZ1uQFEa59zQ9lJWAUEo2rtWZvR/x0n+Q4oZFAXKKCcSeIyBU0rg1esVHqYvwFI X8xw== X-Forwarded-Encrypted: i=1; AHgh+RovJx6gX6zZBLq/LFDhz0PNUsQwsd3DZsQG68xWxiYuTA+pdXD6UToHAqNWkBN6sfz5MiieJnPKbbxMIgjL@lists.postgresql.org X-Gm-Message-State: AOJu0YwYgaM5YMMt/sbJkNznliuSttKNg4hO7aymupEGjcn+OIzaXgVU OqWprXmg/HPTVPYOd5URLobKrJkfn1vi0WFqUh77S0DlfP8gRV9hM8eazuAq2g== X-Gm-Gg: AR+sD12WUhmLm+02VloFmA2gwqPsGVokurdwRDC1b5wkFN5+0SLv9ZEw6aENXQeITkH voih2pPnz82YDEZsnHd3y5DXlVJyPsngTBtlahoPx1l1x80UDSHvsnDn17Q8wocntvXn68S6Viz 3XCAk9Tneyhc/kPG2hOexH+Gg2NKAQACqlO3LMBghWDqlTnCbXvw/jNXp8phmWj+d+Qmk5vw+Ou olPJumb9oI8Jf1tyAgEhzIRuGQ8DqPIZT/Amqt6OMSPrI4c+eHgbdHVGtEgNNXucyyqZIcEySN2 HzXVqSSnCPmpGrlpR6MH/hAvdmauDvJl9cmb6oS+9s2epN/td1IeqY4rk9TD+k1SmfqMBmbsL3G E3AiWH+zgYqxAXQSQqR94U9dkoVTn7vygn4nD0RZAsyyWw3/5eKMFV+IrOie+d/lPDHSoGTL44u 9L4cfNDDglkX64L5Xujlhq/OTMwXZ2P5b8A0mCTTMpt0afYg1whGGPcLkCnatb84gbowp7VoVqD jagVe9rlLx0UtUedKv/Q7aenvYnNVWNh/C/pV8dk7Cofd2nenb1LWiAox8XZZAXSwN+HtSqQSYN s6Y+TNl+MHNqKXw= X-Received: by 2002:a05:6820:1885:b0:6aa:d6bd:f6e5 with SMTP id 006d021491bc7-6b0b2c35355mr6360116eaf.35.1786554748866; Wed, 12 Aug 2026 10:12:28 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 006d021491bc7-6b0ad671b82sm3006274eaf.10.2026.08.12.10.12.28 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 12 Aug 2026 10:12:28 -0700 (PDT) Date: Wed, 12 Aug 2026 12:12:26 -0500 From: Nathan Bossart To: Peter Eisentraut Cc: Tom Lane , "Jonathan Gonzalez V." , pgsql-hackers@lists.postgresql.org Subject: Re: Introduce psystem() to replace system() Message-ID: References: <87zeyt93ns.fsf@abdiel.eu> <2314092.1786402806@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Aug 12, 2026 at 07:05:36PM +0200, Peter Eisentraut wrote: > On 11.08.26 01:00, Tom Lane wrote: >> I think breaking the existing definition of archive_command and >> similar GUCs is a nonstarter. You're going to make many users >> unhappy and only a tiny minority happier. > > Right. The direction should be, you don't have to use archive_command. > There is already an alternative in archive_library, or indirectly by using > something like pg_receivewal. Similar alternatives could be designed for > other cases where a shell command appears in a public API. +1. This conversation makes me wonder about reviving the "restore modules" work [0]. [0] https://postgr.es/m/flat/20221227192449.GA3672473%40nathanxps13 -- nathan