Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id DFA60189E83C
	for <pgsql-admin@postgresql.org>; Tue, 10 Apr 2012 15:50:11 -0300 (ADT)
Received: from gwmta.wicourts.gov ([165.219.244.99] helo=gw.wicourts.gov)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <Kevin.Grittner@wicourts.gov>) id 1SHg8k-0002G7-KH
	for pgsql-admin@postgresql.org; Tue, 10 Apr 2012 18:50:10 +0000
Received: from Courts-MTA by gw.wicourts.gov
	with Novell_GroupWise; Tue, 10 Apr 2012 13:49:52 -0500
Message-Id: <4F843A7D0200002500046D87@gw.wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 8.0.2 
Date: Tue, 10 Apr 2012 13:49:49 -0500
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Scott Marlowe" <scott.marlowe@gmail.com>,
	"Wells Oliver" <wellsoliver@gmail.com>
Cc: <pgsql-admin@postgresql.org>
Subject: Re: Setting up streaming replication w/ a big ole
 database
References: 
 <CAOC+FBWhe2dMU8ZUv2HT8YjrPvB38A2NpBwqwoyEB_iXhxqv4g@mail.gmail.com>
	<CAOR=d=0GatiMKwExHOXsoU67Nv_mYacYx2arTZRNLaXdEc1YpA@mail.gmail.com>
	<CAOC+FBUeAUw5J7EUzJH2-RyZUGxAJCXpcDJ5C=G-3n_hS0+B2g@mail.gmail.com>
In-Reply-To: 
 <CAOC+FBUeAUw5J7EUzJH2-RyZUGxAJCXpcDJ5C=G-3n_hS0+B2g@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Pg-Spam-Score: -4.2 (----)
X-Archive-Number: 201204/44
X-Sequence-Number: 39380

Wells Oliver <wellsoliver@gmail.com> wrote:
 
> 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?
 
It is fine, as long as you're doing it between the pg_start_backup()
and pg_stop_backup() calls.  We do it on 100 production databases
every week.  It is approved, documented, and safe.
 
-Kevin