From: Bruce Momjian <bruce@momjian.us>
To: PostgreSQL-documentation <pgsql-docs@postgresql.org>
Subject: pg_last_xact_replay_timestamp clarification
Date: Fri, 18 Mar 2011 19:19:51 -0400 (EDT)
Message-ID: <201103182319.p2INJp929145@momjian.us> (raw)
The attached, applied patch documents that the timestamp returned by
pg_last_xact_replay_timestamp is the time on the _primary_ that the
transaction was generated.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
Attachments:/rtmp/primary.diff (text/x-diff, 1.2K) downloaddiff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgmlnew file mode 100644index 8b5c3c5..3106a0f
*** a/doc/src/sgml/func.sgml
--- b/doc/src/sgml/func.sgml
*************** postgres=# SELECT * FROM pg_xlogfile_nam
*** 14219,14225 ****
<entry><type>timestamp with time zone</type></entry>
<entry>Get timestamp of last transaction replayed during recovery.
This is the time at which the commit or abort WAL record for that
! transaction was generated.
If no transactions have been replayed during recovery, this function
returns NULL. Otherwise, if recovery is still in progress this will
increase monotonically. If recovery has completed then this value will
--- 14219,14225 ----
<entry><type>timestamp with time zone</type></entry>
<entry>Get timestamp of last transaction replayed during recovery.
This is the time at which the commit or abort WAL record for that
! transaction was generated on the primary.
If no transactions have been replayed during recovery, this function
returns NULL. Otherwise, if recovery is still in progress this will
increase monotonically. If recovery has completed then this value will
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: bruce@momjian.us
Subject: Re: pg_last_xact_replay_timestamp clarification
In-Reply-To: <201103182319.p2INJp929145@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox