Skip site navigation (1) Skip section navigation (2)

Re: PG synchronous replication and unresponsive slave

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Manoj Govindassamy <manoj(at)nimblestorage(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: PG synchronous replication and unresponsive slave
Date: 2012-01-17 03:44:09
Message-ID: CAHGQGwH5R-iinVkQgmsnUOJJpczY6c-xkwBtcs+wfw9MjzVCNQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
On Tue, Jan 17, 2012 at 3:51 AM, Manoj Govindassamy
<manoj(at)nimblestorage(dot)com> wrote:
>>> 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.

Changing synchronous_commit doesn't affect such a transaction. Instead,
empty synchronous_standby_names and reload the configuration file to
resume that transaction.

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

PostgreSQL doesn't have such a capability, but pgpool-II might have.
Can you ask that in pgpool-II mailing-list?

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

In response to

Responses

pgsql-admin by date

Next:From: Mindaugas ŽakšauskasDate: 2012-01-17 12:44:26
Subject: Establishing remote connections is slow
Previous:From: David M. GulleverDate: 2012-01-16 20:24:41
Subject: apt installation postgresql 8.3

pgsql-general by date

Next:From: P. BroennimannDate: 2012-01-17 08:11:23
Subject: Re: Problem with pgAgent on Ubuntu
Previous:From: Michael TefftDate: 2012-01-17 00:27:11
Subject: PostgreSQL counterpart to DBMS_METADATA?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group