Re: Streaming replication failover process - Pgsql 9.2 - Mailing list pgsql-general

From John R Pierce
Subject Re: Streaming replication failover process - Pgsql 9.2
Date
Msg-id bd28ead3-6f46-69a3-1857-bd069b8e6d6e@hogranch.com
Whole thread Raw
In response to Re: Streaming replication failover process - Pgsql 9.2  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: Streaming replication failover process - Pgsql 9.2
List pgsql-general
On 7/10/2016 2:42 PM, Andreas Kretschmer wrote:
1. When the connection comes back, will the master and slave work as expected? The streaming replication should be ok?
if the master holds all needed WAL's there should be no problem.

You can ensure that with wal_keep_segments, or, in newer version, via replication slots.

or via an external WAL archive, that the master writes, and the slave has access to.

-- 
john r pierce, recycling bits in santa cruz

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Streaming replication failover process - Pgsql 9.2
Next
From: Patrick B
Date:
Subject: Re: Streaming replication failover process - Pgsql 9.2