From: Bruce Momjian <bruce@momjian.us>
To: Sergey Burladyan <eshkinkot@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Cc: Amit Kapila <amit.kapila16@gmail.com>
Cc: Dmitriy Sarafannikov <dsarafannikov@yandex.ru>
Cc: Vladimir Borodin <root@simply.name>
Subject: Re: Broken hint bits (freeze)
Date: Tue, 20 Jun 2017 10:36:43 -0400
Message-ID: <20170620143643.GA24975@momjian.us> (raw)
In-Reply-To: <87h8zb6kbx.fsf@seb.koffice.internal>
References: <87mv98af8j.fsf@seb.koffice.internal>
<CAA4eK1JB=5gHNhRWgtVcqCQbUzGwR2LM9msYBQVULDfA+1ugUA@mail.gmail.com>
<20170616164641.GP11450@momjian.us>
<87fuezalc3.fsf@seb.koffice.internal>
<CAA4eK1KMxzg_q2-0rMRh22EMWGutQ0QbCtMqc_5GeuNVyJ8kmA@mail.gmail.com>
<20170619222113.GF3180@momjian.us>
<CAJ2ymdg=0knii-bavVLpKEGc9DanaZC+UXjnipx_n-gFvOkdcg@mail.gmail.com>
<20170620025919.GA28277@momjian.us>
<20170620033726.GB28277@momjian.us>
<87h8zb6kbx.fsf@seb.koffice.internal>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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 exist
Make sure the new standby data directories do not exist or are empty. If
initdb 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 +
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
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: bruce@momjian.us, eshkinkot@gmail.com, amit.kapila16@gmail.com, dsarafannikov@yandex.ru, root@simply.name
Subject: Re: Broken hint bits (freeze)
In-Reply-To: <20170620143643.GA24975@momjian.us>
* 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