| From: | Chris Angelico <rosuav(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Replication/cloning: rsync vs modification dates? |
| Date: | 2012-07-16 15:45:16 |
| Message-ID: | CAPTjJmrTZxn_7d_VxGw_TOOP=Rnjr1qZHfbeaF+MpUTDaJS8VA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jul 17, 2012 at 1:40 AM, Michael Nolan <htfoot(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniele Varrazzo | 2012-07-16 15:57:02 | Re: Can't figure out how to use now() in default for tsrange column (PG 9.2) |
| Previous Message | Michael Nolan | 2012-07-16 15:40:51 | Re: Replication/cloning: rsync vs modification dates? |