Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4F4629FB870 for ; Wed, 14 Feb 2007 19:38:33 -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 07353-01 for ; Wed, 14 Feb 2007 19:38:29 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web55401.mail.re4.yahoo.com (web55401.mail.re4.yahoo.com [206.190.58.195]) by postgresql.org (Postfix) with SMTP id 3E0739FB86E for ; Wed, 14 Feb 2007 19:38:29 -0400 (AST) Received: (qmail 61038 invoked by uid 60001); 14 Feb 2007 23:38:27 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=vykEcygVpIRtv/fyYjul/QCtgSUFaHsbHHNuLl6Cs3LfWuGP2FHL97d3MO3uvpHP6n7URbXD54Z/Fw3w465mDz3E1b/evNas0/2xYfAzd2grWeAQKOVRxjky2iIyC+kaCOxIv9pceR8phuefbq6QLhEkbpzNk/0KWhBZrrF5cZA=; X-YMail-OSG: tglrgKgVM1kCEdrl4ggPX.rDT45ovkh.uPdM.AWNvx_spJJLViHkQXHUgTPRaQ1BZ2Jcd7giCJHlOnRwFMVCJ7h.eRFIbab2EM0GDGhVAGon1ENLYPc7Sa9wlVuckfoxb5zPQChWSSkDyV4- Received: from [200.53.62.220] by web55401.mail.re4.yahoo.com via HTTP; Wed, 14 Feb 2007 15:38:27 PST Date: Wed, 14 Feb 2007 15:38:27 -0800 (PST) From: pedro noticioso Subject: Re: WAL files backup To: pgsql-admin@postgresql.org In-Reply-To: <200702122156.43178.ejortegau@cable.net.co> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <863605.13890.qm@web55401.mail.re4.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.615 tagged_above=0 required=5 tests=BAYES_20, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: ** X-Archive-Number: 200702/210 X-Sequence-Number: 24675 Everyone please excuse the mistake in my previous question, there is a lot in my mind. We are already creating a complete backup every day, and would like to have WAL files to restore up to the last minute of course. Acording to http://www.postgresql.org/docs/8.1/static/runtime-config-wal.html#GUC-ARCHIVE-COMMAND http://www.postgresql.org/docs/8.1/static/backup-online.html#BACKUP-ARCHIVING-WAL I tried a couple of them and got an error messages stating that WAL archiving was not activated, so, how can I activate it? thanks these docs explain a lot but are not practical like the ones in howtoforge.com for example ;) In regards to my previous question, I did not check what I wrote, what I meant is that the 16*1024*1024 WAL file size is too big for us because we handle just a few KB per day of information, so are interested in a smaller WAL file size, perhaps 1024*1024 or even less so that we can backup the files in less media space, but in the postgresql@freenode.net IRC channel I was told that I would make the database work slower if I make a WAL file too small, what is your take on the matter? recomendation? etc? thanks a lot! --- "Eduardo J. Ortega" wrote: > 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 > > ---------------------------(end of > broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project > by donating at > > > http://www.postgresql.org/about/donate > ____________________________________________________________________________________ Looking for earth-friendly autos? Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center. http://autos.yahoo.com/green_center/