identify modified objects for incremental backup

Hi, when doing database backups using with vertica 6.1.2, how does vertica identify which objects have been modified to do an incremental backup? thanks, Pietro


  • Hi! Vertica sores data in special structure that Vertica calls - containers. Containers can be created or deleted and never re-written. Each container has it own OID. If some file for OID missing in it location - means objects have been modified. Other way to find all modified objects: to check hard links in Snapshot. If some hard link exists in the Snapshot directory, that has only one reference - means that this container have been modified. select * from storage_containers;
  • thanks Daniel! very helpful! P.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file