aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--doc/src/sgml/func.sgml10
-rw-r--r--src/backend/access/transam/xlog.c4
2 files changed, 14 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 736eb67dfff..c363949b7c5 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -14070,6 +14070,16 @@ postgres=# select pg_start_backup('label_goes_here');
</para>
<para>
+ <function>pg_create_restore_point</> creates a named transaction log
+ record that can be used as recovery target, and returns the corresponding
+ transaction log location. The given name can then be used with
+ <xref linkend="recovery-target-name"> to specify the point up to which
+ recovery will proceed. Avoid creating multiple restore points with the
+ same name, since recovery will stop at the first one whose name matches
+ the recovery target.
+ </para>
+
+ <para>
<function>pg_current_xlog_location</> displays the current transaction log write
location in the same format used by the above functions. Similarly,
<function>pg_current_xlog_insert_location</> displays the current transaction log
diff --git a/src/backend/access/transam/xlog.c b/src/backend/access/transam/xlog.c
index 3ba1f29197f..b4eb4ac2cce 100644
--- a/src/backend/access/transam/xlog.c
+++ b/src/backend/access/transam/xlog.c
@@ -8144,6 +8144,10 @@ XLogRestorePoint(const char *rpName)
RecPtr = XLogInsert(RM_XLOG_ID, XLOG_RESTORE_POINT, &rdata);
+ ereport(LOG,
+ (errmsg("restore point \"%s\" created at %X/%X",
+ rpName, RecPtr.xlogid, RecPtr.xrecoff)));
+
return RecPtr;
}