Considering the size of WAL archives = 200GB Compressing them using gzip (you can use this command in a shell script and place it in archive_command as well) would possibly reduce the size to as low as 10 - 20 GB.
Please let us know the results. Thanks Venkat On Tue, Sep 6, 2011 at 1:03 PM, MirrorX <mirr...@gmail.com> wrote: > The network bandwidth between the servers is definitely not an issue. What > is > bothering me is the big size of the wal archives, which goes up to 200GB > per > day and if the standby server will be able to replay all these files. The > argument that; since the master can do it and also do various other tasks > at > the same time, and since the secondary is identical to the first, so he > should be able to do that seems valid, so i will give it a try and let you > know about the results. In the meantime if there are any other > ideas/suggestions etc please let me know. thx to all > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/warm-standby-apply-wal-archives-tp4770567p4773498.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
