Re: Speed up Switchover - Mailing list pgsql-general

From Samrat Revagade
Subject Re: Speed up Switchover
Date
Msg-id 1374818410945-5765235.post@n5.nabble.com
Whole thread Raw
In response to Re: Speed up Switchover  (Sergey Konoplev <gray.ru@gmail.com>)
Responses Re: Speed up Switchover
Re: Speed up Switchover
List pgsql-general
> 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+SPByg@mail.gmail.com#CA+TgmoY4j+p7JY69ry8GpOSMMdZNYqU6dtiONPrcxaVG+SPByg@mail.gmail.com





-----
Greetings,
Samrat Revagade,
NTT-DATA-OSS Center (Pune)
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Speed-up-Switchover-tp5765160p5765235.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Amit Langote
Date:
Subject: Re: Fastest Index/Algorithm to find similar sentences
Next
From: Michael Paquier
Date:
Subject: Re: Speed up Switchover