From: Decibel! <decibel@decibel.org>
To: David Bear <David.Bear@asu.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: incrementals with pg-dump
Date: Fri, 3 Aug 2007 19:11:38 -0500
Message-ID: <20070804001138.GA25704@nasby.net> (raw)
In-Reply-To: <20070802051101.GL7979@asu.edu>
References: <20070802051101.GL7979@asu.edu>
On Wed, Aug 01, 2007 at 10:11:01PM -0700, David Bear wrote:
> I googled a bit for an incremental or differential way to backup
> postgresq. I was hoping there would be switch on pg-dumpall that would
> backup all tupples added since some date. Doesn't look like it exists.
>
> I did find a backup method using the WAL files on the file system at
>
> http://www.oreillynet.com/pub/a/databases/2006/07/13/lamp-data-protection.html?page=last
>
> I also found this:
>
> http://www.postgresql.org/docs/8.1/static/backup-online.html
>
> I seem to remember around pg 7.x that file system level backups were
> very bad.
>
> Now, it seems the pg 8.x way is to allow the admin to take advantage
> of file system tools look tar, cpio, dump, etc.
>
> I was wondering if there any other recommendations beyond what is
> mentioned in the docs above?
No... if you want incremental backups, use PITR. Someone's done some
work on an incremental version of pg_dump, but I haven't heard anything
about it in about a year.
--
Decibel!, aka Jim Nasby decibel@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
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-admin@postgresql.org
Cc: decibel@decibel.org, David.Bear@asu.edu
Subject: Re: incrementals with pg-dump
In-Reply-To: <20070804001138.GA25704@nasby.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