IBM Security QRadar SOAR

 View Only
Expand all | Collapse all

Postgresql Replication Status: Not running, Retained transactions=33495984 bytes

  • 1.  Postgresql Replication Status: Not running, Retained transactions=33495984 bytes

    Posted Fri January 21, 2022 02:30 AM

    HI All,


    I reverted my Master and DR snapshot and saw this message when doing "sudo resDrStatus"
    Postgresql Replication Status: Not running, Retained transactions=33495984 bytes
    File Replication Status: Running (Synced)

    Both postgresql-9.6 and resilient-filesync is running. Is there any other services that should be running? Or how can I make Postgresql Replication Status back to running?



    ------------------------------
    Sebastian Wong
    ------------------------------



  • 2.  RE: Postgresql Replication Status: Not running, Retained transactions=33495984 bytes

    Posted Mon January 24, 2022 04:34 AM
    Hi Sebastian,

    This means the streaming data replication is not working. Looking at the logs in /var/lib/pgsql/9.6/data/pg_log/ for both servers would be the first place to look.

    Take a look at https://www.ibm.com/support/pages/node/6090970 for a starting point and also https://www.ibm.com/support/pages/node/1160224

    If you can't work it out then open a case with IBM Support with all the information from https://www.ibm.com/support/pages/node/6090970


    ------------------------------
    BEN WILLIAMS
    ------------------------------