I admit to being scared as crap of rsync'ing a live database to another server. Like chills are running down my spine even typing it. Is this an approved, safe thing?
On Tue, Apr 10, 2012 at 11:38 AM, Scott Marlowe <scott.marl...@gmail.com>wrote: > On Tue, Apr 10, 2012 at 12:34 PM, Wells Oliver <wellsoli...@gmail.com> > wrote: > > Hey all, I have a question about streaming replication available in PG 9+ > > > > The general configuration I see is along the lines of this: > > > > > http://brandonkonkle.com/blog/2010/oct/20/postgres-9-streaming-replication-and-django-balanc/ > > > > Where you do the file system backup and restore. However, our current > server > > I wish to make master has a 75GB database. I can't take the server down, > and > > I can't run rsync against the live DB. > > You don't need to take the master down. But you do need to run rsync. > Note that rsync has a --bwlimit flag to reduce its impact on the > master. > -- Wells Oliver wellsoli...@gmail.com
