Re: Streaming Replication (Master Delta Sync) - Mailing list pgsql-admin

From Lonni J Friedman
Subject Re: Streaming Replication (Master Delta Sync)
Date
Msg-id CAP=oouE-cMq66=ZG=N1CdMf_t7T2x4MLS9_Zd0FyXMgPHd0Fng@mail.gmail.com
Whole thread Raw
In response to Re: Streaming Replication (Master Delta Sync)  (Parkirat Bagga <parkiratbagga@gmail.com>)
Responses Re: Streaming Replication (Master Delta Sync)  (Parkirat Bagga <parkiratbagga@gmail.com>)
Re: Streaming Replication (Master Delta Sync)  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-admin
On Wed, Oct 17, 2012 at 2:01 PM, Parkirat Bagga <parkiratbagga@gmail.com> wrote:
> Thanks Netllama for the reply.
>
> Does rsysc sync's the partial logs as well. As I would be doing the rsync
> from old master to new master (when the old master recovers), there might be
> some partial logs present in the old master?

I don't think that's how WAL works.  The log is either complete, or it
doesn't exist.  Anyway, rsync will sync whatever exists when invoked.
I'm sure that its got some crazy options to exclude files based on
certain criteria if you wanted to investigate them.

>
> Delay is there because both the machines are on cloud and they are in
> different regions. I was thinking in terms of having multiple connections so
> that the transfer between 2 regions may become faster.

So if you knew what was causing the delay, why are you asking how to
fix it?  Regardless, are you saying that you've got a slow link
between the master & standby, and the latency is what is causing the
delay?


pgsql-admin by date:

Previous
From: Parkirat Bagga
Date:
Subject: Re: Streaming Replication (Master Delta Sync)
Next
From: Parkirat Bagga
Date:
Subject: Re: Streaming Replication (Master Delta Sync)