Re: Incremental Backup

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
>