pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedwal archive showing zero size
4+ messages / 3 participants
[nested] [flat]
* wal archive showing zero size
@ 2014-07-10 20:12 mail list <mailist@milidonis.com>
2014-07-10 20:43 ` Re: wal archive showing zero size Jerry Sievers <gsievers19@comcast.net>
0 siblings, 1 reply; 4+ messages in thread
From: mail list @ 2014-07-10 20:12 UTC (permalink / raw)
To: 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?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: wal archive showing zero size
2014-07-10 20:12 wal archive showing zero size mail list <mailist@milidonis.com>
@ 2014-07-10 20:43 ` Jerry Sievers <gsievers19@comcast.net>
2014-07-11 08:44 ` Re: wal archive showing zero size mail list <mailist@milidonis.com>
0 siblings, 1 reply; 4+ messages in thread
From: Jerry Sievers @ 2014-07-10 20:43 UTC (permalink / raw)
To: mail list <mailist@milidonis.com>; +Cc: pgsql-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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: wal archive showing zero size
2014-07-10 20:12 wal archive showing zero size mail list <mailist@milidonis.com>
2014-07-10 20:43 ` Re: wal archive showing zero size Jerry Sievers <gsievers19@comcast.net>
@ 2014-07-11 08:44 ` mail list <mailist@milidonis.com>
2014-07-14 02:07 ` Re: wal archive showing zero size Craig Ringer <craig@2ndquadrant.com>
0 siblings, 1 reply; 4+ messages in thread
From: mail list @ 2014-07-11 08:44 UTC (permalink / raw)
To: pgsql-admin
I no longer have pg_xlog so dont know this information .Is there a ways
to repair wal archives?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: wal archive showing zero size
2014-07-10 20:12 wal archive showing zero size mail list <mailist@milidonis.com>
2014-07-10 20:43 ` Re: wal archive showing zero size Jerry Sievers <gsievers19@comcast.net>
2014-07-11 08:44 ` Re: wal archive showing zero size mail list <mailist@milidonis.com>
@ 2014-07-14 02:07 ` Craig Ringer <craig@2ndquadrant.com>
0 siblings, 0 replies; 4+ messages in thread
From: Craig Ringer @ 2014-07-14 02:07 UTC (permalink / raw)
To: mail list <mailist@milidonis.com>; pgsql-admin
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2014-07-14 02:07 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-07-10 20:12 wal archive showing zero size mail list <mailist@milidonis.com>
2014-07-10 20:43 ` Jerry Sievers <gsievers19@comcast.net>
2014-07-11 08:44 ` mail list <mailist@milidonis.com>
2014-07-14 02:07 ` Craig Ringer <craig@2ndquadrant.com>
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