On 08/12/2016 11:33, Subhankar Chattopadhyay wrote:
Hi, Few days back I had asked if it is needed to to pg_basebackup for every database update. From John I understood that it is unnecessary and if the slave is syncing, even if it is catching up, it would be able to sync without doing pg_basebackup. This is working also for me. However, for a failover scenario, where a master goes down, and I make the slave as master, and then when the old master comes back as a slave again, if I don't take pg_basebackup from the new master, it cannot follow the new master. This is kind of an overhead. Is there a way I can make the old master follow the new master without having to do full backup?
pg_rewind
Subhankar Chattopadhyay Bangalore, India
-- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general