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 1nCOwq-000450-Qw for pgsql-hackers@arkaria.postgresql.org; Tue, 25 Jan 2022 16:45:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nCOwp-0006O4-Il for pgsql-hackers@arkaria.postgresql.org; Tue, 25 Jan 2022 16:45:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nCOwp-0006N2-7S for pgsql-hackers@lists.postgresql.org; Tue, 25 Jan 2022 16:45:35 +0000 Received: from mail-io1-xd29.google.com ([2607:f8b0:4864:20::d29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nCOwm-00068Q-Kk for pgsql-hackers@lists.postgresql.org; Tue, 25 Jan 2022 16:45:34 +0000 Received: by mail-io1-xd29.google.com with SMTP id y84so8009369iof.0 for ; Tue, 25 Jan 2022 08:45:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=Njcts9JoTCzOLV3O3+dgY6nqbUbBI+0QCgmWtecwgaM=; b=YAN6oKVNpZwl7o15nYM/PiR/dIipAqXARcL7zhJXhMACbDJ6NLg+7Uwo9tmc10coaf 4/+4p9YDpgTjDk3LpRkUVGFnfCNbyMxKROu8k3NpWmHcRiGJdpnoebr+EF/fg5kXLo13 WSwZIgjjyHl6g2v7LQzmp146ZWtAqU7a1NnnSAGrW9Ep/FTtV4NQa2Ay1cDWB2T1L4Bt DL5CRGhwVZepzhrAlEwttkelB+C+NOLtJgoXmUqikRtpxz/ps2Wf413c3DgoEj+aZqtU TrsSokaTW9ljIV3VPP6YNFLk8vA1J4DyfUJ7tAml1uRChTKIR/5WyM0WiJrmDuq/5khf HIGw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=Njcts9JoTCzOLV3O3+dgY6nqbUbBI+0QCgmWtecwgaM=; b=a0ZSf4HeT98EZn8s4C0vOXsZuTnD1Sf3MPHyhpJV2dz21l5rigYMC8dUEOr0OypOCf gY8lEUDUDLUiWJ1WIFHzmNOrQf2EWxbwsmpCiUEFRvL8K4GeAkME2eX3Ly7WwGh7ifPe rJMC9c+e8qQNimmVrJUg3ITWm00vk7rvHnk2eH3V4zUKnnn/hId32auDy0zmsIxPQVb/ XIVadUNHb2WviFEVA0g5Kh1QrsPW+Sm3wRoOuDmyv0TKiNx5o8NyElPa5TXCmMaRHwVN 4bCXofbUP4pD/ef576totROeRi9gCXOuls/gnKz2vQJeJuI1zaLVQZ9jPTC65GQCLyMB Ui6A== X-Gm-Message-State: AOAM533uo2Cu0PbsnqH/Q2L8kBuVbm50ExC7pM8yHSL1XOxgCmQauwg2 ojVx07DH+ZoEoHR8TLogzSH7ng== X-Google-Smtp-Source: ABdhPJwRG5mSUQ71q1RH1MYr6DacrJTPoAasAHqjBYn1FBbijwywImV/seA2DuMPbaGdQdTyQsHk4g== X-Received: by 2002:a02:cd1c:: with SMTP id g28mr4483553jaq.189.1643129130902; Tue, 25 Jan 2022 08:45:30 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id w5sm2931086ilu.83.2022.01.25.08.45.30 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 25 Jan 2022 08:45:30 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id B661080073B; Tue, 25 Jan 2022 10:45:29 -0600 (CST) Date: Tue, 25 Jan 2022 10:45:29 -0600 From: Justin Pryzby To: Michael Paquier Cc: Peter Eisentraut , Tom Lane , Daniel Gustafsson , Andrew Dunstan , Bruce Momjian , pgsql-hackers@lists.postgresql.org Subject: Re: pg_upgrade should truncate/remove its logs before running Message-ID: <20220125164529.GG23027@telsasoft.com> References: <20211222163611.GC17618@telsasoft.com> <20220108184857.GI14051@telsasoft.com> <20220111200307.GA14051@telsasoft.com> <20220112040813.GD14051@telsasoft.com> <45e7680a-b617-1397-afa0-35a793aacefe@enterprisedb.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: Archived-At: Precedence: bulk On Mon, Jan 24, 2022 at 10:59:40AM +0900, Michael Paquier wrote: > On Thu, Jan 20, 2022 at 07:51:37PM +0900, Michael Paquier wrote: > > Neat idea. That would work fine for my case. So I am fine to stick > > with this suggestion. > > I have been looking at this idea, and the result is quite nice, being > simpler than anything that has been proposed on this thread yet. We > get a simpler removal logic, and there is no need to perform any kind > of sanity checks with the output path provided as long as we generate > the paths and the dirs after adjust_data_dir(). > > Thoughts? Andrew: you wanted to accommodate any change on the build client, right ? -- Justin