Re: Transaction ordering on log-shipping standby

From: Marti Raudsepp <marti(at)juffo(dot)org>
To: Andrew Rose <andrew(dot)rose(at)metaswitch(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Transaction ordering on log-shipping standby
Date: 2011-09-20 13:51:12
Message-ID: CABRT9RDUq6GEku6mTw-xrZpo8dMqhYvfFqZ+DJ6TMjop5Zg2jg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Sep 20, 2011 at 13:46, Andrew Rose <andrew(dot)rose(at)metaswitch(dot)com> 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 the master.

Regards,
Marti

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Harald Fuchs 2011-09-20 14:02:52 Re: Column Privileges: NULL instead of permission denied
Previous Message Marti Raudsepp 2011-09-20 13:32:50 Re: Seeing foreign key lookups in explain output