identify modified objects for incremental backup

Pietro_La_Torre

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

Daniel_Leybovic

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; https://community.vertica.com/vertica/topics/how_is_data_stored_in_vertica

Pietro_La_Torre

thanks Daniel! very helpful! P.