I've been working with PG 9.1.8 for two years now, mainly asynchronous replication. Recently, an IT admin of another group contested that the PG's asynchronous replication can result in loss of data in a 1-node failure. After re-readinG the documentation, I cannot determine to what extent this is true.
How do we qualify PG when WALs are written (and archived) on the master, and streaming replication to a hot standby, albeit asynchronous, is used? Is it Group-safe?
My understanding is "Strictly speaking, No".
But what precisely is the algorithm and timing involved with streaming WALs?
Is it:
* client issues COMMIT
* master receives commit
* master processes transaction internally
* master creates WAL record
| master appends WAL to local WAL file, flushes disk
| master sends WAL record to all streaming clients
* master sends OK to client
* master applies WAL
So is this correct? Is it correct to say: PG async guarantees that the WAL is *sent* to the receivers, but not that they are received, before the client receives acknowledgement?
Can we make a case stronger than that? Assuming the T0 is round trip time between master and client, and T1 is round trip time between master and slave, as long as T1 <= T0, and provided both Slave and Master do not fail, the system is Group-safe?
--