Обсуждение: wal archive showing zero size
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 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?
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
I no longer have pg_xlog so dont know this information .Is there a ways to repair wal archives?
On 07/11/2014 04:44 PM, mail list wrote: > I no longer have pg_xlog so dont know this information .Is there a ways > to repair wal archives? If it's zero size then there's no data there to repair. You can't create data out of nothing. What happened to the original pg_xlog directory you "no longer have"? What archive_command were you using? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services