On Tue, Jun 6, 2017 at 12:03 PM, Bhattacharyya, Subhro <s.bhattacharyya@xxxxxxx> 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 > 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? When pg_rewind runs it looks at the WAL from the last checkpoint before WAL diverged on the *target* node, not the source. So retaining the WAL data on the primary after the standby has been promoted makes little sense from this point of view. Even worse, once the promoted standby decides to recycle the past WAL segments you won't be able to do a rewind of the previous primary because there is no way to know what are the blocks modified on the standby since the point of divergence. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
