Horton

Re: switch UNLOGGED to LOGGED

Leonardo Francalanci <m_lists@yahoo.it>

View thread
From: Leonardo Francalanci <m_lists@yahoo.it>
To: Noah Misch <noah@leadboat.com>
Cc: Robert Haas <robertmhaas@gmail.com>, pgsql-hackers@postgresql.org
Date: 2011-05-18T15:02:59Z
Lists: pgsql-hackers 
> 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?