From: A J <s5aly@yahoo.com>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: PG Admin <pgsql-admin@postgresql.org>
Subject: Re: replication_timeout does not seem to be working
Date: Fri, 22 Jul 2011 09:11:25 -0700 (PDT)
Message-ID: <1311351085.55818.YahooMailNeo@web120018.mail.ne1.yahoo.com> (raw)
In-Reply-To: <CAHGQGwH=7eHwbjtnO25T=AH9-D8USov1_ZvrYz7bx+2SRaNWkA@mail.gmail.com>
References: <1311279255.75976.YahooMailNeo@web120016.mail.ne1.yahoo.com>
<CAHGQGwH=7eHwbjtnO25T=AH9-D8USov1_ZvrYz7bx+2SRaNWkA@mail.gmail.com>
I am still not clear. Can you explain what replication_timeout parameter accomplishes and when ?
Basically I wish my synchronous write transaction to not wait indefinitely when the synchronous standby servers are not available. But rather a response returned back to client that write could not be successful, after trying for 'n' seconds. How can that be accomplished ?
Thanks.
________________________________
From: Fujii Masao <masao.fujii@gmail.com>
To: A J <s5aly@yahoo.com>
Cc: PG Admin <pgsql-admin@postgresql.org>
Sent: Friday, July 22, 2011 9:19 AM
Subject: Re: [ADMIN] replication_timeout does not seem to be working
On Fri, Jul 22, 2011 at 5:14 AM, A J <s5aly@yahoo.com> wrote:
> On 9.1, Beta3 I set the following on master
> replication_timeout = 10s # in milliseconds; 0 disables
> With no slaves running, I expect a failure in about 10s. But any Insert just
> hangs. Any idea ?
If you set up synchronous replication but there is no standby server,
all the write transactions are blocked infinitely whether replication_timeout
is enabled or not. If you want to cause those transactions to end, you need
to disable synchronous replication by, for example, emptying
synchronous_standby_names or need to set up new standby.
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: s5aly@yahoo.com, masao.fujii@gmail.com
Subject: Re: replication_timeout does not seem to be working
In-Reply-To: <1311351085.55818.YahooMailNeo@web120018.mail.ne1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox