Cascading replica waits for write on master to come up

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Cascading replica waits for write on master to come up
Date: 2013-02-01 23:17:45
Message-ID: 510C4D19.6040506@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

(sending this again; it was eaten by the ethernet)

Heikki,

I thought this was only a 9.3 issue, but it turns out to be
reproduceable on 9.2.2. Basically, I did:

1. master is queicent ... no writes occuring.
2. createded cascading replica (reprep1) from replica (repmaster)
3. reprep1 remains "in recovery mode" until a write occurs on master

I've been able to reproduce this several times on my laptop using
postmasters running on different ports.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2013-02-01 23:40:00 issues with range types, btree_gist and constraints
Previous Message Jeff Janes 2013-02-01 23:09:34 Re: autovacuum not prioritising for-wraparound tables