Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6454264FCE1 for ; Mon, 21 Jul 2008 15:31:25 -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 84672-05 for ; Mon, 21 Jul 2008 15:31:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 34CB164FCD8 for ; Mon, 21 Jul 2008 15:31:21 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Mon, 21 Jul 2008 13:30:55 -0500 Message-Id: <48848FFD.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.3 Date: Mon, 21 Jul 2008 13:30:44 -0500 From: "Kevin Grittner" To: "=?ISO-8859-15?Q?Lev=ED=20Teodoro=20da=20Silva?=" , Subject: Re: [BACKUPS]Little backups References: <4a74ba520807211120u46fd23f2lc72059ad94c04324@mail.gmail.com> In-Reply-To: <4a74ba520807211120u46fd23f2lc72059ad94c04324@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 8bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/188 X-Sequence-Number: 30788 >>> "Leví Teodoro da Silva" wrote: > - 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 ? * The equivalent capability in PostgreSQL is the Point-In-Time Recovery backup strategy: http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html Twice daily seems rather extreme -- we generally go with monthly. -Kevin