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 <bruce@xxxxxxxxxx> 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 +
