PG synchronous replication and unresponsive slave

From: Manoj Govindassamy <manoj(at)nimblestorage(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: PG synchronous replication and unresponsive slave
Date: 2012-01-11 21:50:48
Message-ID: 4F0E0438.5070300@nimblestorage.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hi,

I have a PG 9.1.2 Master <--> Slave with synchronous replication setup.
They are all working fine as expected. I do have a case where I want to
flip Master to non replication mode whenever its slave is not
responding. I have set replication_timeout to 5s and whenever salve is
not responding for for more than 5s, i see the master detecting it. But,
the transactions on the master is stuck till the slave comes back. To
get over it, I reloaded the config on master with synchronous_commit =
local. Further transactions on the master are going thru fine with this
local commits turned on.

Here are my questions:

1. Transaction which was stuck right when slave going away never went
thru even after I reloaded master's config with local commit on. I do
see all new transactions on master are going thru fine, except the one
which was stuck initially. How to get this stuck transaction complete or
return with error.

2. Whenever there is a problem with slave, I have to manually reload
master's config with local commit turned on to get master go forward. Is
there any automated way to reload this config with local commit on on
slave's unresponsiveness ? tcp connection timeouts, replication timeouts
all detect the failures, but i want to run some corrective action on
these failure detection.

--
thanks,
Manoj

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rahimeh Khodadadi 2012-01-12 13:27:29 Re: Kerberized login to Postgres database
Previous Message Gémes Géza 2012-01-11 19:43:25 Re: Kerberized login to Postgres database

Browse pgsql-general by date

  From Date Subject
Next Message Michael Daines 2012-01-11 23:10:06 Parameterized Query Pegs the DB
Previous Message Kirill Müller 2012-01-11 21:36:14 Re: Enumeration of tables is very slow in largish database