Postgres Pro
Downloads
Home   >   mailing lists

Re: tracking commit timestamps - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: tracking commit timestamps
Date
Msg-id CA+U5nMJ2ngXijfckYonVWX_Xa_0N_gAYGm3ZLrHhA5YU5+MGrQ@mail.gmail.com
Whole thread Raw
In response to Re: tracking commit timestamps  (Petr Jelinek <petr@2ndquadrant.com>)
Responses Re: tracking commit timestamps  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Tree view 
On 25 November 2014 at 16:18, Petr Jelinek <petr@2ndquadrant.com> wrote:

> Won't the pg_last_committed_xact() on slave + pg_xact_commit_timestamp() on
> master with the xid returned by slave accomplish the same thing?

Surely the pg_last_committed_xact() will return the same value on
standby as it did on the master?

-- Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Replication connection URI?
Next
From: Adam Brightwell
Date:
Subject: Re: Role Attribute Bitmask Catalog Representation