Re: [BACKUPS]Little backups - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: [BACKUPS]Little backups
Date
Msg-id 48848FFD.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to [BACKUPS]Little backups  ("Leví Teodoro da Silva" <tlevisilva@gmail.com>)
List pgsql-performance
>>> "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

pgsql-performance by date:

Previous
From: "Leví Teodoro da Silva"
Date:
Subject: [BACKUPS]Little backups
Next
From: Albert Cervera Areny
Date:
Subject: Re: [BACKUPS]Little backups