wal archive showing zero size

Поиск
Список
Период
Сортировка
От mail list
Тема wal archive showing zero size
Дата
Msg-id 53BEF3A6.20403@milidonis.com
обсуждение исходный текст
Ответы Re: wal archive showing zero size  (Jerry Sievers <gsievers19@comcast.net>)
Список pgsql-admin
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?


В списке pgsql-admin по дате отправления:

Предыдущее
От: David Morton
Дата:
Сообщение: Re: Safe to gracefully switch 9.2 streaming replication roles multiple times ?
Следующее
От: Jerry Sievers
Дата:
Сообщение: Re: wal archive showing zero size