PG_Logical_Troubleshooting:

Pglogical Replication Trouble shooting:

in general as we complete setting up pglogical replication we need to monitor the replication from source to target database.

Below Queries will Help to identify the Replication Progress and Status.

Topics Covered.

  1. List Tables Registered in Pglogical
  2. How much GB we are behind from source to target.
  3. How much GB we are behind from source to target.
  4. Replication_lag_from_source_target_in_bytes.

1.List tables registered in Pglogical.

 

2.How much GB we are behind from source to target.

 

3.How much GB we are behind from source to target.

 

4.Replication_lag_from_source_target_in_bytes.

Leave a Reply

Your email address will not be published. Required fields are marked *