Re: Aborted VACUUM FULL -> crash + corruption (xlog non-existent) - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: Aborted VACUUM FULL -> crash + corruption (xlog non-existent)
Date
Msg-id 20080826162559.GJ4920@alvh.no-ip.org
Whole thread Raw
In response to Re: Aborted VACUUM FULL -> crash + corruption (xlog non-existent)  (Peter Schuller <peter.schuller@infidyne.com>)
List pgsql-bugs
Peter Schuller wrote:

> It would be embarressing if I caused this problem myself by
> misunderstanding wal_archiving. My understanding has been that once
> wal_archive gets called, no one ever cares what happens with the file
> except if I want to do PITR (since the whole point is to offload it
> somewhere or similar).
>
> I'll go and re-read the documentation on this immediately. If this is
> the problem, I do apologies for the noise and people's time.

Yeah, this is the problem.  The archive command must not delete the
file it is copying.  It is supposed to only copy it.  The file must
continue to be on the server until a checkpoint is executed.

In fact you'd have a problem on recovery after any crash, not just
vacuum full.

I think it's the documentation's fault that this is not a lot more
prominent.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-bugs by date:

Previous
From: Peter Schuller
Date:
Subject: Re: Aborted VACUUM FULL -> crash + corruption (xlog non-existent)
Next
From: Alvaro Herrera
Date:
Subject: Re: Aborted VACUUM FULL -> crash + corruption (xlog non-existent)