Options

identify modified objects for incremental backup

Pietro_La_TorrePietro_La_Torre ✭
in General Discussion
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

Comments

  • Options
    Daniel_LeybovicDaniel_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
  • Options
    Pietro_La_TorrePietro_La_Torre ✭
    thanks Daniel! very helpful! P.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...