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
Page load time: 0.113 seconds. Last modified: November 04 2018 12:49:43.