On Sun, 2005-12-25 at 14:02 +0100, Gregor Zeitlinger wrote: > as far as I have understood, the WAL backup that you control via > "archive_command" is the PostgreSQL equivalent to what other databases > let you do with an incremental backup
No it is not an incremental backup of changed data blocks, it is a transactional log archival. So, other parts of your thinking are slightly off - but not by much. The only way to do a partial recovery is to follow the PITR notes. Best Regards, Simon Riggs ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match