From: Mark Steben <msteben@autorevenue.com>
To: pgsql-admin@postgresql.org
Subject: pg_xlog volume question
Date: Fri, 6 Feb 2009 12:52:56 -0500
Message-ID: <CE75C28AC2DF4C6B996F1F4B460B7E15@dei26g028534> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: msteben@autorevenue.com
Subject: Re: pg_xlog volume question
In-Reply-To: <CE75C28AC2DF4C6B996F1F4B460B7E15@dei26g028534>
References: <CE75C28AC2DF4C6B996F1F4B460B7E15@dei26g028534>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox