From: | "Mark Steben" <msteben(at)autorevenue(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | pg_xlog volume question |
Date: | 2009-02-06 17:52:56 |
Message-ID: | CE75C28AC2DF4C6B996F1F4B460B7E15@dei26g028534 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello listers,
I'm designing a PITR backup / recovery scenario where I'm log-shipping to
another location and recovering using a tar backup and log roll forward.
The plan is to save a week's worth of logs and restore nightly using the
accumulated logs to that point. A daily full backup is too
expensive and time consuming - it takes over 36 hours to transport it over
the network to the recovery site. So we're going with the weekly backup and
saving the weeks worth of logs.
As you well know, I will require a LOT of storage for the xlogs. I'm
currently creating about 2GB of logs every hour. Is there a config
parameter to reduce the amount that Xlog takes up? At this rate I'm looking
at close to 400GB to restore the database at the end of the week.
Any help appreciated.
Mark Steben│Database Administrator│
@utoRevenue-R- "Join the Revenue-tion"
95 Ashley Ave. West Springfield, MA., 01089
413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax)
@utoRevenue is a registered trademark and a division of Dominion Enterprises
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2009-02-06 18:12:43 | Re: pg_xlog volume question |
Previous Message | Carol Walter | 2009-02-06 14:12:12 | Re: Failed sanity check? |