pgsql pitr

PITR example

Point In Time Recovery provides a possibility to use plain file-level commands ( cp, for example) to make online backup of full postgresql cluster (sorry, not per db backup) and be able to restore cluster to specified moment of time. Of course, instead of cp command one can use tar with ssh to backup cluster's files to another machine. Simon Riggs proposal for PITR

Quick and dirty illustration how PITR is working