Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1X5LBu-0006Bn-5H for pgsql-admin@arkaria.postgresql.org; Thu, 10 Jul 2014 20:43:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1X5LBt-0006I2-Jo for pgsql-admin@arkaria.postgresql.org; Thu, 10 Jul 2014 20:43:41 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1X5LBr-0006Ec-K1 for pgsql-admin@postgresql.org; Thu, 10 Jul 2014 20:43:39 +0000 Received: from qmta10.emeryville.ca.mail.comcast.net ([2001:558:fe2d:43:76:96:30:17]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1X5LBn-0006Sv-PZ for pgsql-admin@postgresql.org; Thu, 10 Jul 2014 20:43:37 +0000 Received: from omta08.emeryville.ca.mail.comcast.net ([76.96.30.12]) by qmta10.emeryville.ca.mail.comcast.net with comcast id Qk5K1o0050FhH24AAkjZxG; Thu, 10 Jul 2014 20:43:33 +0000 Received: from jerry.enova.com ([38.98.177.132]) by omta08.emeryville.ca.mail.comcast.net with comcast id QkjN1o00i2rmZlA8UkjRp2; Thu, 10 Jul 2014 20:43:31 +0000 Received: by jerry.enova.com (Postfix, from userid 1001) id 785627401EE; Thu, 10 Jul 2014 15:43:22 -0500 (CDT) From: Jerry Sievers To: mail list Cc: pgsql-admin@postgresql.org Subject: Re: wal archive showing zero size References: <53BEF3A6.20403@milidonis.com> Date: Thu, 10 Jul 2014 15:43:22 -0500 In-Reply-To: <53BEF3A6.20403@milidonis.com> (mail list's message of "Thu, 10 Jul 2014 23:12:22 +0300") Message-ID: <86egxtosgl.fsf@jerry.enova.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=q20140121; t=1405025013; bh=WdaGT+3HdSnjSlxhCDpXGTYw0WsF8DrvH+HhIqvCv+E=; h=Received:Received:Received:From:To:Subject:Date:Message-ID: MIME-Version:Content-Type; b=tSKQHOp2d2ZzqOoah+wcbHiIpIcbSOb2Gok/28LxTHfTmixqUYx0agRewy6F4DEBL dCSws/jGe1tZeq3fSlQAbd3oXXNcxBB3l5LZT7b8u27zKwdBVcm/ubNPjThRm/DFu5 uxBbm9c2R+wPHoB0NMKFEAAbWR+KM3xsZTBQ+DjeNA9eZVyZ8ePZK+WhSMzUcFBc76 O5i0yStVQPp8Ar7ePIEDOtk5jvUUaDRo2fCljtoGFct+KbeF0Hulx37c15+Hw4KYTJ ucw+P2INOXU9239aXGwvDWdBmZPZ+0R/K/wH7Y+Q5DCmuk2y27bhHkM7w48VFSSp9O Fp1nAiinsRl3g== X-Pg-Spam-Score: -1.4 (-) 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 mail list writes: > I have WAL archiving enabled and after a failure the other day i tried > to restre using teh wal archives i had . > However one of the WAL archives appera to be 0 bytes and therefore i > cannot restore the wal archives getting the following error Start by seeing if an identically named file is in your master's pg_xlog directory and if so, is it the proper size? > > FATAL: archive file "000000010000000000000010" has wrong size: 0 > instead of 16777216 > > > list of some of the archives > > -rw------- 3 postgres postgres 16777216 Jun 7 08:34 > 00000001000000000000000B > -rw------- 3 postgres postgres 16777216 Jun 8 03:14 > 00000001000000000000000C > -rw------- 3 postgres postgres 16777216 Jun 8 21:44 > 00000001000000000000000D > -rw------- 3 postgres postgres 16777216 Jun 9 16:24 > 00000001000000000000000E > -rw------- 3 postgres postgres 16777216 Jun 10 11:04 > 00000001000000000000000F > -rw------- 3 postgres postgres 0 Jun 10 17:38 > 000000010000000000000010 > -rw------- 3 postgres postgres 16777216 Jun 11 11:54 > 000000010000000000000011 > -rw------- 3 postgres postgres 16777216 Jun 12 05:51 > 000000010000000000000012 > -rw------- 3 postgres postgres 16777216 Jun 13 01:58 > 000000010000000000000013 > -rw------- 3 postgres postgres 16777216 Jun 13 20:38 > 000000010000000000000014 > -rw------- 3 postgres postgres 16777216 Jun 14 15:28 > 000000010000000000000015 > -rw------- 3 postgres postgres 16777216 Jun 15 09:58 > 000000010000000000000016 > -rw------- 3 postgres postgres 16777216 Jun 16 04:28 > 000000010000000000000017 > -rw------- 3 postgres postgres 16777216 Jun 16 23:28 > 000000010000000000000018 > -rw------- 3 postgres postgres 16777216 Jun 17 18:12 > 000000010000000000000019 > > Is there a way around this? -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@comcast.net p: 312.241.7800 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin