Clickhouse和Postgresql数据库备份恢复

     Clickhouse和Postgresql数据库备份恢复          1clickhouse备份恢复1.1clickhouse-backup备份恢复工具安装下载地址：https://github.com/AlexAkulov/clickhouse-backup/releases/download/v1.0.0/clickhouse-backup-1.0.0-1.x86_64.rpm安装命令：rpm-ivhclickhouse-backup-1.0.0-1.x86_64.rpm1.2备份clickhouse数据1.2.1执行备份命令备份命令：exportCLICKHOUSE_PORT=9091BACKUP_NAME=backup_clickhouse_$(date"+%Y-%m-%d-%H-%M-%S")clickhouse-backupcreate$BACKUP_NAME列出所有备份文件命令：clickhouse-backuplist[root@localhostbackup]#clickhouse-backuplistbackup_clickhouse_2021-09-01-14-54-25 22.02KiB 01/09/202106:54:26 localbackup_clickhouse_2021-09-01-14-56-56 22.02KiB 01/09/202106:56:57 local2021/09/0114:57:54errorInvalidParameter:1validationerror(s)found.-minimumfieldsizeof1,ListObjectsV2Input.Bucket.​[root@localhostbackup]#​备份文件默认保存在/opt/hyperion/clickhouse/backup目录，将备份的文件导出即可[root@localhostbackup]#ll/opt/hyperion/clickhouse/backup总用量0drwxr-x---4clickhouseclickhouse572021-09-0114:54:26backup_clickhouse_2021-09-01-14-54-25drwxr-x---4clickhouseclickhouse572021-09-0114:56:57backup_clickhouse_2021-09-01-14-56-56[root@localhostbackup]#​1.3恢复clickhouse数据2postgresql备份PGPASSWORD='VWY3NsbLgsaH_vze'pg_dump-p5432-dpylon-UQAX-Fc-fpylonbackup.dump​PGPASSWORD='VWY3NsbLgsaH_vze'pg_restore-p5432-dpylon-UQAX-c-Fcpylonbackup.dump​​​​PGPASSWORD='VWY3NsbLgsaH_vze'pg_dump-p5432-dzeus_pylon-Upostgres-Fc-fzeus_pylon_backup.dump​PGPASSWORD='VWY3NsbLgsaH_vze'pg_restore-p5432-dzeus_pylon-Upostgres-c-Fczeus_pylon_backup.dump​​​​​PGPASSWORD='VWY3NsbLgsaH_vze'pg_dump-p5432-dHYPER-Upostgres-Fc-fHYPER_backup.dump​PGPASSWORD='VWY3NsbLgsaH_vze'pg_restore-p5432-dHYPER-Upostgres-c-FcHYPER_backup.dump​grantallondatabasezeus_pylontopublic;​grantallonschemapublictopublic;​pg_restore-p5432-dpylon-Upostgres-cpylon_backup.dump​​​pg_dumpall-p5432-Upostgres-c>all_backup.out3redis备份4其他命令列出clickhouse-backup该包中有哪些文件rpm-qlclickhouse-backup -全文完-