On Wed, May 18, 2011 at 04:02:59PM +0100, Leonardo Francalanci wrote:
> > By the time the startup process
> > releases the AccessExclusiveLock acquired by the proposed
> > UNLOGGED -> normal conversion process, that relfilenode
> > needs to be either fully copied or unlinked all over again.
> > (Alternately, find some other way to make sure queries don't
> > read the half-copied file.)
>
> About this issue: how are AccessExclusiveLocks released on
> the standby when the master crashes?
I assume those locks remain. It wouldn't be safe to release them; a master
crash is just one kind of WAL receipt latency.
When you promote the standby, though, ShutdownRecoveryTransactionEnvironment()
releases the locks.