Postgres Pro
Downloads
Home   >   mailing lists

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

From Simon Riggs
Subject Re: synchronous_standby_names with '*'
Date
Msg-id CA+U5nMJJBCC=+NBjKpUCLVs6ZKzt0OQe46=qEo3M701y-fhdvQ@mail.gmail.com
Whole thread Raw
In response to Re: synchronous_standby_names with '*'  (alexondi <alexondi@rambler.ru>)
List pgsql-general
Tree view 
On Fri, Aug 19, 2011 at 12:04 PM, alexondi <alexondi@rambler.ru> wrote:

> but if I don't have any slave at this time why my command hang?

Setting synchronous_standby_names means "wait until my standby replies".

If you don't have a standby, then you just made a request to wait for
a long time.

Suggest different approach.


--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-general by date:

Previous
From: DM
Date:
Subject: MySQL -> PostgreSQL conversion issue
Next
From: c k
Date:
Subject: Re: Syncing Data to Production DB Server