Hot standby, dropping a tablespace

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Hot standby, dropping a tablespace
Дата
Msg-id 497B72D6.7080001@enterprisedb.com
обсуждение исходный текст
Ответы Re: Hot standby, dropping a tablespace  (Simon Riggs <simon@2ndQuadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Pluggable Indexes
Следующее
От: Andrew Chernow
Дата:
Сообщение: UnixWare 7.1.4 (and OpenServer) sigwait issue