[kingbasebogon ~]$ sys_basebackup --helpsys_basebackup 在运行的Kingbase服务器上执行基础备份.使用方法:sys_basebackup [选项]...控制输出的选项:-D--kingbase-dataDIRECTORY 接收基本备份到目录-F, --formatp|t 输出格式 (纯文本 (缺省值), tar压缩格式)-r, --max-rateRATE 传输数据目录的最大传输速率(单位 kB/s, 也可以使用后缀k 或 M)-R, --write-recovery-conf为复制写配置文件-T, --tablespace-mappingOLDDIRNEWDIR将表空间由 OLDDIR 重定位到 NEWDIR--waldirWALDIR 预写日志目录的位置-X, --wal-methodnone|fetch|stream按指定的模式包含必需的WAL日志文件-z, --gzip 对tar文件进行压缩输出-Z, --compress0-9 按给定的压缩级别对tar文件进行压缩输出一般选项:-c, --checkpointfast|spread设置检查点方式(fast或者spread)-C, --create-slot 创建复制槽-l, --labelLABEL 设置备份标签-n, --no-clean 出错后不清理-N, --no-sync 不用等待变化安全的写入磁盘-P, --progress 显示进度信息-S, --slotSLOTNAME 用于复制的槽名-v, --verbose 输出详细的消息-V, --version 输出版本信息, 然后退出--no-slot 防止创建临时复制槽--no-verify-checksums不验证校验和-?, --help 显示帮助, 然后退出联接选项:-d, --dbnameCONNSTR 连接串-h, --hostHOSTNAME 数据库服务器主机或者是socket目录-p, --portPORT 数据库服务器端口号-s, --status-intervalINTERVAL发往服务器的状态包的时间间隔 (以秒计)-U, --usernameNAME 指定连接所需的数据库用户名-w, --no-password 禁用输入密码的提示-W, --password 强制提示输入密码 (应该自动发生)报告错误至 kingbase-bugskingbase.com.cn.[kingbasebogon ~]$ sys_basebackup -h localhost -U system -D /data/kingbase/backup/$(date %Y%m%d%H%M%S) -v口令:sys_basebackup: initiating base backup, waiting for checkpoint to completesys_basebackup: checkpoint completedsys_basebackup: write-ahead log start point: 0/D000028 on timeline 1sys_basebackup: starting background WAL receiversys_basebackup: created temporary replication slot sys_basebackup_4311sys_basebackup: write-ahead log end point: 0/D0000F8sys_basebackup: waiting for background process to finish streaming ...sys_basebackup: syncing data to disk ...sys_basebackup: base backup completed[kingbasebogon ~]$ sys_basebackup -h localhost -U system -D /data/kingbase/backup/$(date %Y%m%d%H%M%S) -v -X none口令:sys_basebackup: initiating base backup, waiting for checkpoint to completesys_basebackup: checkpoint completedNOTICE: all required WAL segments have been archivedsys_basebackup: syncing data to disk ...sys_basebackup: base backup completed[kingbasebogon ~]$ sys_basebackup -h localhost -U system -D /data/kingbase/backup/$(date %Y%m%d%H%M%S) -v -X fetch口令:sys_basebackup: initiating base backup, waiting for checkpoint to completesys_basebackup: checkpoint completedsys_basebackup: write-ahead log start point: 0/11000028 on timeline 1sys_basebackup: write-ahead log end point: 0/110000F8sys_basebackup: syncing data to disk ...sys_basebackup: base backup completed[kingbasebogon ~]$ sys_basebackup -h localhost -U system -D /data/kingbase/backup/$(date %Y%m%d%H%M%S) -v -X stream口令:sys_basebackup: initiating base backup, waiting for checkpoint to completesys_basebackup: checkpoint completedsys_basebackup: write-ahead log start point: 0/13000028 on timeline 1sys_basebackup: starting background WAL receiversys_basebackup: created temporary replication slot sys_basebackup_4352sys_basebackup: write-ahead log end point: 0/130000F8sys_basebackup: waiting for background process to finish streaming ...sys_basebackup: syncing data to disk ...sys_basebackup: base backup completed[kingbasebogon ~]$
Kingbase ES v8 sys_basebackup 默认-X为stream
[kingbasebogon ~]$ sys_basebackup --helpsys_basebackup 在运行的Kingbase服务器上执行基础备份.使用方法:sys_basebackup [选项]...控制输出的选项:-D--kingbase-dataDIRECTORY 接收基本备份到目录-F, --formatp|t 输出格式 (纯文本 (缺省值), tar压缩格式)-r, --max-rateRATE 传输数据目录的最大传输速率(单位 kB/s, 也可以使用后缀k 或 M)-R, --write-recovery-conf为复制写配置文件-T, --tablespace-mappingOLDDIRNEWDIR将表空间由 OLDDIR 重定位到 NEWDIR--waldirWALDIR 预写日志目录的位置-X, --wal-methodnone|fetch|stream按指定的模式包含必需的WAL日志文件-z, --gzip 对tar文件进行压缩输出-Z, --compress0-9 按给定的压缩级别对tar文件进行压缩输出一般选项:-c, --checkpointfast|spread设置检查点方式(fast或者spread)-C, --create-slot 创建复制槽-l, --labelLABEL 设置备份标签-n, --no-clean 出错后不清理-N, --no-sync 不用等待变化安全的写入磁盘-P, --progress 显示进度信息-S, --slotSLOTNAME 用于复制的槽名-v, --verbose 输出详细的消息-V, --version 输出版本信息, 然后退出--no-slot 防止创建临时复制槽--no-verify-checksums不验证校验和-?, --help 显示帮助, 然后退出联接选项:-d, --dbnameCONNSTR 连接串-h, --hostHOSTNAME 数据库服务器主机或者是socket目录-p, --portPORT 数据库服务器端口号-s, --status-intervalINTERVAL发往服务器的状态包的时间间隔 (以秒计)-U, --usernameNAME 指定连接所需的数据库用户名-w, --no-password 禁用输入密码的提示-W, --password 强制提示输入密码 (应该自动发生)报告错误至 kingbase-bugskingbase.com.cn.[kingbasebogon ~]$ sys_basebackup -h localhost -U system -D /data/kingbase/backup/$(date %Y%m%d%H%M%S) -v口令:sys_basebackup: initiating base backup, waiting for checkpoint to completesys_basebackup: checkpoint completedsys_basebackup: write-ahead log start point: 0/D000028 on timeline 1sys_basebackup: starting background WAL receiversys_basebackup: created temporary replication slot sys_basebackup_4311sys_basebackup: write-ahead log end point: 0/D0000F8sys_basebackup: waiting for background process to finish streaming ...sys_basebackup: syncing data to disk ...sys_basebackup: base backup completed[kingbasebogon ~]$ sys_basebackup -h localhost -U system -D /data/kingbase/backup/$(date %Y%m%d%H%M%S) -v -X none口令:sys_basebackup: initiating base backup, waiting for checkpoint to completesys_basebackup: checkpoint completedNOTICE: all required WAL segments have been archivedsys_basebackup: syncing data to disk ...sys_basebackup: base backup completed[kingbasebogon ~]$ sys_basebackup -h localhost -U system -D /data/kingbase/backup/$(date %Y%m%d%H%M%S) -v -X fetch口令:sys_basebackup: initiating base backup, waiting for checkpoint to completesys_basebackup: checkpoint completedsys_basebackup: write-ahead log start point: 0/11000028 on timeline 1sys_basebackup: write-ahead log end point: 0/110000F8sys_basebackup: syncing data to disk ...sys_basebackup: base backup completed[kingbasebogon ~]$ sys_basebackup -h localhost -U system -D /data/kingbase/backup/$(date %Y%m%d%H%M%S) -v -X stream口令:sys_basebackup: initiating base backup, waiting for checkpoint to completesys_basebackup: checkpoint completedsys_basebackup: write-ahead log start point: 0/13000028 on timeline 1sys_basebackup: starting background WAL receiversys_basebackup: created temporary replication slot sys_basebackup_4352sys_basebackup: write-ahead log end point: 0/130000F8sys_basebackup: waiting for background process to finish streaming ...sys_basebackup: syncing data to disk ...sys_basebackup: base backup completed[kingbasebogon ~]$
