From e63bb4549a2f47b86de9fc21c9f8b00440f34f99 Mon Sep 17 00:00:00 2001 From: Simon Riggs Date: Tue, 12 Jan 2016 07:54:52 +0000 Subject: Add new user fn pg_current_xlog_flush_location() Tomas Vondra, reviewed by Michael Paquier and Amit Kapila Minor edits by me --- src/backend/access/transam/xlogfuncs.c | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) (limited to 'src/backend/access/transam/xlogfuncs.c') diff --git a/src/backend/access/transam/xlogfuncs.c b/src/backend/access/transam/xlogfuncs.c index 42168985e0c..31cbb01ce47 100644 --- a/src/backend/access/transam/xlogfuncs.c +++ b/src/backend/access/transam/xlogfuncs.c @@ -215,6 +215,27 @@ pg_current_xlog_insert_location(PG_FUNCTION_ARGS) PG_RETURN_LSN(current_recptr); } +/* + * Report the current WAL flush location (same format as pg_start_backup etc) + * + * This function is mostly for debugging purposes. + */ +Datum +pg_current_xlog_flush_location(PG_FUNCTION_ARGS) +{ + XLogRecPtr current_recptr; + + if (RecoveryInProgress()) + ereport(ERROR, + (errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE), + errmsg("recovery is in progress"), + errhint("WAL control functions cannot be executed during recovery."))); + + current_recptr = GetFlushRecPtr(); + + PG_RETURN_LSN(current_recptr); +} + /* * Report the last WAL receive location (same format as pg_start_backup etc) * -- cgit v1.2.3