Jim C. Nasby wrote:
On Wed, Aug 23, 2006 at 10:49:05AM +0200, Martijn van Oosterhout wrote:
    Question: Should be deleted?
I imagine you should probably force a checkpoint and then wipe the wal
records. The WAL isn't going to be able to cover some of the stuff done
during the upgrade, so it'd be useless after anyway.

Is there any way around that? If WAL can't be trusted that means if you
crash during update, you're hosed. Which means you need to backup the
database before upgrading, which greatly increases downtime. Same
applies to having to reindex everything.

By my opinion upgrade process should fail for example during catalog adjustment. This step probably will not have any record in the WAL and you will stay in the middle and ... you will start looking for backup.

Granted, *any* kind of upgrade not requiring a dump/restore is a major

Any really good DBA never do upgrade without backup. It is too dangerous operation. By the way, you can do backup without downtime. Yes, you lost all data after backup. It is risk and DBA must make decision if it is acceptable or not.

Is possible play WAL to get lost data after backup? If yes, you can backup on-line database and first step of upgrade should be move WAL to the safe place.


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?


Reply via email to