Skip site navigation (1) Skip section navigation (2)

pgsql: Prevent non-streaming replication connections from beingselecte

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Prevent non-streaming replication connections from beingselecte
Date: 2012-06-11 13:19:21
Message-ID: E1Se4Wf-0002nP-3f@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Prevent non-streaming replication connections from being selected sync slave

This prevents a pg_basebackup backup session that just does a base
backup (no xlog involved at all) from becoming the synchronous slave
and thus blocking all access while it runs.

Also fixes the problem when a higher priority slave shows up it would
become the sync standby before it has reached the STREAMING state, by
making sure we can only switch to a walsender that's actually STREAMING.

Fujii Masao

Branch
------
REL9_1_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/580b94168e2218a2a32d6792139d51c63104b2c2

Modified Files
--------------
src/backend/replication/syncrep.c |    1 +
1 files changed, 1 insertions(+), 0 deletions(-)

pgsql-committers by date

Next:From: Robert HaasDate: 2012-06-11 16:06:25
Subject: Re: Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers.
Previous:From: Magnus HaganderDate: 2012-06-11 13:01:08
Subject: pgsql: Revert behaviour of -x/--xlog to 9.1 semantics

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group