Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id EA09A1337B97 for ; Fri, 18 Mar 2011 20:19:56 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 34655-10 for ; Fri, 18 Mar 2011 23:19:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from momjian.us (momjian.us [70.90.9.53]) by mail.postgresql.org (Postfix) with ESMTP id 8BB8E133616B for ; Fri, 18 Mar 2011 20:19:49 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id p2INJp929145 for pgsql-docs@postgresql.org; Fri, 18 Mar 2011 19:19:51 -0400 (EDT) From: Bruce Momjian Message-Id: <201103182319.p2INJp929145@momjian.us> Subject: pg_last_xact_replay_timestamp clarification To: PostgreSQL-documentation Date: Fri, 18 Mar 2011 19:19:51 -0400 (EDT) X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="ELM1300490391-317-0_" Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201103/104 X-Sequence-Number: 6537 --ELM1300490391-317-0_ Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" 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 http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + --ELM1300490391-317-0_ Content-Transfer-Encoding: 7bit Content-Type: text/x-diff Content-Disposition: inline; filename="/rtmp/primary.diff" diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml new file mode 100644 index 8b5c3c5..3106a0f *** a/doc/src/sgml/func.sgml --- b/doc/src/sgml/func.sgml *************** postgres=# SELECT * FROM pg_xlogfile_nam *** 14219,14225 **** timestamp with time zone 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 ---- timestamp with time zone 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 --ELM1300490391-317-0_--