Replication slot and pg_rewind

From: "Bhattacharyya, Subhro" <s(dot)bhattacharyya(at)sap(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Replication slot and pg_rewind
Date: 2017-06-06 03:03:05
Message-ID: 8e99c8e12a7a4d638b1d6e305bf8de9e@sap.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We are using the replication slot and pg_rewind feature of postgresql 9.6

Our cluster consists of 1 master and 1 slave node.

The replication slot feature allows the master to keep as much WAL as is required by the slave.

The pg_rewind command uses WALs to bring the slave in sync with the master.
By using replication slots there are always enough WAL in the pg_xlog.

In this case is it safe to use pg_rewind without WAL archiving?
Can there be a situation where pg_rewind fails?

Regards, Subhro

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2017-06-06 03:19:35 Re: Replication slot and pg_rewind
Previous Message Adrian Klaver 2017-06-06 02:41:44 Re: Help with restoring a dump in Tar format? (dependencies/ordering)