Transaction ordering on log-shipping standby

From: Andrew Rose <andrew(dot)rose(at)metaswitch(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Transaction ordering on log-shipping standby
Date: 2011-09-20 10:46:09
Message-ID: 632BF61B4D0DEC4AAD03109304ADD5761912E2B4@ENFIRHMBX1.datcon.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 transaction 2
- The active server fails and the standby is promoted to be the active server

The client re-establishes the connection and is attempting to determine which transactions have made it onto the standby server (and which never made it because of replication delays).

Here's the question...

If the client can confirm that transaction 2 has happened on the standby, does that imply that transaction 1 has also made it onto the standby?

Or to put the question another way, is the ordering of transactions on the active and standby servers guaranteed to be the same?

Thanks,

Andrew

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-09-20 10:58:55 Re: COLUMNAR postgreSQL ?
Previous Message Simon Riggs 2011-09-20 08:16:33 Re: COLUMNAR postgreSQL ?