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

From Bruce Momjian
Subject Re: [HACKERS] Broken hint bits (freeze)
Date
Msg-id 20170620143643.GA24975@momjian.us
Whole thread Raw
In response to Re: [HACKERS] Broken hint bits (freeze)  (Sergey Burladyan <eshkinkot@gmail.com>)
Responses Re: [HACKERS] Broken hint bits (freeze)  (Sergey Burladyan <eshkinkot@gmail.com>)
List pgsql-hackers
On Tue, Jun 20, 2017 at 01:10:26PM +0300, Sergey Burladyan wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > > Uh, as I understand it the rsync is going to copy the missing WAL file
> > > from the new master to the standby, right, and I think pg_controldata
> > > too, so it should be fine.  Have you tested to see if it fails?
> 
> It need old WAL files from old version for correct restore heap
> files. New WAL files from new version does not have this information.
> 
> > The point is that we are checking the "Latest checkpoint location" to
> > make sure all the WAL was replayed.   We are never going to start the
> > old standby server.  Rsync is going to copy the missing/changed files.
> 
> Only if missing/changed files changed in size, because rsync run with
> --size-only it does not copy changed files with same size.

I am sorry but I am not understanding.  Step 10.b says:
10.b Make sure the new standby data directories do not existMake sure the new standby data directories do not exist or
areempty. Ifinitdb was run, delete the standby server data directories.
 

so the _entire_ new data directory is empty before rsync is run, meaning
that it is an exact copy of the new master.

--  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: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Something is rotten in publication drop
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] initdb initalization failure for collation "ja_JP"