On Oct 22, 2012, at 6:57 AM, chinnaobi wrote:
> Hi Laurenz Albe,
>
> I have tested using cygwin rsync in windows 2008 R2, just after restart the
> server.
>
> for 10 GB it took nearly 5 minutes to sync,
> for 50 GB it took nearly 30 minutes, -- too long Though there were no big
> changes.
>
> My requirement is something less than 5 minutes. I am doing high
> availability. In my setup there is WAL archiving enabled as well.
>
> Is there any way I can speedup the configuring dead primary server to
> standby ??
If it's a planned switch, and not a crash, take a look at this thread:
http://archives.postgresql.org/pgsql-general/2012-08/msg00083.php
If it's a crash, then the only way to bring your crashed node back up as a slave to your new master is with another
fullcopy from that master node.