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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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