REPLICATION_STATUS

Monitors the status of server-based data replication.

Shows the status of current and past server-based replication of data from another Eon Mode database to this database. Each row records node-specific information about a given replication. For more information about server-based replication, see Server-based replication.

Note

If you replicate data between the main cluster and a sandboxed cluster, the SENT_BYTES and TOTAL_BYTES_TO_SEND columns will both have a value of zero. Because the clusters use the same communal storage location, no data is actually copied between the two clusters.

Column name	Data type	Description
NODE_NAME	VARCHAR(128)	Name of the node participating in the replication.
TRANSACTION_ID	INT	Transaction in which the replication took place.
OPERATION_NAME	VARCHAR	Name of the replication operation for which information is listed, one of the following: `load_snapshot_prep`: Catalog files from the source database are copied to `NODE_NAME` and analyzed to determine which storage files need to be copied to the target database. `data_transfer`: Storage files from the source database are copied to the target database's communal storage. `load_snapshot`: Catalog objects loaded during `load_snapshot_prep` are installed on the node.
STATUS	VARCHAR(8192)	State of the `OPERATION_NAME` operation, one of the following: `failed`: The operation did not complete successfully. `completed`: The operation has completed. `started`: The operation is in progress on the node.
SENT_BYTES	INT	Number of bytes that the node has retrieved from the source database's communal storage.
TOTAL_BYTES_TO_SEND	INT	Total number of bytes the node has to retrieve from the source database's communal storage for this replication.
START_TIME	TIMESTAMPTZ	Start time of the replication.
END_TIME	TIMESTAMPTZ	Time at which the node finished transferring data for the replication.

Example

=> SELECT node_name, opeartion_name, status FROM REPLICATION_STATUS 
   ORDER BY node_name;
       node_name       |   operation_name   |  status         
-----------------------+--------------------+-----------
 v_target_db_node0001  | load_snapshot_prep | completed        
 v_target_db_node0001  | data_transfer      | completed         
 v_target_db_node0001  | load_snapshot      | completed        
 v_target_db_node0002  | load_snapshot_prep | completed        
 v_target_db_node0002  | data_transfer      | completed         
 v_target_db_node0002  | load_snapshot      | completed         
 v_target_db_node0003  | load_snapshot_prep | completed
 v_target_db_node0003  | data_transfer      | completed
 v_target_db_node0003  | load_snapshot      | completed
(9 rows)