pg_xlog volume question

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


Responses

Browse pgsql-admin by date

  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?