Re: Incremental Backup

Поиск
Список
Период
Сортировка
От Craig Barnes
Тема Re: Incremental Backup
Дата
Msg-id AANLkTik3W=29PeguaHfBcato4SHVena65KoY=95tSthZ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Incremental Backup  (Mladen Gogala <mgogala@vmsinfo.com>)
Ответы Re: Incremental Backup
Список pgsql-novice
Дерево обсуждения
Hi,

Wouldn’t incremental backup be achieved by archiving the WAL files?

http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html

Regards

Craig

On 4 October 2010 23:25, Mladen Gogala <mgogala@vmsinfo.com> wrote:
Majid Azimi wrote:
 Hi guys.

How can we perform incremental backups after a full backup?

 
Incremental backup doesn't make sense in this case, because incremental backup will backup all the files that have changed since the last incremental backup of different order. In particular, that means that all tables that are being constantly used will be in both backups. PostgreSQL has no block change tracking so you can not only backup database blocks that have changed since the last backup.

--

Mladen Gogala Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com The Leader in Integrated Media Intelligence Solutions





--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

В списке pgsql-novice по дате отправления: