NAME

       CREATE_BARRIER - create a new barrier

SYNOPSIS

       CREATE BARRIER barrier_name

DESCRIPTION

           Note

           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.

Postgres-XC 1.1                                    2014-04-07                                  CREATE BARRIER(7)