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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers