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 full copy from that master node. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
