Re: Replication/cloning: rsync vs modification dates? - Mailing list pgsql-general

From Chris Angelico
Subject Re: Replication/cloning: rsync vs modification dates?
Date
Msg-id CAPTjJmrTZxn_7d_VxGw_TOOP=Rnjr1qZHfbeaF+MpUTDaJS8VA@mail.gmail.com
Whole thread Raw
In response to Re: Replication/cloning: rsync vs modification dates?  (Michael Nolan <htfoot@gmail.com>)
Responses Re: Replication/cloning: rsync vs modification dates?
List pgsql-general
On Tue, Jul 17, 2012 at 1:40 AM, Michael Nolan <htfoot@gmail.com> 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

pgsql-general by date:

Previous
From: Michael Nolan
Date:
Subject: Re: Replication/cloning: rsync vs modification dates?
Next
From: Daniele Varrazzo
Date:
Subject: Re: Can't figure out how to use now() in default for tsrange column (PG 9.2)