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(dot)marlowe(at)gmail(dot)com>wrote:
> On Tue, Apr 10, 2012 at 12:34 PM, Wells Oliver <wellsoliver(at)gmail(dot)com>
> > Hey all, I have a question about streaming replication available in PG 9+
> > The general configuration I see is along the lines of this:
> > Where you do the file system backup and restore. However, our current
> > I wish to make master has a 75GB database. I can't take the server down,
> > 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
In response to
pgsql-admin by date
|Next:||From: Kevin Grittner||Date: 2012-04-10 18:49:49|
|Subject: Re: Setting up streaming replication w/ a big ole
|Previous:||From: Scott Marlowe||Date: 2012-04-10 18:38:56|
|Subject: Re: Setting up streaming replication w/ a big ole database|