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