>Not necessarily. Depending on how pg_dump works, it could be that >small changes to the database are resulting in unnecessarily large >changes to the dump. Make sure you are using the uncompressed format >because most compression algorithms defeat the delta-transfer >algorithm almost completely. Then you might take a look at two >consecutive dumps and check whether records common to both appear in >the same order in each dump. (If pg_dump is dumping the records in a >different order each time, that would also defeat the delta-transfer >algorithm because no block of several consecutive records could be >matched.)
I was wondering if it would be possible to add a switch (probably coupled to -v(+) ) that would report the number of matched blocks per file. Maybe even with the offset of the block. That of course wouldn't help much in a production environment, but it could help while setting up the whole backup strategy. This would have helped the original poster finding out if rsync is working correctly. bye Fabi -- To unsubscribe or change options: https://lists.samba.org/mailman/listinfo/rsync Before posting, read: http://www.catb.org/~esr/faqs/smart-questions.html