> I'm thinking the client should get some kind of a token back from the commit, and it could use the token on the standby, to wait for that commit to be applied. The token could be just the XID, or the LSN of the commit record. Or the application could generate the token and pass it to the server in the commit, similar to how 2PC works. So the interaction would be something like: > > In master: > BEGIN; > INSERT INTO FOO ...; > COMMIT; > Server returns: COMMITted with token 1234 > > Later, in standby: > BEGIN WAIT FOR COMMIT 1234 TO BE VISIBLE; > SELECT * FROM foo;
+1. The LSN should be good enough IMO.
