Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 39E6664FCD8 for ; Mon, 21 Jul 2008 16:03:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 12033-08 for ; Mon, 21 Jul 2008 16:03:03 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.29]) by postgresql.org (Postfix) with ESMTP id EC1466500F2 for ; Mon, 21 Jul 2008 16:03:04 -0300 (ADT) Received: by yx-out-2324.google.com with SMTP id 8so244774yxb.73 for ; Mon, 21 Jul 2008 12:03:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=vXQpt5PLEqm0YGN8/xyzQgracR9HpP9Hz2RWcEgdlbk=; b=etQIgn3bn/Gi1JfE82jO+vCuBEBF3TxEXbhTTaBF1QWfnblcxUC7aGebOFeJ/m8QmE GKZIWVy2yBs/kal2ft6fQ92RngdzUkHiLc2ouSkPhQwniSt//wqDeUvPqH7/R46YW6i9 9At7OvcBIZIf25I7Vg6/lVJWsAo8/gEDUBXSk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; b=ahAWEAek0T7AMdUmj+cs9r9Wqc+qVO0VCX8MhKcTUSuWdE8SGssX9QgFRMCZidbCpO XuldLckua15xCmJQjFZoRelF92MUAH0B+bQA2m0yd6lHHUDu7DDZ9WnuwYWgAWi3oGY5 W9IbI3OiuoWKmHj0vtD2RrQM/96LePzR5gUt0= Received: by 10.151.114.6 with SMTP id r6mr4225665ybm.181.1216666983010; Mon, 21 Jul 2008 12:03:03 -0700 (PDT) Received: from ?192.168.0.52? ( [200.145.37.64]) by mx.google.com with ESMTPS id 8sm7979932ywg.6.2008.07.21.12.03.00 (version=TLSv1/SSLv3 cipher=RC4-MD5); Mon, 21 Jul 2008 12:03:02 -0700 (PDT) Message-ID: <4884DCF0.9090102@gmail.com> Date: Mon, 21 Jul 2008 16:01:04 -0300 From: Levi User-Agent: Thunderbird 2.0.0.12 (X11/20080310) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: [BACKUPS]Little backups References: <4a74ba520807211120u46fd23f2lc72059ad94c04324@mail.gmail.com> <20080721183843.GA19118@a-kretschmer.de> In-Reply-To: <20080721183843.GA19118@a-kretschmer.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/194 X-Sequence-Number: 30794 Thank you guys for the fast answer. This same guy asked me about the support on PostgreSQL. When he see the community behind PostgreSQL , he never will be worried about support. =) Thanks a lot, Leví A. Kretschmer escreveu: > am Mon, dem 21.07.2008, um 15:20:27 -0300 mailte Leví Teodoro da Silva folgendes: > >> - In oracle he makes a full backup two times in a day. In this range of time, >> Oracle make a lot of mini-backups, but this backups is about just the data >> whose have changed in this time. If the system fails, he could reconstruct the >> database adding the last "big backup" with "mini-backups". Can Postgres do this >> ? >> > > Sure, with the WAL-files. > > http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html > > > Andreas >