GNU.WIKI: The GNU/Linux Knowledge Base
[HOME] [PHP Manual] [HowTo] [ABS] [MAN1] [MAN2] [MAN3] [MAN4] [MAN5] [MAN6] [MAN7] [MAN8] [MAN9]
[0-9] [Aa] [Bb] [Cc] [Dd] [Ee] [Ff] [Gg] [Hh] [Ii] [Jj] [Kk] [Ll] [Mm] [Nn] [Oo] [Pp] [Qq] [Rr] [Ss] [Tt] [Uu] [Vv] [Ww] [Xx] [Yy] [Zz]
CREATE_BARRIER - create a new barrier
CREATE BARRIER barrier_name
The following description applies only to Postgres-XC
CREATE BARRIER is new SQL query specific to Postgres-XC since 0.9.5
that creates a new XLOG record on each node of the cluster
consistently. Barrier is created via a 2PC like mechanism from a remote
Coordinator in 3 phases with a prepare, execute and ending phases. A
new recovery parameter called recovery_target_barrier has been added in
recovery.conf. In order to perform a complete PITR recovery, it is
necessary to set recovery_target_barrier to the value of a barrier
already created. Then distribute recovery.conf to each data folder of
each node, and then to restart the nodes one by one.
Default barrier name is dummy_barrier_id. It is used when no barrier
name is specified when using CREATE BARRIER.
All copyrights belong to their respective owners. Other content (c) 2014-2018, GNU.WIKI. Please report site errors to email@example.com.Page load time: 0.113 seconds. Last modified: November 04 2018 12:49:43.