# 配置WAL归档
[opengauss@fgedu.net.cn ~]$ vim /opengauss/fgdata/postgresql.conf
# 修改以下参数
wal_level = logical
archive_mode = on
archive_command = ‘cp %p /opengauss/backup/wal/%f’
archive_timeout = 60
[opengauss@fgedu.net.cn ~]$ mkdir -p /opengauss/backup/wal
更多学习教程公众号风哥教程itpux_com
[opengauss@fgedu.net.cn ~]$ chown -R opengauss:dbgrp /opengauss/backup
[opengauss@fgedu.net.cn ~]$ gs_ctl restart -D /opengauss/fgdata
waiting for server to shut down…. done
server stopped
waiting for server to start…. done
server started
# 执行全量备份
[opengauss@fgedu.net.cn ~]$ gs_basebackup -D /opengauss/backup/full/$(date +%Y%m%d) -h 192.168.1.100 -p 5432 -U opengauss -F p -X stream
Password:
gs_basebackup: initiating base backup, waiting for checkpoint to complete
gs_basebackup: checkpoint completed
gs_basebackup: write-ahead log start point: 0/12345678
gs_basebackup: write-ahead log end point: 0/12345678
gs_basebackup: base backup completed, pg_wal directory size: 16 MB
# 模拟业务操作
[opengauss@fgedu.net.cn ~]$ for i in {1..10}; do gsql -h 192.168.1.100 -p 5432 -U opengauss -d fgedudb -c “INSERT INTO fgedu_employee (name, age, dept_id, salary) VALUES (‘Employee$i’, $((20+i)), 1, $((5000+i*100)));”;
done
Password:
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
# 切换WAL日志
[opengauss@fgedu.net.cn ~]$ gsql -h 192.168.1.100 -p 5432 -U opengauss -d fgedudb -c “SELECT pg_switch_wal();
“
Password:
from DB视频:www.itpux.com
pg_switch_wal
—————
0/12345679
(1 row)
# 查看WAL归档文件
[opengauss@fgedu.net.cn ~]$ ls -la /opengauss/backup/wal/
total 32768
drwxr-xr-x 2 opengauss dbgrp 4096 Jan 1 12:34 .
drwxr-xr-x 3 opengauss dbgrp 4096 Jan 1 12:34 ..
-rw——- 1 opengauss dbgrp 16777216 Jan 1 12:34 000000010000000000000001
-rw——- 1 opengauss dbgrp 16777216 Jan 1 12:34 000000010000000000000002

4.2 时间点恢复实战