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

From Kevin Grittner
Subject Re: Setting up streaming replication w/ a big ole database
Date
Msg-id 4F843A7D0200002500046D87@gw.wicourts.gov
Whole thread Raw
In response to Re: 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
List pgsql-admin
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

pgsql-admin by date:

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