On 05.10.2010 12:47, Fujii Masao wrote:
> I have another question: when should the waiting transactions resume?
> It's a moment the standby has connected to the master? It's a moment
> the standby has caught up with the master? For no data loss, the
> latter seems to be required. Right?
Yep.
> The third question: if the WAL file is unfortunately recycled when a
> transaction waits for that WAL file to be shipped forever, how should
> that transaction behave? Still waiting? Cause PANIC? Give up waiting?
> For no data loss, ISTM that the second should be chosen. Right?
Right, it should keep waiting.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com