Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4F7179FB6AB for ; Tue, 13 Feb 2007 01:16:54 -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 24975-01 for ; Tue, 13 Feb 2007 01:16:42 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.234]) by postgresql.org (Postfix) with ESMTP id 97BB39FB692 for ; Tue, 13 Feb 2007 01:16:42 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 69so2188153wra for ; Mon, 12 Feb 2007 21:16:41 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=C8XEH5J9Pkxy7A8IAPm4lAsCzWhXRYKJtEFZHE3X2E3tuaYXH3Ow8rismjG+obTVSfiPkzJGqPcN3ZwwNDh2gmGHetRMqh9pLot6maUUJnk3Qmsv7zrYnL/Kr+oWiKAE8Y+RVbT6ECshgqxPe02NTnLPwvhK7E6q/prgbdCpet0= Received: by 10.115.93.16 with SMTP id v16mr6392958wal.1171343801443; Mon, 12 Feb 2007 21:16:41 -0800 (PST) Received: by 10.114.123.7 with HTTP; Mon, 12 Feb 2007 21:16:41 -0800 (PST) Message-ID: Date: Tue, 13 Feb 2007 10:16:41 +0500 From: "Shoaib Mir" To: "pedro noticioso" Subject: Re: WAL files backup Cc: pgsql-admin@postgresql.org In-Reply-To: <52163.31474.qm@web55414.mail.re4.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_56044_2375387.1171343801323" References: <8d0c260e71ef983bc8e497ce150c1d4b6afa7eb5@postgresql.org> <52163.31474.qm@web55414.mail.re4.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.07 tagged_above=0 required=5 tests=AWL, BAYES_50, HTML_30_40, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/172 X-Sequence-Number: 24637 ------=_Part_56044_2375387.1171343801323 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline What do you mean by indentical here? does it mean that they are same in size, if that is true then yes they should be same in size unless you specify archive_timeout (8.2 config parameter) setting to do a log switch after certain amount of time. -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 2/12/07, 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 > ------=_Part_56044_2375387.1171343801323 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline What do you mean by indentical here? does it mean that they are same in size, if that is true then yes they should be same in size unless you specify archive_timeout (8.2 config parameter) setting to do a log switch after certain amount of time.

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 2/12/07, pedro noticioso < cucnews@yahoo.com> 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

------=_Part_56044_2375387.1171343801323--