Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E840164FD13 for ; Mon, 21 Jul 2008 15:37:39 -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 91005-01 for ; Mon, 21 Jul 2008 15:37:34 -0300 (ADT) X-Greylist: delayed 00:06:40.026996 by SQLgrey-1.7.6 Received: from correo12.acens.net (correo12.acens.net [217.116.0.112]) by postgresql.org (Postfix) with ESMTP id 482FE64FCE1 for ; Mon, 21 Jul 2008 15:37:34 -0300 (ADT) Received: (qmail 3567 invoked from network); 21 Jul 2008 18:30:52 -0000 Received: from unknown (HELO sardina) (albert.sedifa.com@[83.175.220.10]) (envelope-sender ) by correo12.acens.net (qmail-ldap-1.03) with SMTP for ; 21 Jul 2008 18:30:52 -0000 From: Albert Cervera Areny Organization: Sedifa, S.L. To: pgsql-performance@postgresql.org Subject: Re: [BACKUPS]Little backups Date: Mon, 21 Jul 2008 20:30:46 +0200 User-Agent: KMail/1.9.9 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: quoted-printable Content-Disposition: inline Message-Id: <200807212030.47493.albert@sedifa.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/189 X-Sequence-Number: 30789 A Dilluns 21 Juliol 2008, Lev=ED Teodoro da Silva va escriure: > Hi Guys, > > I am developing a project with PostgreSQL and one guy from project is > familiar with Oracle and did a question for me, but i could not answer, if > someone could help it will be good. =3D) > The question is : > * > - 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 t= he > 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 ? * Yes, it can. If you need detailed information, you can take a look at=20 http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html > > > > > Regards, > Lev=ED - Brazil =20