Async replication: how to get an alert on failure

Edson Richter <richter@xxxxxxxxxxxxxx> · Wed, 01 Aug 2012 19:29:57 -0300



    I have few PostgreSQL servers established with replication.

    Now, is there any way to receive an e-mail in case of error during
    synchronization?

    I mean, is there an script I can run (maybe every 5 minutes) that
    will check if replication is stolen, and send an e-mail in case of
    failure?

    
    Thanks,

    -- 

      
                Edson Carlos Ericksson Richter
              

              SimKorp Informática Ltda
            
          
            Fone:
            (51) 3366-7964
          
          
            Celular:
            (51)9318-9766/(51)
                8585-0796