How to Identify and Fail Transaction When Slave Node Down

From: Anushka Weerakkodyge <anushkaw(at)ceylonit(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to Identify and Fail Transaction When Slave Node Down
Date: 2017-03-15 23:51:23
Message-ID: CAMsriHZ9jk5xkozbYfiD9asvpXQyRbsH01UZBF=XmNRg3=SRwg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

I have a synchronous streaming replication environment which is implemented
using inbuilt replication mechanism in postgresql. Replication is working
fine except I need to fail the data modification transactions when the
slave node is not accessible.

Is it possible?

Please let me know whether there is a way to identify slave node status and
fail the transaction using any inbuilt mechanism or some other technique.

Thanks,
Anushka

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Anushka Weerakkodyge 2017-03-16 09:06:19 Re: How to Identify and Fail Transaction When Slave Node Down
Previous Message Mario De Frutos 2017-03-15 20:51:35 Convert existing syslog logs to csvlog