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 1kZeXE-0007Wh-82 for pgsql-hackers@arkaria.postgresql.org; Mon, 02 Nov 2020 18:26:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kZeXD-0002X1-4A for pgsql-hackers@arkaria.postgresql.org; Mon, 02 Nov 2020 18:26:27 +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 1kZeXC-0002Wu-PP for pgsql-hackers@lists.postgresql.org; Mon, 02 Nov 2020 18:26:26 +0000 Received: from mail-il1-x142.google.com ([2607:f8b0:4864:20::142]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kZeX9-0006GI-N6 for pgsql-hackers@postgresql.org; Mon, 02 Nov 2020 18:26:25 +0000 Received: by mail-il1-x142.google.com with SMTP id x20so13803325ilj.8 for ; Mon, 02 Nov 2020 10:26:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=aCcsRk3vbRWI9xU5aZ+n146a2Bm4VCtb5Fqk2YBgjHI=; b=x4yMqd2scbaNladjiIB55Ru/V56xfzK5XmJj2hYjyIPMAVVWcLsnp+eC0xzXRR5iro VI9BYUpzpP2koMO+nbtXlU0/4/QTUJy9yNI29YloPLRxeIas41E/r73TXcTKqVKggI4T cSdCg2szKINqhAi6Cj7QjWdhwjwgoTb2BS2/XgxjHnr8twJnfAlOaIBCNl0A/1u/R0bJ kq36GpTvqlAmTt0BOE8xKEm44DsORWmxoHuzEITldKjyG47Highggy47Nwey+rbhUcPP UMFVxgPqrYqoa4sPISkQY0s+OwPpE5lDsCrfCk8Up2EtpCbVLZFbakyqYJsbYwWxXa3Q qrMg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=aCcsRk3vbRWI9xU5aZ+n146a2Bm4VCtb5Fqk2YBgjHI=; b=iU+iGjGku009lFdA8Wl7BJ2y76A5pVQYNonF10t8UA+a5G9hsdRqHD5+lsu5fTQHg4 8dam5VyO1dqAYInR0XvN/eRbIFlqaG77EhBLyIg8QxZF8h8AT6LAAgQQEXoKnLauBSrn pWEpr7CVu5i2NDJRGCRHAInAE1UPPjazVJu3/mPFu3q2peL3TgpQUWcU04aVavOg6Y/f sMfJPKaWtfZxLHcc2yX8Rkd45CBHF/0TxqK2oXOTtBsfxOEvT8QhL3ecrURaJ47UV7OG B304EY7NT730mFunSFwP8eOOMU5CLffN0ECTeSIzEdjVgwG7rQyKDzKz9EV532eVylOg Me4w== X-Gm-Message-State: AOAM533EMHzZ4+aer3aGJICwM4H9XVcz5GUVfVIxxYbcrsIDshZG+vJh uXrC4hNnOus46XamYHO2aNvvog== X-Google-Smtp-Source: ABdhPJxtIMo5QhfhTFVwVsCdMKWDwf2jCpRe3bApRr8abbGiVFuuWNafGQPDJFV6FmyjVvL5mZht/Q== X-Received: by 2002:a05:6e02:cf:: with SMTP id r15mr11344151ilq.181.1604341582980; Mon, 02 Nov 2020 10:26:22 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id t2sm10123484iob.5.2020.11.02.10.26.22 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 02 Nov 2020 10:26:22 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 58EDE800842; Mon, 2 Nov 2020 12:26:21 -0600 (CST) Date: Mon, 2 Nov 2020 12:26:21 -0600 From: Justin Pryzby To: Michael Banck Cc: Heikki Linnakangas , Tom Lane , Stephen Frost , Ian Lawrence Barwick , pgsql-hackers@postgresql.org Subject: Re: [PATCH] remove pg_archivecleanup and pg_standby Message-ID: <20201102182621.GH22691@telsasoft.com> References: <20201029024412.GP5380@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Thu, Oct 29, 2020 at 08:40:31PM +0100, Michael Banck wrote: > Am Mittwoch, den 28.10.2020, 21:44 -0500 schrieb Justin Pryzby: > > Forking this thread: > > https://www.postgresql.org/message-id/fd93f1c5-7818-a02c-01e5-1075ac0d4def@iki.fi > > I think these are old-fashioned since 9.6 (?), so remove them for v14. > > Why 9.6? My work doesn't currently bring me in contact with replication, so I've had to dig through release notes. I think streaming replication was new in 9.0, and increasingly mature throughout 9.x. Maybe someone else will say a different release was when streaming replication became the norm and wal shipping old. > > I found it confusing when re-familiarizing myself with modern streaming > > replication that there are extensions which only help do things the "old way". > > I guess not many will complain about pg_standby going away, but I am > under the impression that pg_archivecleanup is still used a lot in PITR > backup environments as a handy tool to expire WAL related to expired > base backups. I certainly saw hand-assembled shell code fail with "too > many files" and things when it tried to act on large amount of WAL. I anticipate you're right, and I'll withdraw 0002. -- Justin