From: Marko Tiikkaja <marko@joh.to>
To: pgsql-docs@postgresql.org
Subject: CREATE_REPLICATION_SLOT exported snapshot
Date: Sun, 11 Sep 2016 12:23:30 +0200
Message-ID: <61101e39-d789-bf88-6bbd-32f2166df349@joh.to> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
Hi,
There's a brief mention of CREATE_REPLICATION_SLOT exporting a snapshot
here:
https://www.postgresql.org/docs/devel/static/logicaldecoding-explanation.html#AEN71570
but how to access the snapshot identifier is not documented anywhere.
So I came up with the attached patch (against master). Please have a
looksie.
.m
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docsAttachments:create_replication_slot_result.v1.patch (text/x-patch, 1.8K) downloaddiff --git a/doc/src/sgml/protocol.sgml b/doc/src/sgml/protocol.sgmlindex 68b0941..6bf8354 100644--- a/doc/src/sgml/protocol.sgml+++ b/doc/src/sgml/protocol.sgml@@ -1475,6 +1475,49 @@ The commands accepted in walsender mode are:
</listitem>
</varlistentry>
</variablelist>
+ <para>+ In response to this command, the server will send a one-row result set+ containing the following fields:+ <variablelist>+ <varlistentry>+ <term><literal>slot_name</literal> (<type>text</type>)</term>+ <listitem>+ <para>+ The name of the newly-created replication slot.+ </para>+ </listitem>+ </varlistentry>+ <varlistentry>+ <term><literal>consistent_point</literal> (<type>text</type>)</term>+ <listitem>+ <para>+ The WAL position at which the slot became consistent. This is the+ earliest location from which streaming can start on this replication+ slot.+ </para>+ </listitem>+ </varlistentry>+ <varlistentry>+ <term><literal>snapshot_name</literal> (<type>text</type>)</term>+ <listitem>+ <para>+ The identifier of the snapshot exported by the command. The snapshot+ is valid until a new command is executed or the replication connection is+ closed. NULL if the created slot is physical.+ </para>+ </listitem>+ </varlistentry>+ <varlistentry>+ <term><literal>output_plugin</literal> (<type>text</type>)</term>+ <listitem>+ <para>+ The name of the output plugin used by the newly-created replication+ slot. NULL if the created slot is physical.+ </para>+ </listitem>+ </varlistentry>+ </variablelist>+ </para>
</listitem>
</varlistentry>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-docs@postgresql.org
Cc: marko@joh.to
Subject: Re: CREATE_REPLICATION_SLOT exported snapshot
In-Reply-To: <61101e39-d789-bf88-6bbd-32f2166df349@joh.to>
References: <61101e39-d789-bf88-6bbd-32f2166df349@joh.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox