[ADMIN] How to Identify and Fail Transaction When Slave Node Down - Mailing list pgsql-admin

From Anushka Weerakkodyge
Subject [ADMIN] How to Identify and Fail Transaction When Slave Node Down
Date
Msg-id CAMsriHZ9jk5xkozbYfiD9asvpXQyRbsH01UZBF=XmNRg3=SRwg@mail.gmail.com
Whole thread Raw
Responses Re: [ADMIN] How to Identify and Fail Transaction When Slave Node Down
List 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

pgsql-admin by date:

Previous
From: Mario De Frutos
Date:
Subject: [ADMIN] Convert existing syslog logs to csvlog
Next
From: Anushka Weerakkodyge
Date:
Subject: Re: [ADMIN] How to Identify and Fail Transaction When Slave Node Down