Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> writes:
>> We scan the log and come upon the rename.
>> Hmm, there's a file foo and no file bar ... looks like the
>> rename didn't get done, so do it. Ooops.
> No again. You come upon "starting rename operation" and then either
> no more log records (backend abort)
> log record "rename succeeded"
> log record "rename failed" --> transaction abort
> In this scenario you can decide what to do without second guessing.
If there are no more records, then you are reduced to guessing whether
you have to undo the rename or not. If you guess wrong, you leave the
database in a corrupted state.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Jeffery Collins||Date: 2000-07-26 14:37:26|
|Subject: Re: Some questions on user defined types and functions.|
|Previous:||From: Fabrice Scemama||Date: 2000-07-26 14:01:18|
|Subject: Is Pg 7.0.x's Locking Mechanism BROKEN?|