Search Postgresql Archives

Re: warm standby - apply wal archives

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Syncing just WAL archive directory every minute should not be a problem at all (running rsync every minute for a data directory is not recommended).

As said earlier, we had configured warm standby for a db of size 2 TB and wal archive generation was in 100s.

We did not encounter any issues in running an rsync job with a frequency of even less than a minute. We made sure that 
rsync job is running on standby server (we were pulling the wal archives to standby).

1. compress the wal archives
2. rsync on standby site
3. uncompress on standby site

Thanks
Venkat

On Sat, Sep 17, 2011 at 6:06 PM, MirrorX <mirrorx@xxxxxxxxx> wrote:
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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux