Re: [GENERAL] Speed up Switchover

2013-07-25 Thread Andres Freund
On 2013-07-25 22:00:23 -0700, Sergey Konoplev wrote: > On Thu, Jul 25, 2013 at 1:03 AM, TJ wrote: > > I am looking for a way of speeding up the process of switching over of > > severs. > > At the moment we are switching over via the trigger file, reconfiguring our > > applications, patching or upd

Re: [GENERAL] Speed up Switchover

2013-07-25 Thread Sergey Konoplev
On Thu, Jul 25, 2013 at 11:00 PM, Samrat Revagade 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. >

Re: [GENERAL] Speed up Switchover

2013-07-25 Thread Michael Paquier
On Fri, Jul 26, 2013 at 3:00 PM, Samrat Revagade 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. > Yo

Re: [GENERAL] Speed up Switchover

2013-07-25 Thread Samrat Revagade
> 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,

Re: [GENERAL] Speed up Switchover

2013-07-25 Thread Sergey Konoplev
On Thu, Jul 25, 2013 at 1:03 AM, TJ wrote: > I am looking for a way of speeding up the process of switching over of > severs. > At the moment we are switching over via the trigger file, reconfiguring our > applications, patching or updating the old primary and rsyncing the data > over to the old p

[GENERAL] Speed up Switchover

2013-07-25 Thread TJ
Hi guys, I am looking for a way of speeding up the process of switching over of severs. At the moment we are switching over via the trigger file, reconfiguring our applications, patching or updating the old primary and rsyncing the data over to the old primary. I was wondering if there was an