From: Jerry Sievers <gsievers19@comcast.net>
To: mail list <mailist@milidonis.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: wal archive showing zero size
Date: Thu, 10 Jul 2014 15:43:22 -0500
Message-ID: <86egxtosgl.fsf@jerry.enova.com> (raw)
In-Reply-To: <53BEF3A6.20403@milidonis.com>
References: <53BEF3A6.20403@milidonis.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
mail list <mailist@milidonis.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gsievers19@comcast.net, mailist@milidonis.com
Subject: Re: wal archive showing zero size
In-Reply-To: <86egxtosgl.fsf@jerry.enova.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox