Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c7hCA-0004BB-Ni for pgsql-admin@arkaria.postgresql.org; Fri, 18 Nov 2016 11:19:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1c7hCA-0000t4-75 for pgsql-admin@arkaria.postgresql.org; Fri, 18 Nov 2016 11:19:02 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1c7hAT-0007Mh-Nn for pgsql-admin@postgresql.org; Fri, 18 Nov 2016 11:17:17 +0000 Received: from mwork.nabble.com ([162.253.133.43]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c7hAP-0001AU-Q7 for pgsql-admin@postgresql.org; Fri, 18 Nov 2016 11:17:16 +0000 Received: from mben.nabble.com (unknown [162.253.133.72]) by mwork.nabble.com (Postfix) with ESMTP id 8BC246D300533 for ; Fri, 18 Nov 2016 04:17:12 -0700 (MST) Date: Fri, 18 Nov 2016 04:17:12 -0700 (MST) From: rajan To: pgsql-admin@postgresql.org Message-ID: <1479467832483-5930928.post@n3.nabble.com> In-Reply-To: <20161114175509.3wgvxos44hxxz26i@alap3.anarazel.de> References: <1479116970057-5930204.post@n3.nabble.com> <20161114175509.3wgvxos44hxxz26i@alap3.anarazel.de> Subject: Re: WAL restoration is not happening completely MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.3 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org thanks Ian, Peter and Andres for the replying. One thing I missed to update is that the Source(master) machine I was running is switched off and on everyday. It may have caused any disruption in the WAL files? And one more question, The WAL files are created as 16MB segments, that is obvious. But I do not know when the file is completely written. Is it like, a file is created and then written till 16MB or 16MB data segment is directly written at once. These questions may be stupid but I thought it will help understand the process. ----- -- Thanks, Rajan. -- View this message in context: http://postgresql.nabble.com/WAL-restoration-is-not-happening-completely-tp5930204p5930928.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin