IBM QRadar SOAR

IBM QRadar SOAR

Join this online user group to communicate across Security product users and IBM experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 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
    ------------------------------