Обсуждение: [BACKUPS]Little backups

>>> "Leví Teodoro da Silva" <tlevisilva@gmail.com> 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

A Dilluns 21 Juliol 2008, Leví 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. =)
> 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 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 ?  *

Yes, it can. If you need detailed information, you can take a look at
http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html

>
>
>
>
> Regards,
> Leví - Brazil

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

On Mon, Jul 21, 2008 at 03:20:27PM -0300, 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 ?  *

Take a look at Point-In-Time-Recovery, PITR:
http://www.postgresql.org/docs/current/static/continuous-archiving.html

-Berge

--
Berge Schwebs Bjørlo
Alegría!

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
>