diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2018-04-07 11:24:53 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2018-04-07 11:34:11 -0400 |
| commit | 039eb6e92f20499ac36cc74f8a5cef7430b706f6 (patch) | |
| tree | 2cf52aeafb59917d5c7ed396acb6d86325b4a8b0 /doc/src/sgml/ref | |
| parent | 5dfd1e5a6696b271a2cdee54143fbc209c88c02f (diff) | |
Logical replication support for TRUNCATE
Update the built-in logical replication system to make use of the
previously added logical decoding for TRUNCATE support. Add the
required truncate callback to pgoutput and a new logical replication
protocol message.
Publications get a new attribute to determine whether to replicate
truncate actions. When updating a publication via pg_dump from an older
version, this is not set, thus preserving the previous behavior.
Author: Simon Riggs <simon@2ndquadrant.com>
Author: Marco Nenciarini <marco.nenciarini@2ndquadrant.it>
Author: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Reviewed-by: Petr Jelinek <petr.jelinek@2ndquadrant.com>
Reviewed-by: Andres Freund <andres@anarazel.de>
Reviewed-by: Alvaro Herrera <alvherre@alvh.no-ip.org>
Diffstat (limited to 'doc/src/sgml/ref')
| -rw-r--r-- | doc/src/sgml/ref/create_publication.sgml | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/create_publication.sgml b/doc/src/sgml/ref/create_publication.sgml index bfe12d5f410..99f87ca3938 100644 --- a/doc/src/sgml/ref/create_publication.sgml +++ b/doc/src/sgml/ref/create_publication.sgml @@ -106,10 +106,11 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable> This parameter determines which DML operations will be published by the new publication to the subscribers. The value is comma-separated list of operations. The allowed operations are - <literal>insert</literal>, <literal>update</literal>, and - <literal>delete</literal>. The default is to publish all actions, + <literal>insert</literal>, <literal>update</literal>, + <literal>delete</literal>, and <literal>truncate</literal>. + The default is to publish all actions, and so the default value for this option is - <literal>'insert, update, delete'</literal>. + <literal>'insert, update, delete, truncate'</literal>. </para> </listitem> </varlistentry> @@ -168,8 +169,7 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable> </para> <para> - <command>TRUNCATE</command> and <acronym>DDL</acronym> operations - are not published. + <acronym>DDL</acronym> operations are not published. </para> </refsect1> |