Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 2194C9FA30C for ; Fri, 3 Aug 2007 21:11:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 74849-02 for ; Fri, 3 Aug 2007 21:11:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 01B379FB368 for ; Fri, 3 Aug 2007 21:11:41 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 8A7BC56453; Fri, 3 Aug 2007 19:11:40 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Fri, 3 Aug 2007 19:11:39 -0500 Date: Fri, 3 Aug 2007 19:11:38 -0500 From: Decibel! To: David Bear Cc: pgsql-admin@postgresql.org Subject: Re: incrementals with pg-dump Message-ID: <20070804001138.GA25704@nasby.net> References: <20070802051101.GL7979@asu.edu> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="8a48p4KKsB+A/3VY" Content-Disposition: inline In-Reply-To: <20070802051101.GL7979@asu.edu> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070804:david.bear@asu.edu::UzzLA87g3DSI2yne:0000000000000000000 0000000000000000000000001B74 X-Hashcash: 1:20:070804:pgsql-admin@postgresql.org::4Gw71IWxrK9TwKU8:00000000000 0000000000000000000000001g40 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/25 X-Sequence-Number: 26356 --8a48p4KKsB+A/3VY Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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.=20 >=20 > I did find a backup method using the WAL files on the file system at=20 >=20 > http://www.oreillynet.com/pub/a/databases/2006/07/13/lamp-data-protection= =2Ehtml?page=3Dlast >=20 > I also found this: >=20 > http://www.postgresql.org/docs/8.1/static/backup-online.html >=20 > I seem to remember around pg 7.x that file system level backups were > very bad. >=20 > 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. >=20 > 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. --=20 Decibel!, aka Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) --8a48p4KKsB+A/3VY Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFGs8Q6dO30qud8SkgRAjLzAKDLpiTT8cWLEmPVsru18S2C0PiZVQCfceWe C4blPg4PAzTBHeX4FcZK3pc= =YxSS -----END PGP SIGNATURE----- --8a48p4KKsB+A/3VY--