Hot standby, dropping a tablespace - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Hot standby, dropping a tablespace
Date
Msg-id 497B72D6.7080001@enterprisedb.com
Whole thread Raw
Responses Re: Hot standby, dropping a tablespace  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
When replaying a DROP TABLE SPACE, you first try to remove the 
directory, and if that fails, you assume that it's because it's in use 
as a temp tablespace in a read-only transaction. You then call 
ResolveRecoveryConflictWithVirtualXIDs to kill such transactions, and 
try removing the directory again. But 
ResolveRecoveryConflictWithVirtualXIDs doesn't wait for the target 
transaction to die anymore (or at least it shouldn't, as we discussed 
earlier), so that doesn't work AFAICS.

One quick work around would be to simply not respect temp_tablespace 
during recovery...

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Pluggable Indexes
Next
From: Andrew Chernow
Date:
Subject: UnixWare 7.1.4 (and OpenServer) sigwait issue