"Ed L." <pgsql(at)bluepolka(dot)net> writes:
> Actually, dbmirror does it in a couple of steps, but I think this is the
> basic idea. So the queued tuple changes are groupable (and thus
> replayable) by xid and order of queueing. Then the slave gets them in the
> hopefully-correct order via
> select ...
> from queue q
> where q.xid is in some appropriate range
> order by xid asc, tuple_id asc;
I think this last part is wrong. It shouldn't be using the xid as part
of the ordering, only the sequence value.
regards, tom lane