[GENERAL] Replication slot and pg_rewind - Mailing list pgsql-general

From Bhattacharyya, Subhro
Subject [GENERAL] Replication slot and pg_rewind
Date
Msg-id 8e99c8e12a7a4d638b1d6e305bf8de9e@sap.com
Whole thread Raw
Responses Re: [GENERAL] Replication slot and pg_rewind  (Michael Paquier <michael.paquier@gmail.com>)
List 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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Help with restoring a dump in Tar format?(dependencies/ordering)
Next
From: Michael Paquier
Date:
Subject: Re: [GENERAL] Replication slot and pg_rewind