Re: [GENERAL] Transaction ordering on log-shipping standby

2011-09-20 Thread Simon Riggs
On Tue, Sep 20, 2011 at 11:46 AM, Andrew Rose wrote: > I've got a question about transaction ordering in a log-shipping replication > environment. > > Here's the setup... > > - A pair of PostgreSQL 9 servers in active/standby configuration, using > log-shipping > - A single client, using a singl

Re: [GENERAL] Transaction ordering on log-shipping standby

2011-09-20 Thread Marti Raudsepp
On Tue, Sep 20, 2011 at 13:46, Andrew Rose wrote: > Or to put the question another way, is the ordering of transactions on the > active and standby servers guaranteed to be the same? Yes. The WAL serializes the order of transactions. It is applied to slaves in the same order that it's written on

[GENERAL] Transaction ordering on log-shipping standby

2011-09-20 Thread Andrew Rose
I've got a question about transaction ordering in a log-shipping replication environment. Here's the setup... - A pair of PostgreSQL 9 servers in active/standby configuration, using log-shipping - A single client, using a single connection - The client commits transaction 1 - The client commits