On Tue, Jul 17, 2012 at 1:40 AM, Michael Nolan <htfoot@xxxxxxxxx> wrote: > I did several weeks of tests on 9.1.3 using mod time and file size > rather than checksumming the files, that did not appear to cause any problems > and it sped up the rsync considerably. (This was about a 40 GB database.) Thanks! Is file size a necessary part of the check, or can mod time alone cover it? I'm looking at having my monitoring application automatically bring database nodes up, so it looks like the simplest way to handle it will be to have the new slave mandatorially do the backup/rsync, even if it's been down for only a couple of minutes. With a mod time check, I could hopefully do this without too much hassle. ChrisA -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
