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. -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers