1 clickhouse备份恢复

1.1 clickhouse-backup备份恢复工具安装

下载地址：https://github.com/AlexAkulov/clickhouse-backup/releases/download/v1.0.0/clickhouse-backup-1.0.0-1.x86_64.rpm

安装命令：

rpm -ivh clickhouse-backup-1.0.0-1.x86_64.rpm

1.2 备份clickhouse数据

1.2.1执行备份命令

备份命令：

export CLICKHOUSE_PORT=9091
BACKUP_NAME=backup_clickhouse_$(date "+%Y-%m-%d-%H-%M-%S")
clickhouse-backup create $BACKUP_NAME 

列出所有备份文件命令：

clickhouse-backup list

[root@localhost backup]# clickhouse-backup list
backup_clickhouse_2021-09-01-14-54-25   22.02KiB   01/09/2021 06:54:26   local
backup_clickhouse_2021-09-01-14-56-56   22.02KiB   01/09/2021 06:56:57   local
2021/09/01 14:57:54 error InvalidParameter: 1 validation error(s) found.
- minimum field size of 1, ListObjectsV2Input.Bucket.
​
[root@localhost backup]#
​

备份文件默认保存在/opt/hyperion/clickhouse/backup目录，将备份的文件导出即可

[root@localhost backup]# ll /opt/hyperion/clickhouse/backup
总用量 0
drwxr-x--- 4 clickhouse clickhouse 57 2021-09-01 14:54:26 backup_clickhouse_2021-09-01-14-54-25
drwxr-x--- 4 clickhouse clickhouse 57 2021-09-01 14:56:57 backup_clickhouse_2021-09-01-14-56-56
[root@localhost backup]#
​

1.3 恢复clickhouse数据

2 postgresql备份

PGPASSWORD='123456' pg_dump -p 5432 -d pylon -U QAX -Fc -f pylonbackup.dump
​
PGPASSWORD='123456' pg_restore -p 5432 -d pylon -U QAX -c -Fc  pylonbackup.dump
​
​
​
​
PGPASSWORD='123456' pg_dump -p 5432 -d zeus_pylon -U postgres -Fc -f zeus_pylon_backup.dump
​
PGPASSWORD='123456' pg_restore -p 5432 -d zeus_pylon -U postgres -c -Fc zeus_pylon_backup.dump
​
​
​
​
​
PGPASSWORD='123456' pg_dump -p 5432 -d HYPER -U postgres -Fc -f HYPER_backup.dump
​
PGPASSWORD='123456' pg_restore -p 5432 -d HYPER -U postgres -c -Fc HYPER_backup.dump
​
grant all  on database zeus_pylon to public;
​
grant all on  schema public to public;
​
pg_restore -p 5432 -d pylon -U postgres -c  pylon_backup.dump
​
​
​
pg_dumpall -p 5432  -U postgres -c > all_backup.out

3 redis备份

4 其他命令

列出 clickhouse-backup该包中有哪些文件

rpm -ql clickhouse-backup