Re: [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