Re: [GENERAL] Replication slot and pg_rewind

2017-06-05 Thread Michael Paquier
On Tue, Jun 6, 2017 at 1:52 PM, Bhattacharyya, Subhro wrote: > Our expectation is that slave will be able to sync with the new master with > the help of whatever WALs are present in the new master due to replication > slots. > Can pg_rewind still work without WAL

Re: [GENERAL] Replication slot and pg_rewind

2017-06-05 Thread Bhattacharyya, Subhro
har...@sap.com> Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Replication slot and pg_rewind On Tue, Jun 6, 2017 at 12:03 PM, Bhattacharyya, Subhro <s.bhattachar...@sap.com> wrote: > We are using the replication slot and pg_rewind feature of postgresql 9.6 > Our cluster co

Re: [GENERAL] Replication slot and pg_rewind

2017-06-05 Thread Michael Paquier
On Tue, Jun 6, 2017 at 12:03 PM, Bhattacharyya, Subhro wrote: > 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 >

[GENERAL] Replication slot and pg_rewind

2017-06-05 Thread Bhattacharyya, Subhro
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