Re: streaming replication

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Alex Lai <alai(at)sesda2(dot)com>
Cc: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: streaming replication
Date: 2011-11-07 16:52:00
Message-ID: C7602374-3C6A-4D21-B2A1-636F9601135D@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kieren Scott 2011-11-07 16:54:01 pg_dump from 8.4 to 8.3
Previous Message Alex Lai 2011-11-07 16:13:05 Re: streaming replication