On 12/8/2015 4:55 PM, FattahRozzaq wrote:
...I want to limit the total size use by WAL archive to around 200-400 GB...?
for what purpose are you keeping a wal archive ?
if its for PITR (point in time recovery), you need ALL WAL records since
the start of a base backup up to the point in time at which you wish to
recover.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general