Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 9FC749FA5CE for ; Thu, 2 Aug 2007 02:23:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 26026-08 for ; Thu, 2 Aug 2007 02:23:29 -0300 (ADT) X-Greylist: delayed 00:12:24.79318 by SQLgrey-1.7.5 Received: from epo-int1.asu.edu (epo-int1.asu.edu [129.219.187.20]) by postgresql.org (Postfix) with ESMTP id B4E319FA4C5 for ; Thu, 2 Aug 2007 02:23:28 -0300 (ADT) Received: from teancum.pp.asu.edu (teancum.pp.asu.edu [129.219.198.16]) by epo-int1.asu.edu (Switch-3.1.8/Switch-3.1.7/asu-postoffice-prod) with ESMTP id l725B0vH024068 for ; Wed, 1 Aug 2007 22:11:00 -0700 Received: by teancum.pp.asu.edu (Postfix, from userid 1000) id 3998A1023; Wed, 1 Aug 2007 22:11:01 -0700 (MST) Date: Wed, 1 Aug 2007 22:11:01 -0700 From: David Bear To: pgsql-admin@postgresql.org Subject: incrementals with pg-dump Message-ID: <20070802051101.GL7979@asu.edu> Reply-To: David.Bear@asu.edu Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/15 X-Sequence-Number: 26346 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"