Skip site navigation (1) Skip section navigation (2)

Re: Incremental Backup

From: Mladen Gogala <mgogala(at)vmsinfo(dot)com>
To: Majid Azimi <majid(dot)merkava(at)gmail(dot)com>
Cc: PostgreSQL - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Incremental Backup
Date: 2010-10-04 22:25:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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 
The Leader in Integrated Media Intelligence Solutions

In response to


pgsql-novice by date

Next:From: Mladen GogalaDate: 2010-10-04 22:40:38
Subject: Re: Excellent job!
Previous:From: Majid AzimiDate: 2010-10-04 21:33:08
Subject: Incremental Backup

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group