Re: Migrating a live database - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Migrating a live database
Date
Msg-id 50701857-CC06-4E11-8210-62DB365A6DB9@elevated-dev.com
Whole thread Raw
In response to Re: Migrating a live database  (Vladimir Rusinov <vladimir@greenmice.info>)
List 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'tchange, 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@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





pgsql-admin by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Migrating a live database
Next
From: "French, Martin"
Date:
Subject: Re: Postgres Backup Utility