pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Nathan Bossart <nathandbossart@gmail.com>
To: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Cc: Bossart, Nathan <bossartn@amazon.com>
Cc: Julien Rouhaud <rjuju123@gmail.com>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Add checkpoint and redo LSN to LogCheckpointEnd log message
Date: Thu, 27 Jan 2022 15:57:49 -0800
Message-ID: <20220127235749.GA558032@nathanxps13> (raw)
In-Reply-To: <CALj2ACUfLrN8XGn0ZNrAou5eoDwMnFGnDE9rhcs8==jmtSd4WA@mail.gmail.com>
References: <CALj2ACWt6kqriAHrO+AJj+OmP=suwbktHT5JoYAn-nqZe2gd2g@mail.gmail.com>
	<20211224.145134.1164706994861031206.horikyota.ntt@gmail.com>
	<YcW5D2GjWlIzbbKs@paquier.xyz>
	<CALj2ACXzv6FJNbTnP9uYsPXFeA4UcugSWDecxr19SjFCUCxP-g@mail.gmail.com>
	<CALj2ACUP84UYSimewLSs8--rT9dUTA7CUYTgXTnEb-2iHkc9wA@mail.gmail.com>
	<CAOBaU_aefLN5Gze52os5JzkNR_Fc+bJHPk=m67zov33-66MfZw@mail.gmail.com>
	<CALj2ACUGutu6As-9p76Ta2bV59J97fbiCc9NSzaWXqxPJdMvag@mail.gmail.com>
	<CALj2ACVM4wjS+wiNZf4ssdNMhSR-XUhR99fYbV=pC9_-=5wCtw@mail.gmail.com>
	<BDAE2BB3-2F37-4B7C-A053-874250A47C21@amazon.com>
	<CALj2ACUfLrN8XGn0ZNrAou5eoDwMnFGnDE9rhcs8==jmtSd4WA@mail.gmail.com>

On Thu, Jan 27, 2022 at 08:37:37PM +0530, Bharath Rupireddy wrote:
> I'm still not clear how the REDO location can be treated as a start
> LSN? Can someone throw some light one what this checkpoint's REDO
> location is?

It's the WAL insert location at the time the checkpoint began (i.e., where
you need to begin replaying WAL from after a crash).

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com/





view thread (65+ messages)  latest in thread

Message-ID: <20220127235749.GA558032@nathanxps13>
Permalink:  ../20220127235749.GA558032@nathanxps13/
Also on:    postgresql.org/message-id/20220127235749.GA558032@nathanxps13

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: nathandbossart@gmail.com, bharath.rupireddyforpostgres@gmail.com, bossartn@amazon.com, rjuju123@gmail.com, michael@paquier.xyz, horikyota.ntt@gmail.com, pgsql-hackers@lists.postgresql.org
  Subject: Re: Add checkpoint and redo LSN to LogCheckpointEnd log message
  In-Reply-To: <20220127235749.GA558032@nathanxps13>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox