From: | Craig Barnes <cjbarnes18(at)gmail(dot)com> |
---|---|
To: | PostgreSQL - Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Incremental Backup |
Date: | 2010-10-04 22:49:21 |
Message-ID: | AANLkTik3W=29PeguaHfBcato4SHVena65KoY=95tSthZ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)vmsinfo(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mladen Gogala | 2010-10-04 23:11:18 | Re: Incremental Backup |
Previous Message | Mladen Gogala | 2010-10-04 22:43:04 | Re: Excellent job! |