Re: switch UNLOGGED to LOGGED

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.