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 1nEbRX-0006vh-Tk for pgsql-hackers@arkaria.postgresql.org; Mon, 31 Jan 2022 18:30:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nEbRW-0007VA-5O for pgsql-hackers@arkaria.postgresql.org; Mon, 31 Jan 2022 18:30:22 +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 1nEbRV-0007V0-Qe for pgsql-hackers@lists.postgresql.org; Mon, 31 Jan 2022 18:30:21 +0000 Received: from mail-pl1-x636.google.com ([2607:f8b0:4864:20::636]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nEbRO-0007fY-32 for pgsql-hackers@lists.postgresql.org; Mon, 31 Jan 2022 18:30:20 +0000 Received: by mail-pl1-x636.google.com with SMTP id z5so13180359plg.8 for ; Mon, 31 Jan 2022 10:30:13 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=9I4LQUOeegKdQ0OmEsutiMwYHF7aes5OrtKdMTVGmjg=; b=JgSX/RabWUnsh/4aBT1uCcPFU8BzrIReFrvQjfUsDIRTwVcsqoLO8PuznGd/IyeenK 6Swf4VOVQoCnJMKrFKrH2JiwSnBLvps4hxBV+rurjhpWXkL7gSS8skDgLzhnhm0bXP47 YFt3Teff4BOm3rGA10VUJxV79q37IOwBtmccozhuWV3HRbkosEJeu/gIPrE35LyXDITh Wrwwb7cwtnjQBAGZaPvH6vmAcKSIhSFIXbQ1MtoSJgaaYljnOCaUjz5Y4ZI0Wgg9eok5 H82GY7FdhQmrItOrtjNTCAMM5vYhrw6owuDIUpWtXm+OaPsNCkM0cbyllVYmosoNQWM4 XUFQ== 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; bh=9I4LQUOeegKdQ0OmEsutiMwYHF7aes5OrtKdMTVGmjg=; b=ZlaArF2Ajp5Tp83BiJRAr2pGAhK+yEUEn1isc4dlmJa1sEb8sSYqY9lICuTa62iaWM n4QfI67oBheUZTr8FeheyTDiXeEUrCagVyi4Q6JYvs4MELYV2Wp4RHgry5txP2O3H1bn y/lh/zrY0Ft4FZEwdEohLcosYRTHR7SrzDJYmBq3+3tMPZ5eeo8JFM93/AmWsrssH0Cf 2v89duBIfR+megHAKH1DLp6+234Mx6UXdmMVDTrmkP6uIKZTVEMf6SP0JbrI/DPlc89T LYwkiME5IjHuE7m3oYb6odw5ZOzn2hMghJ1lffMC95kPLxmB+wmG1YkD6WJp7fjE8xiI oc6A== X-Gm-Message-State: AOAM530eade9Dl3OaFNy+WOyBHfQ0Lb9Y2yN7z2FyTjfCBCsbTgYn2Fk hfFXQiFAHQ2sRXIJ5CBeCg0= X-Google-Smtp-Source: ABdhPJwIY6VjoAxIPxDv8M+uEWICe4JUYtFiGxKeiXyz2fdcz27GNYxFk2fzCtl4m/igrw1cQ+K4uw== X-Received: by 2002:a17:902:eacc:: with SMTP id p12mr22058733pld.123.1643653811906; Mon, 31 Jan 2022 10:30:11 -0800 (PST) Received: from nathanxps13 ([50.54.155.70]) by smtp.gmail.com with ESMTPSA id q140sm30307260pgq.7.2022.01.31.10.30.10 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 31 Jan 2022 10:30:11 -0800 (PST) Date: Mon, 31 Jan 2022 10:30:09 -0800 From: Nathan Bossart To: Bharath Rupireddy Cc: Stephen Frost , Kyotaro Horiguchi , "Bossart, Nathan" , Julien Rouhaud , Michael Paquier , PostgreSQL Hackers Subject: Re: Add checkpoint and redo LSN to LogCheckpointEnd log message Message-ID: <20220131183009.GA660545@nathanxps13> References: <20220120.120029.1092463916382268628.horikyota.ntt@gmail.com> <20220128054620.GA654866@nathanxps13> <20220131151100.GR10577@tamriel.snowman.net> 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 Mon, Jan 31, 2022 at 11:45:19PM +0530, Bharath Rupireddy wrote: > Thanks. Here are 2 patches, 0001 for adding checkpoint lsn and redo > lsn in the checkpoint completed message and 0002 for changing the > "location" to LSN in pg_controdata's output. With the 0002, > pg_control_checkpont, pg_controldata and checkpoint completed message > will all be in sync with the checkpoint lsn and redo lsn. I think the pg_controldata change needs some extra spaces for alignment, but otherwise these patches seem reasonable to me. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com