Re: Reliable WAL file shipping over unreliable network

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Sure it does… what happens if the archive server gets full? There is a situation that can fool rsync into thinking it was successfully transferred as rsync only relies on filesystem metadata to verify the file is different.  The “-c” option will validate the file using a checksum and not just rely on just filesystem metadata.  

Trust me on this one; I’ve seen this happen.


> On Feb 28, 2018, at 1:05 PM, scott ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:
> 
> On Feb 28, 2018, at 10:05 AM, Rui DeSousa <rui.desousa@xxxxxxxxxx> wrote:
>> 
>> Just use "-ac”;  you want -c option to ensure no data corruption during the transfer.  Do not delete the file; let Postgres manage that.
> 
> -c has nothing to do with data corruption during transfer
> 
> --
> Scott Ribe
> https://www.linkedin.com/in/scottribe/
> (303) 722-0567
> 






[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux