{"Entry":{"collection":"func","key":"pg-last-xlog-receive-location","name":"pg_last_xlog_receive_location","aliases":[],"metadata":{"changed_in":["9.4"],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"8.4","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"9.0"},{"descriptions_changed":true,"doc_overhaul":false,"from":"9.0","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"9.1"},{"descriptions_changed":false,"doc_overhaul":false,"from":"9.3","group_changed":null,"signatures":{"added":["pg_last_xlog_receive_location ( ) → pg_lsn"],"removed":["pg_last_xlog_receive_location ( ) → text"]},"status":"changed","to":"9.4"},{"descriptions_changed":false,"doc_overhaul":false,"from":"9.6","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"removed","to":"10"}],"content_hash":"f57b06cee14c7c4d851edf7f39e0c416bb7c4bff1d4f8bf3dcacfb5e738f120d","first_version":"9.0","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.544483+08:00","last_version":"9.6","name":"pg_last_xlog_receive_location","name_key":"pg_last_xlog_receive_location","position":29052,"present_in":["9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"signature":"pg_last_xlog_receive_location ( ) → pg_lsn","signature_count":1,"slug":"pg-last-xlog-receive-location","source_rev":"b7bd9cda","summary":"Get last transaction log location received and synced to disk by streaming replication.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-last-xlog-receive-location","SourceDatabase":"center","Version":"9.6","SourceTable":"func","SourceKey":"pg-last-xlog-receive-location","SourceRevision":"b7bd9cda","Facts":{"description":"Get last transaction log location received and synced to disk by streaming replication. While streaming replication is in progress this will increase monotonically. If recovery has completed this will remain static at the value of the last WAL record received and synced to disk during recovery. If streaming replication is disabled, or if it has not yet started, the function returns NULL.","description_html":"Get last transaction log location received and synced to disk by streaming replication. While streaming replication is in progress this will increase monotonically. If recovery has completed this will remain static at the value of the last WAL record received and synced to disk during recovery. If streaming replication is disabled, or if it has not yet started, the function returns NULL.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-RECOVERY-INFO-TABLE","file":"functions-admin.html","slug":"9.6"},"group":"admin","group_label":"System Administration Functions","lang":"en","layout":"table-old","pages":["functions-admin.html"],"prose_only":false,"signatures":[{"description":"Get last transaction log location received and synced to disk by streaming replication. While streaming replication is in progress this will increase monotonically. If recovery has completed this will remain static at the value of the last WAL record received and synced to disk during recovery. If streaming replication is disabled, or if it has not yet started, the function returns NULL.","description_html":"Get last transaction log location received and synced to disk by streaming replication. While streaming replication is in progress this will increase monotonically. If recovery has completed this will remain static at the value of the last WAL record received and synced to disk during recovery. If streaming replication is disabled, or if it has not yet started, the function returns NULL.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_last_xlog_receive_location\u003c/code\u003e ( ) → \u003ccode class=\"returnvalue\"\u003epg_lsn\u003c/code\u003e","returns":"pg_lsn","text":"pg_last_xlog_receive_location ( ) → pg_lsn","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-RECOVERY-INFO-TABLE","file":"functions-admin.html","slug":"9.6"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-last-xlog-receive-location","SourceDatabase":"pgweb","Version":"9.6","Locale":"zh-Hans","Title":"pg_last_xlog_receive_location","Summary":"获取流复制最近接收并同步到磁盘的预写式日志位置。在流复制进行期间，该值单调增加。如果恢复已完成，该值将保持为恢复期间最后接收并同步到磁盘的 WAL 记录的位置。如果禁用了流复制，或者流复制尚未开始，此函数返回 NULL。","BodyHTML":"获取流复制最近接收并同步到磁盘的预写式日志位置。在流复制进行期间，该值单调增加。如果恢复已完成，该值将保持为恢复期间最后接收并同步到磁盘的 WAL 记录的位置。如果禁用了流复制，或者流复制尚未开始，此函数返回 NULL。\u003cpre\u003epg_last_xlog_receive_location ( ) → pg_lsn\u003c/pre\u003e获取流复制最近接收并同步到磁盘的预写式日志位置。在流复制进行期间，该值单调增加。如果恢复已完成，该值将保持为恢复期间最后接收并同步到磁盘的 WAL 记录的位置。如果禁用了流复制，或者流复制尚未开始，此函数返回 NULL。","SourceRevision":"ca936764","ContentHash":"5d625374c390551d4aeb2349a1eb1eee995d70a331a89bc4d48a93608a421f90","Payload":{"description_zh":"获取流复制最近接收并同步到磁盘的预写式日志位置。在流复制进行期间，该值单调增加。如果恢复已完成，该值将保持为恢复期间最后接收并同步到磁盘的 WAL 记录的位置。如果禁用了流复制，或者流复制尚未开始，此函数返回 NULL。","description_zh_html":"获取流复制最近接收并同步到磁盘的预写式日志位置。在流复制进行期间，该值单调增加。如果恢复已完成，该值将保持为恢复期间最后接收并同步到磁盘的 WAL 记录的位置。如果禁用了流复制，或者流复制尚未开始，此函数返回 NULL。","signatures":[{"description_zh":"获取流复制最近接收并同步到磁盘的预写式日志位置。在流复制进行期间，该值单调增加。如果恢复已完成，该值将保持为恢复期间最后接收并同步到磁盘的 WAL 记录的位置。如果禁用了流复制，或者流复制尚未开始，此函数返回 NULL。","description_zh_html":"获取流复制最近接收并同步到磁盘的预写式日志位置。在流复制进行期间，该值单调增加。如果恢复已完成，该值将保持为恢复期间最后接收并同步到磁盘的 WAL 记录的位置。如果禁用了流复制，或者流复制尚未开始，此函数返回 NULL。","returns":"pg_lsn","text":"pg_last_xlog_receive_location ( ) → pg_lsn","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"9.6","Ordinal":0,"Hash":"06bfef29e26b210cc7752104aaec62579b625064c1f453407f8508b3f1c2f88b","Text":"pg_last_xlog_receive_location ( ) → pg_lsn","Returns":"pg_lsn","Payload":{"description":"Get last transaction log location received and synced to disk by streaming replication. While streaming replication is in progress this will increase monotonically. If recovery has completed this will remain static at the value of the last WAL record received and synced to disk during recovery. If streaming replication is disabled, or if it has not yet started, the function returns NULL.","description_html":"Get last transaction log location received and synced to disk by streaming replication. While streaming replication is in progress this will increase monotonically. If recovery has completed this will remain static at the value of the last WAL record received and synced to disk during recovery. If streaming replication is disabled, or if it has not yet started, the function returns NULL.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_last_xlog_receive_location\u003c/code\u003e ( ) → \u003ccode class=\"returnvalue\"\u003epg_lsn\u003c/code\u003e","returns":"pg_lsn","text":"pg_last_xlog_receive_location ( ) → pg_lsn","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}