Simon Riggs wrote: > On Thu, 2010-01-14 at 17:33 +0900, Fujii Masao wrote: > > > I added two new functions; > > > > (1) pg_last_xlog_receive_location() reports the last WAL location received > > and synced by walreceiver. If streaming replication is still in progress > > this will increase monotonically. If streaming replication has completed > > then this value will remain static at the value of the last WAL record > > received and synced. When the server has been started without a > > streaming > > replication then the return value will be InvalidXLogRecPtr (0/0). > > > > (2) pg_last_xlog_replay_location() reports the last WAL location replayed > > during recovery. If recovery is still in progress this will increase > > monotonically. If recovery has completed then this value will remain > > static at the value of the last WAL record applied. When the server has > > been started normally without a recovery then the return value will be > > InvalidXLogRecPtr (0/0). > > I just noticed that these functions have almost the same name as > functions I wrote for Hot Standby and Heikki removed from that patch. > The function code and docs are 99% identical. > > I'm happy that the code was used and it is BSD, though it does seem > strange to have this credited to others in the release notes.
Sorry, release notes updated: Add <link linkend="functions-recovery-info-table"><function>pg_last_xlog_receive_location()</></link> and <function>pg_last_xlog_replay_location()</>, which can be used to monitor standby server <acronym>WAL</> activity (Simon) -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers