Re: [BACKUPS]Little backups

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: [BACKUPS]Little backups
Дата
Msg-id 48848FFD.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на [BACKUPS]Little backups  ("Leví Teodoro da Silva" <tlevisilva@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Leví Teodoro da Silva"
Дата:
Сообщение: [BACKUPS]Little backups
Следующее
От: Albert Cervera Areny
Дата:
Сообщение: Re: [BACKUPS]Little backups