Re: streaming replication - Mailing list pgsql-admin

From Scott Ribe
Subject Re: streaming replication
Date
Msg-id C7602374-3C6A-4D21-B2A1-636F9601135D@elevated-dev.com
Whole thread Raw
In response to Re: streaming replication  (Alex Lai <alai@sesda2.com>)
List pgsql-admin
On Nov 7, 2011, at 9:13 AM, Alex Lai wrote:

> Rsync the entire $PGDATA take about an hour to a empty directory.  When I rsync the $PGDATA to the existing
directory,it still take 50 minutes. 

1) How slow is your disk? (Rsync computer to computer across the network should actually be faster if they're not many
changes.)

2) Why is an hour to bring the old master up to date such a problem? Are you planning on failing over that frequently?

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





pgsql-admin by date:

Previous
From: Kieren Scott
Date:
Subject: pg_dump from 8.4 to 8.3
Next
From: "Kevin Grittner"
Date:
Subject: Re: streaming replication