Re: pg_basebackup blocking all queries with horrible performance - Mailing list pgsql-admin

From Magnus Hagander
Subject Re: pg_basebackup blocking all queries with horrible performance
Date
Msg-id CABUevEwYxpqA0EJ4pdcpLY6QZuK4DbmoRy_PC+NDCWKvCXwwkw@mail.gmail.com
Whole thread Raw
In response to Re: pg_basebackup blocking all queries with horrible performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_basebackup blocking all queries with horrible performance  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-admin
On Sat, Jun 9, 2012 at 2:51 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Fujii Masao <masao.fujii@gmail.com> writes:
>> This seems a bug. I think we should prevent pg_basebackup from
>> becoming synchronous standby. Thought?
>
> Absolutely.  If we have replication clients that are not actually
> capable of being standbys, there *must* be a way for the master
> to know that.

I thought we fixed this already by sending InvalidXlogRecPtr as flush
location? And that this only applied in 9.2?

Are you saying we picked pg_basebackup *in backup mode* (not log
streaming) as synchronous standby? If so then yes, that is
*definitely* a bug that should be fixed. We should never select a
connection that's not even streaming log as standby!

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

pgsql-admin by date:

Previous
From: truongxuan quang
Date:
Subject: ...
Next
From: Fujii Masao
Date:
Subject: Re: pg_basebackup blocking all queries with horrible performance