On Fri, Jul 26, 2013 at 3:00 PM, Samrat Revagade <revagade.sam...@gmail.com>wrote:
> > secondary without having to rsync the data as it can take up to 10 hours. > > pg_rewind (https://github.com/vmware/pg_rewind) is what you need. > > But I think it has a problem regarding the hint bits which Robert Hass > pointed out. > You can still solve hint bit problem by enabling new checksum feature, But > you have to face consequences such as performance overhead. > > You can find the discussion about that on following link: > > http://www.postgresql.org/message-id/flat/ca+tgmoy4j+p7jy69ry8gposmmdznyqu6dtionprcxavg+sp...@mail.gmail.com#ca+tgmoy4j+p7jy69ry8gposmmdznyqu6dtionprcxavg+sp...@mail.gmail.com > Exactly, using checksums is mandatory or you could finish with corrupted data after rewinding a data directory. Any help in testing or proposing patches for pg_rewind is welcome. It is still in early development. Thanks, -- Michael