Re: synchronous_standby_names with '*'

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: alexondi <alexondi(at)rambler(dot)ru>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: synchronous_standby_names with '*'
Date: 2011-08-19 11:44:41
Message-ID: CA+U5nMJJBCC=+NBjKpUCLVs6ZKzt0OQe46=qEo3M701y-fhdvQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 19, 2011 at 12:04 PM, alexondi <alexondi(at)rambler(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fujii Masao 2011-08-19 11:48:13 Re: synchronous_standby_names with '*'
Previous Message alexondi 2011-08-19 11:39:02 Re: synchronous_standby_names with '*'