Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 7ECE09FB6D3 for ; Mon, 12 Feb 2007 23:06:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 05236-04 for ; Mon, 12 Feb 2007 23:06:47 -0400 (AST) X-Greylist: delayed 00:09:51.297341 by SQLgrey-1.7.4 Received: from ironport.cable.net.co (ironport.cable.net.co [200.118.2.77]) by postgresql.org (Postfix) with ESMTP id 879749FB6CC for ; Mon, 12 Feb 2007 23:06:47 -0400 (AST) Received: from epicac.cable.net.co ([200.118.2.50]) by ironport.cable.net.co with ESMTP; 12 Feb 2007 21:56:54 -0500 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: ApkZANG30EXIdgIyh2dsb2JhbACDY4pzAQgOKpJPAQEB X-IronPort-AV: i="4.14,161,1170651600"; d="scan'208"; a="325039585:sNHT24850742" Received: from dynamic-ip-cr20011869155.cable.net.co ([200.118.69.155]) by epicac.cable.net.co (Sun Java System Messaging Server 6.2-7.06 (built Oct 6 2006)) with ESMTPA id <0JDD00CC2013DLF0@epicac.cable.net.co> for pgsql-admin@postgresql.org; Mon, 12 Feb 2007 21:48:39 +0500 (GMT) Date: Mon, 12 Feb 2007 21:56:40 -0500 From: "Eduardo J. Ortega" Subject: Re: WAL files backup In-reply-to: <52163.31474.qm@web55414.mail.re4.yahoo.com> To: pgsql-admin@postgresql.org Message-id: <200702122156.43178.ejortegau@cable.net.co> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7BIT Content-disposition: inline References: <52163.31474.qm@web55414.mail.re4.yahoo.com> User-Agent: KMail/1.9.5 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.99 tagged_above=0 required=5 tests=AWL, BAYES_50, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, INVALID_TZ_GMT X-Spam-Level: ** X-Archive-Number: 200702/171 X-Sequence-Number: 24636 For what i understand, the WAL files only record changes to the database, so each WAL segment is absolutely different from the previous one. As a matter of fact, each WAL file is the incremental backup you want to make (provided you have already taken a base or level 0 backup). On Monday 12 February 2007 13:42, pedro noticioso wrote: > hi there > > I lightly read this > http://www.postgresql.org/docs/8.1/static/backup-online.html > > and am interested in creating an incremental backup of > WAL files, but my database is small so each of this > WAL files must be almost identical to the previous > one. > > Is there a way to incrementally backup so that it > takes less space? > > thanks! > > > > ___________________________________________________________________________ >_________ Finding fabulous fares is fun. > Let Yahoo! FareChase search your favorite travel sites to find flight and > hotel bargains. http://farechase.yahoo.com/promo-generic-14795097 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly -- Eduardo J. Ortega - Linux user #222873 "No fake - I'm a big fan of konqueror, and I use it for everything." -- Linus Torvalds