Postgres Pro
Downloads
Home   >   mailing lists

Re: Transaction ordering on log-shipping standby - Mailing list pgsql-general

From Marti Raudsepp
Subject Re: Transaction ordering on log-shipping standby
Date
Msg-id CABRT9RDUq6GEku6mTw-xrZpo8dMqhYvfFqZ+DJ6TMjop5Zg2jg@mail.gmail.com
Whole thread Raw
In response to Transaction ordering on log-shipping standby  (Andrew Rose <andrew.rose@metaswitch.com>)
List pgsql-general
Tree view 
On Tue, Sep 20, 2011 at 13:46, Andrew Rose <andrew.rose@metaswitch.com> wrote:
> Or to put the question another way, is the ordering of transactions on the active and standby servers guaranteed to
bethe same? 

Yes. The WAL serializes the order of transactions. It is applied to
slaves in the same order that it's written on the master.

Regards,
Marti

pgsql-general by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: Seeing foreign key lookups in explain output
Next
From: Harald Fuchs
Date:
Subject: Re: Column Privileges: NULL instead of permission denied