Re: Migrating a live database

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Vladimir Rusinov <vladimir(at)greenmice(dot)info>
Cc: Vladislav Geller <vladislav(dot)geller(at)vincorex(dot)ch>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Migrating a live database
Date: 2011-01-18 14:55:45
Message-ID: 50701857-CC06-4E11-8210-62DB365A6DB9@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Jan 18, 2011, at 12:39 AM, Vladimir Rusinov wrote:

> If sync won't finish in 9 hours, abort it, run pg_stop_backup() and continue next day - I assume most of the data won't change, so rsync won't re-transfer it (but will calculate hash and compare).

And there's --partial in case you have to stop it in the middle of a large file.

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bradley Holbrook 2011-01-18 16:57:07 Re: Postgres Backup Utility
Previous Message French, Martin 2011-01-18 13:46:37 Re: Postgres Backup Utility