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