I have several postgres database clusters which i backup regularly using pg_dump. This currently is working just fine, as i haven't needed to restore a database after a catastrophic failure, but it is not ideal, as i can only restore the database up to the point at which I took the backup.
I have looked into pg-rman (http://code.google.com/p/pg-rman/
) which looks promising, but i was wondering what others have used which would allow me to restore a database, and then apply WAL logs to recover as much data as possible.
Any suggestions are much appreciated, thanks in advance.