Re: switch UNLOGGED to LOGGED - Mailing list pgsql-hackers

From Noah Misch
Subject Re: switch UNLOGGED to LOGGED
Date
Msg-id 20110518155216.GA29843@tornado.gateway.2wire.net
Whole thread Raw
In response to Re: switch UNLOGGED to LOGGED  (Leonardo Francalanci <m_lists@yahoo.it>)
Responses Re: switch UNLOGGED to LOGGED  (Leonardo Francalanci <m_lists@yahoo.it>)
List pgsql-hackers
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.


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Use of access(X_OK) check in pg_upgrade
Next
From: Magnus Hagander
Date:
Subject: Re: Use of access(X_OK) check in pg_upgrade