just another update since the system is up and running and one more question :p the secondary server is able to restore the wal archives practically immediately after they arrive. i have set a rsync cron job to send the new wals every 5 minutes. the procedure to transfer the files and to restore them takes about 30 seconds (the number of archives is about 20-30). i ve tried to set it to 2 minutes, and then the procedure takes about 20 seconds (both transfer and restoration) while i didnt notice any impact on the primary server (the procedure is initiated on the secondary server). what is your opinion about the time interval that the cron job should run? i ve read many articles online indicating that rsync should not run every 1 minute, but in my case isn't it different since it just syncs two folder containing only wals and not the whole disks? plus both folders on the servers are in different partitions. thx in advance for your insight -- View this message in context: http://postgresql.1045698.n5.nabble.com/warm-standby-apply-wal-archives-tp4770567p4813659.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
