Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TOaJf-00037p-2e for pgsql-admin@postgresql.org; Wed, 17 Oct 2012 20:34:11 +0000 Received: from sam.nabble.com ([216.139.236.26]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TOaJa-0005AR-8H for pgsql-admin@postgresql.org; Wed, 17 Oct 2012 20:34:10 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1TOaJZ-0000jP-Cq for pgsql-admin@postgresql.org; Wed, 17 Oct 2012 13:34:05 -0700 Date: Wed, 17 Oct 2012 13:34:05 -0700 (PDT) From: Parkirat Bagga To: pgsql-admin@postgresql.org Message-ID: <1350506045391-5728704.post@n5.nabble.com> Subject: 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/61 X-Sequence-Number: 40177 Hi We are using streaming replication for c++ Postgres-9.1 server. We have setup 1 master and 1 slave and streaming replication is working fine. On checking the x-log status for both master and slave, we observed that the master is quite ahead of the slave all the time. Now we have 2 questions Que 1) When Master goes down these is some delta which is not applied to the standby server (which is now, my new master) and the trigger has happened. How should I sync that delta part to the new Master (older standby server)? Que 2) How can I further reduce the gap between the Master and Standby? I tried increasing the max_wal_sender=5 number but I can see only 1 process running for sender. Regards, Parkirat Singh Bagga. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Streaming-Replication-Master-Delta-Sync-tp5728704.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.