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

view thread (2+ messages)

Message-ID: <20070804001138.GA25704@nasby.net>
Permalink:  ../20070804001138.GA25704@nasby.net/
Also on:    postgresql.org/message-id/20070804001138.GA25704@nasby.net

 · 

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 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