From: Matthew T. O'Connor <matthew@zeut.net>
To: Miguel Arroz <arroz@guiamac.com>
Cc: Steve Poe <steve.poe@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Planning hot/live backups?
Date: Tue, 25 Mar 2008 00:50:41 -0400
Message-ID: <47E884A1.3010407@zeut.net> (raw)
In-Reply-To: <570D4201-082A-4586-A0F8-4345C2B5E53F@guiamac.com>
References: <721b21dc0803241323u73443060w3a1912d52714549b@mail.gmail.com>
<47E8128E.1060600@zeut.net>
<721b21dc0803241356h78257168vba3f61d8eb92a152@mail.gmail.com>
<47E82B0B.7090807@zeut.net>
<570D4201-082A-4586-A0F8-4345C2B5E53F@guiamac.com>
Miguel Arroz wrote:
> Going a bit off topic, but one quick question: to avoid storing GB of
> WAL files that will probably take a lot of time to reload, how can the
> backup be "reset"? I suspect that it's something like stopping the WAL
> archiving, doing a new base backup, and restart archiving, but I've
> never done it (have been using SQL dumps), so...
Basically, you only need WAL logs from the last time you made a back-up
of your data directory. We do nightly re-rsync of our data directory
and then purge old WAL files that are no longer needed.
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: matthew@zeut.net, arroz@guiamac.com, steve.poe@gmail.com
Subject: Re: Planning hot/live backups?
In-Reply-To: <47E884A1.3010407@zeut.net>
* 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