Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TOak3-0003kn-L8 for pgsql-admin@postgresql.org; Wed, 17 Oct 2012 21:01:27 +0000 Received: from sam.nabble.com ([216.139.236.26]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TOak1-0005aU-Ai for pgsql-admin@postgresql.org; Wed, 17 Oct 2012 21:01:27 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1TOak0-0002Ht-HZ for pgsql-admin@postgresql.org; Wed, 17 Oct 2012 14:01:24 -0700 Date: Wed, 17 Oct 2012 14:01:24 -0700 (PDT) From: Parkirat Bagga To: pgsql-admin@postgresql.org Message-ID: <1350507684535-5728709.post@n5.nabble.com> In-Reply-To: References: <1350506045391-5728704.post@n5.nabble.com> Subject: Re: Streaming Replication (Master Delta Sync) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 0.0 (/) X-Archive-Number: 201210/65 X-Sequence-Number: 40181 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? 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. Also, I have another question about trigger file content being smart or fast matters in streaming replication? Regards, Parkirat Singh Bagga -- View this message in context: http://postgresql.1045698.n5.nabble.com/Streaming-Replication-Master-Delta-Sync-tp5728704p5728709.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.