Re: [HACKERS] Broken hint bits (freeze) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Broken hint bits (freeze)
Date
Msg-id 20170629012734.GB16576@momjian.us
Whole thread Raw
In response to Re: [HACKERS] Broken hint bits (freeze)  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: [HACKERS] Broken hint bits (freeze)
List pgsql-hackers
On Sat, Jun 24, 2017 at 09:24:21AM +0530, Amit Kapila wrote:
> > I was not clear.  I was not saying there can be only one extra WAL file.
> > I am saying the "Latest checkpoint location" should be one WAL file
> > farther on the master.  I think the big problem is that we need a full
> > replay of that WAL file, not just having it one less than the master.
> >
> 
> If the user has properly shutdown, then that last file should only
> have checkpoint record, is it safe to proceed with upgrade without
> actually copying that file?

Yes, but how do we know they processed all the records in the 
second-to-last WAL file (in WAL shipping mode).

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Broken hint bits (freeze)
Next
From: Masahiko Sawada
Date:
Subject: [HACKERS] What does it mean by XLOG_BACKUP_RECORD?