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

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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, "Wells Oliver" <wellsoliver(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:49:49
Message-ID: 4F843A7D0200002500046D87@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
Wells Oliver <wellsoliver(at)gmail(dot)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

In response to

Responses

pgsql-admin by date

Next:From: Robert BurgholzerDate: 2012-04-10 18:56:50
Subject: Re: Setting up streaming replication w/ a big ole database
Previous:From: Wells OliverDate: 2012-04-10 18:43:03
Subject: Re: Setting up streaming replication w/ a big ole database

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