Re: Setting up streaming replication w/ a big ole database - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Setting up streaming replication w/ a big ole database
Date
Msg-id CAOR=d=0GatiMKwExHOXsoU67Nv_mYacYx2arTZRNLaXdEc1YpA@mail.gmail.com
Whole thread Raw
In response to Setting up streaming replication w/ a big ole database  (Wells Oliver <wellsoliver@gmail.com>)
Responses Re: Setting up streaming replication w/ a big ole database  (Wells Oliver <wellsoliver@gmail.com>)
List pgsql-admin
On Tue, Apr 10, 2012 at 12:34 PM, Wells Oliver <wellsoliver@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.

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Setting up streaming replication w/ a big ole database
Next
From: Wells Oliver
Date:
Subject: Re: Setting up streaming replication w/ a big ole database