文件名称：vertica对象级备份-51单片机_ds1302时钟芯片_共阴数码管_时钟实例【中为电子科技工作室】
文件大小：522KB
文件格式：PDF
更新时间：2024-07-20 16:04:31
Vertica MPP 大数据 数据库 数据仓库
1.4 vertica对象级备份 官网文档： The database administrator user can create object-level backups consisting of one or more schemas and tables. Object-level backups are especially useful for multi-tenanted database sites. 其实对象级备份和全量备份差不多，知识在生成备份配置文件时有所不同（注意不 同之处）： [dbadmin@localhost ~]$ /opt/vertica/bin/vbr.py --setupconfigSnapshot name (backup_snaps hot): backup_object_tb_serv Number of restore points (1): Specify objects (no default): tb_serv_num Object restore mode (coexist, createOrReplace or create) (createOrReplace): Vertica user name (dbadmin): Save password to avoid runtime prompt? (n) [y/n]: y Database user password to save in vbr password config file (no default): Node v_windy1990_node0001 Backup host name (no default): 192.168.231.110 Backup directory (no default): /home/dbadmin/backup Change advanced settings? (n) [y/n]: Password file name (no default): password Saved vbr password to password. Config file name (backup_object_tb_serv.ini): Saved vbr config to backup_object_tb_serv.ini. 然后在执行备份命令： [dbadmin@localhost ~]$ /opt/vertica/bin/vbr.py --task backup --config-file backup_objec t_tb_serv.ini Starting backup of database Windy1990. Objects: ['tb_serv_num'] Participating nodes: v_windy1990_node0001. Snapshotting database. 37