pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Alex Lai <alai@sesda2.com>
Cc: Fujii Masao <masao.fujii@gmail.com>
Cc: [ADMIN] <pgsql-admin@postgresql.org>
Subject: Re: streaming replication
Date: Mon, 7 Nov 2011 09:52:00 -0700
Message-ID: <C7602374-3C6A-4D21-B2A1-636F9601135D@elevated-dev.com> (raw)
In-Reply-To: <4EB80391.1020809@sesda2.com>
References: <CAC-Lqbq7mKzxcNG+cRtUT2vNqh=qY6kXttLeumQkd5vdEsbTVg@mail.gmail.com>
	<CACP4ndiOQZfQ1W5NVNTp0Xvan_RQC+9zQ3=FDe8H1K5szPj+SQ@mail.gmail.com>
	<CAC-Lqbpb5-vETngn-Sc=ab3T=HdWT5GarOpaUjA2O3UuyZ922g@mail.gmail.com>
	<CAHGQGwHn8DLQF1vPaizJzwtFk+Y0ciML-zjXct_y6NmZ+BFy6g@mail.gmail.com>
	<4EB80391.1020809@sesda2.com>

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







view thread (13+ messages)  latest in thread

Message-ID: <C7602374-3C6A-4D21-B2A1-636F9601135D@elevated-dev.com>
Permalink:  ../C7602374-3C6A-4D21-B2A1-636F9601135D@elevated-dev.com/
Also on:    postgresql.org/message-id/C7602374-3C6A-4D21-B2A1-636F9601135D@elevated-dev.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott_ribe@elevated-dev.com, alai@sesda2.com, masao.fujii@gmail.com
  Subject: Re: streaming replication
  In-Reply-To: <C7602374-3C6A-4D21-B2A1-636F9601135D@elevated-dev.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox