pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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-docs

Attachments:

create_replication_slot_result.v1.patch (text/x-patch, 1.8K) download diff --git a/doc/src/sgml/protocol.sgml b/doc/src/sgml/protocol.sgml index 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>

view thread (2+ messages)  latest in thread

Message-ID: <61101e39-d789-bf88-6bbd-32f2166df349@joh.to>
Permalink:  ../61101e39-d789-bf88-6bbd-32f2166df349@joh.to/
Also on:    postgresql.org/message-id/61101e39-d789-bf88-6bbd-32f2166df349@joh.to

 ·  · 

reply

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