mail list <mailist@xxxxxxxxxxxxx> 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@xxxxxxxxxxx p: 312.241.7800
