Re: Streaming replication failover process - Pgsql 9.2

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Streaming replication failover process - Pgsql 9.2
Date: 2016-07-10 21:42:21
Message-ID: 5782C13D.3030105@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2016-07-10 22:05:19 Re: Streaming replication failover process - Pgsql 9.2
Previous Message Adrian Klaver 2016-07-10 21:31:42 Re: Streaming replication failover process - Pgsql 9.2