Re: Fwd: upgrade to PG11 on secondary fails (no initdb was launched)

On Fri, Jun 14, 2019 at 03:12:29PM +0200, Fabio Pardi wrote:
> Hi Bruce,
> 
> 
> On 6/14/19 5:30 AM, Bruce Momjian wrote:
> 
> >> Also, I do not think it best practice (or perhaps not correct at all) to
> >> use '--size-only'
> > 
> > --size-only is correct, as far as I know.
> > 
> 
> 
> Maybe I am missing something, but I am of the opinion that --size-only
> should not be used when syncing database content (and probably in many
> other use cases where content can change over time).
> 
> The reason is that db allocates blocks, 8K by default regardless from
> the content.
> 
> Using --size-only, tells rsync to only check the size of the blocks.
> That is: if the block is present on the destination, and is the same
> size as the origin, then skip.

The files are _exactly_ the same on primary and standby, so we don't
need to check anything.  Frankly, it is really only doing hard linking
of the files.

-- 
  Bruce Momjian  <[email protected]>        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 +