PGXC_REPLICATION_SLOTS
PGXC_REPLICATION_SLOTS displays the replication information of DNs in the cluster. All columns except node_name are the same as those in the PG_REPLICATION_SLOTS view. This view is accessible only to users with system administrators rights.
| 
        Column  | 
      
        Type  | 
      
        Description  | 
     
|---|---|---|
| 
        node_name  | 
      
        Text  | 
      
        Node name  | 
     
| 
        slot_name  | 
      
        Text  | 
      
        Name of a replication node  | 
     
| 
        plugin  | 
      
        Name  | 
      
        Name of the output plug-in of the logical replication slot  | 
     
| 
        slot_type  | 
      
        Text  | 
      
        Type of a replication node  | 
     
| 
        datoid  | 
      
        OID  | 
      
        OID of the database on the replication node  | 
     
| 
        database  | 
      
        Name  | 
      
        Name of the database on the replication node  | 
     
| 
        active  | 
      
        boolean  | 
      
        Whether the replication node is active  | 
     
| 
        xmin  | 
      
        Xid  | 
      
        Transaction ID of the replication node  | 
     
| 
        catalog_xmin  | 
      
        Text  | 
      
        ID of the earliest-decoded transaction corresponding to the logical replication slot  | 
     
| 
        restart_lsn  | 
      
        Text  | 
      
        Xlog file information on the replication node  | 
     
| 
        dummy_standby  | 
      
        boolean  | 
      
        Whether the replication node is the dummy standby node  | 
     
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.