Re: synchronous_standby_names with '*'

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: alexondi <alexondi(at)rambler(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: synchronous_standby_names with '*'
Date: 2011-08-19 11:27:10
Message-ID: CAHGQGwE_gjpkidO3+xM+5W6GHo1UrM8K0sTt_zZyZRSehuWzRw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 19, 2011 at 8:04 PM, alexondi <alexondi(at)rambler(dot)ru> wrote:
> but if I don't have any slave at this time why my command hang?

Because there is no standby at that time ;)

If synchronous replication is enabled but there is no standby connecting
to the master, a write transaction waits until at least one synchronous
standby has appeared and its WAL has been replicated to it.

Regards,

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message alexondi 2011-08-19 11:39:02 Re: synchronous_standby_names with '*'
Previous Message Jayadevan M 2011-08-19 11:19:34 Getting value of bind variables