Subject changed to describe the problem. Reply in-line. On 09/04/2012 07:57 PM, Herouth Maoz wrote:
The issue is that when an insert or an update is fired, I can't say whether all the segments of the same transaction have been written yet, and if only some of them were written, there is no guarantee on the order in which they are written.
Does Slony-I provide stronger guarantees? If your replication doesn't guarantee ordering then you're going to have a very hard time doing this.
Is this feasible at all? How would you achieve it?
I'd try to find a replication system that guaranteed ordering if at all possible.
-- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
