Postgres Pro
Downloads
Home   >   mailing lists

Re: synchronous_standby_names with '*' - Mailing list pgsql-general

From Fujii Masao
Subject Re: synchronous_standby_names with '*'
Date
Msg-id CAHGQGwE_gjpkidO3+xM+5W6GHo1UrM8K0sTt_zZyZRSehuWzRw@mail.gmail.com
Whole thread Raw
In response to Re: synchronous_standby_names with '*'  (alexondi <alexondi@rambler.ru>)
Responses Re: synchronous_standby_names with '*'
List pgsql-general
Tree view 
On Fri, Aug 19, 2011 at 8:04 PM, alexondi <alexondi@rambler.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

pgsql-general by date:

Previous
From: Jayadevan M
Date:
Subject: Getting value of bind variables
Next
From: alexondi
Date:
Subject: Re: synchronous_standby_names with '*'