Postgres Pro
Downloads
Home   >   mailing lists

Streaming-only cascading replica won't come up without writes on the master - Mailing list pgsql-hackers

From Josh Berkus
Subject Streaming-only cascading replica won't come up without writes on the master
Date
Msg-id 510B149A.6030906@agliodbs.com
Whole thread Raw
Responses Re: Streaming-only cascading replica won't come up without writes on the master
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Cascading replication: should we detect/prevent cycles?
Next
From: Andrew Dunstan
Date:
Subject: parameter info?