pg_rewind cannot be used as I am on 9.4. Anything else? On Thu, Dec 8, 2016 at 3:23 PM, Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> wrote: > 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 -- Subhankar Chattopadhyay Bangalore, India -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general