with Oracle we use "backup archivelog all delete all input". this is a kind of atomic transaction. everything backuped for sure is deleted. with Postgres we archive to a local host directory we do a Networker backup of this directory afterwards and delete the archived logs but this is not an atomic transaction so there is a small risk that something gets deleted which is not backuped how to you prevent this? Is there any backup tool which can do backups analogous Oracle? |