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

From Andreas Kretschmer
Subject Re: Streaming replication failover process - Pgsql 9.2
Date
Msg-id 5782C13D.3030105@a-kretschmer.de
Whole thread Raw
In response to Streaming replication failover process - Pgsql 9.2  (Patrick B <patrickbakerbr@gmail.com>)
Responses Re: Streaming replication failover process - Pgsql 9.2
List pgsql-general

Am 10.07.2016 um 23:19 schrieb Patrick B:
> Hi all,
>
> There will be a network maintenance at the company where my servers are...
>
> I've got one master and one slave server, running PostgreSQL 9.2.
>
> As the network will be down, the internet won't be working as well as
> the intranet. Both servers won't be able to communicate each other.
> Not by streaming replication and wal_files too.
>
> That should take at most 10 minutes.
>
> 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.




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Streaming replication failover process - Pgsql 9.2
Next
From: John R Pierce
Date:
Subject: Re: Streaming replication failover process - Pgsql 9.2