summaryrefslogtreecommitdiff
path: root/doc
diff options
context:
space:
mode:
authorSimon Riggs <simon@2ndQuadrant.com>2014-11-17 22:15:07 +0000
committerSimon Riggs <simon@2ndQuadrant.com>2014-11-17 22:15:07 +0000
commitbe1cc8f46f57a04e69d9e4dd268d34da885fe6eb (patch)
treef3e01a1f2f19a13fa4542d2a3e82db70f2f2dede /doc
parent832054044f68080eaebccd771e21fdd56824db20 (diff)
Add pg_dump --snapshot option
Allows pg_dump to use a snapshot previously defined by a concurrent session that has either used pg_export_snapshot() or obtained a snapshot when creating a logical slot. When this option is used with parallel pg_dump, the snapshot defined by this option is used and no new snapshot is taken. Simon Riggs and Michael Paquier
Diffstat (limited to 'doc')
-rw-r--r--doc/src/sgml/ref/pg_dump.sgml21
1 files changed, 21 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml
index c92c6eef5d3..a6e7b08e2e2 100644
--- a/doc/src/sgml/ref/pg_dump.sgml
+++ b/doc/src/sgml/ref/pg_dump.sgml
@@ -848,6 +848,27 @@ PostgreSQL documentation
</varlistentry>
<varlistentry>
+ <term><option>--snapshot=<replaceable class="parameter">snapshotname</replaceable></option></term>
+ <listitem>
+ <para>
+ Use the specifed synchronized snapshot when making a dump of the
+ database (see
+ <xref linkend="functions-snapshot-synchronization-table"> for more
+ details).
+ </para>
+ <para>
+ This option is useful when needing to synchronize the dump with
+ a logical replication slot (see <xref linkend="logicaldecoding">)
+ or with a concurrent session.
+ </para>
+ <para>
+ In the case of a parallel dump, the snapshot name defined by this
+ option is used rather than taking a new snapshot.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
<term><option>--serializable-deferrable</option></term>
<listitem>
<para>