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: 4CAA546B.7080005@vmsinfo.com (view raw or flat)
Thread:
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
http://www.vmsinfo.com 
The Leader in Integrated Media Intelligence Solutions




In response to

Responses

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-2014 The PostgreSQL Global Development Group