Kingbase ES v8 sys_basebackup 默认-X为stream
[kingbase@bogon ~]$ sys_basebackup --help
sys_basebackup 在运行的Kingbase服务器上执行基础备份.
使用方法:
sys_basebackup [选项]...
控制输出的选项:
-D,--kingbase-data=DIRECTORY 接收基本备份到目录
-F, --format=p|t 输出格式 (纯文本 (缺省值), tar压缩格式)
-r, --max-rate=RATE 传输数据目录的最大传输速率
(单位 kB/s, 也可以使用后缀"k" 或 "M")
-R, --write-recovery-conf
为复制写配置文件
-T, --tablespace-mapping=OLDDIR=NEWDIR
将表空间由 OLDDIR 重定位到 NEWDIR
--waldir=WALDIR 预写日志目录的位置
-X, --wal-method=none|fetch|stream
按指定的模式包含必需的WAL日志文件
-z, --gzip 对tar文件进行压缩输出
-Z, --compress=0-9 按给定的压缩级别对tar文件进行压缩输出
一般选项:
-c, --checkpoint=fast|spread
设置检查点方式(fast或者spread)
-C, --create-slot 创建复制槽
-l, --label=LABEL 设置备份标签
-n, --no-clean 出错后不清理
-N, --no-sync 不用等待变化安全的写入磁盘
-P, --progress 显示进度信息
-S, --slot=SLOTNAME 用于复制的槽名
-v, --verbose 输出详细的消息
-V, --version 输出版本信息, 然后退出
--no-slot 防止创建临时复制槽
--no-verify-checksums
不验证校验和
-?, --help 显示帮助, 然后退出
联接选项:
-d, --dbname=CONNSTR 连接串
-h, --host=HOSTNAME 数据库服务器主机或者是socket目录
-p, --port=PORT 数据库服务器端口号
-s, --status-interval=INTERVAL
发往服务器的状态包的时间间隔 (以秒计)
-U, --username=NAME 指定连接所需的数据库用户名
-w, --no-password 禁用输入密码的提示
-W, --password 强制提示输入密码 (应该自动发生)
报告错误至 <kingbase-bugs@kingbase.com.cn>.
[kingbase@bogon ~]$ 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 complete
sys_basebackup: checkpoint completed
sys_basebackup: write-ahead log start point: 0/D000028 on timeline 1
sys_basebackup: starting background WAL receiver
sys_basebackup: created temporary replication slot "sys_basebackup_4311"
sys_basebackup: write-ahead log end point: 0/D0000F8
sys_basebackup: waiting for background process to finish streaming ...
sys_basebackup: syncing data to disk ...
sys_basebackup: base backup completed
[kingbase@bogon ~]$ 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 complete
sys_basebackup: checkpoint completed
NOTICE: all required WAL segments have been archived
sys_basebackup: syncing data to disk ...
sys_basebackup: base backup completed
[kingbase@bogon ~]$ 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 complete
sys_basebackup: checkpoint completed
sys_basebackup: write-ahead log start point: 0/11000028 on timeline 1
sys_basebackup: write-ahead log end point: 0/110000F8
sys_basebackup: syncing data to disk ...
sys_basebackup: base backup completed
[kingbase@bogon ~]$ 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 complete
sys_basebackup: checkpoint completed
sys_basebackup: write-ahead log start point: 0/13000028 on timeline 1
sys_basebackup: starting background WAL receiver
sys_basebackup: created temporary replication slot "sys_basebackup_4352"
sys_basebackup: write-ahead log end point: 0/130000F8
sys_basebackup: waiting for background process to finish streaming ...
sys_basebackup: syncing data to disk ...
sys_basebackup: base backup completed
[kingbase@bogon ~]$
