Re: is sync rep stalled?

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