From: David Bear <David.Bear@asu.edu>
To: pgsql-admin@postgresql.org
Subject: incrementals with pg-dump
Date: Wed, 1 Aug 2007 22:11:01 -0700
Message-ID: <20070802051101.GL7979@asu.edu> (raw)
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?
--
David Bear
phone: 602-496-0424
fax: 602-496-0955
College of Public Programs/ASU
University Center Rm 622
411 N Central
Phoenix, AZ 85007-0685
"Beware the IP portfolio, everyone will be suspect of trespassing"
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: David.Bear@asu.edu
Subject: Re: incrementals with pg-dump
In-Reply-To: <20070802051101.GL7979@asu.edu>
* 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