Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 679E265018D for ; Mon, 21 Jul 2008 15:38:52 -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 90308-05 for ; Mon, 21 Jul 2008 15:38:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.186]) by postgresql.org (Postfix) with ESMTP id 6B00D650182 for ; Mon, 21 Jul 2008 15:38:48 -0300 (ADT) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrelayeu5) with ESMTP (Nemesis) id 0ML25U-1KL0HU0b1d-0000l3; Mon, 21 Jul 2008 20:38:45 +0200 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1KL0HT-0004yl-00 for pgsql-performance@postgresql.org; Mon, 21 Jul 2008 20:38:43 +0200 Date: Mon, 21 Jul 2008 20:38:43 +0200 From: "A. Kretschmer" To: pgsql-performance@postgresql.org Subject: Re: [BACKUPS]Little backups Message-ID: <20080721183843.GA19118@a-kretschmer.de> References: <4a74ba520807211120u46fd23f2lc72059ad94c04324@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <4a74ba520807211120u46fd23f2lc72059ad94c04324@mail.gmail.com> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX1/zimksUW+y8md+kglP8VDGCTXKD5jD3twlu/C M5ImkSkDRt1rbkw6KoKgJh8TaAUQcScjTJRWvSE0x/bWKrBupF +eghlSBL7GnJ3atDkQDcvPPpfVnuBDV 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/190 X-Sequence-Number: 30790 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 -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net