pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
 
 
 




view thread (5+ messages)  latest in thread

Message-ID: <CE75C28AC2DF4C6B996F1F4B460B7E15@dei26g028534>
Permalink:  ../CE75C28AC2DF4C6B996F1F4B460B7E15@dei26g028534/
Also on:    postgresql.org/message-id/CE75C28AC2DF4C6B996F1F4B460B7E15@dei26g028534

 · 

reply

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