Skip site navigation (1) Skip section navigation (2)

Re: Setting up streaming replication w/ a big ole database

From: Wells Oliver <wellsoliver(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Setting up streaming replication w/ a big ole database
Date: 2012-04-10 18:43:03
Message-ID: CAOC+FBUeAUw5J7EUzJH2-RyZUGxAJCXpcDJ5C=G-3n_hS0+B2g@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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>
> 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
wellsoliver(at)gmail(dot)com

In response to

Responses

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2012-04-10 18:49:49
Subject: Re: Setting up streaming replication w/ a big ole database
Previous:From: Scott MarloweDate: 2012-04-10 18:38:56
Subject: Re: Setting up streaming replication w/ a big ole database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group