Create backup script for Tarantool and Clickhouse -- 2
Budget: $10 – $30 USD
PostgreSQL version:
```
# backup script:
ssh root@mywebsite -p 22 "pg_dump -U dbuser -Fc -c dbname | xz - -c" \
| pv -r -b > backup/db_backup_`date +%Y-%m-%d_%H%M%S`.sql.xz
# restore script:
fname=`ls -w 1 backup/*sql.xz | tail -n 1`
xzcat $fname | pg_restore -U dbuser -d dbname
```
The task is to create similar to that script, that does:
1. backup via ssh for tarantool https://dba.stackexchange.com/questions/298737
and a script to restore to local tarantool
2. backup via ssh for clickhouse https://dba.stackexchange.com/questions/297342
and a script to restore to local clickhouse
you should able to install Tarantool and Clickhouse inside your own VM/server (to backup) and locally (to restore), create a table, and fill with dummy data yourself, then write the backup and restore script.
```
# backup script:
ssh root@mywebsite -p 22 "pg_dump -U dbuser -Fc -c dbname | xz - -c" \
| pv -r -b > backup/db_backup_`date +%Y-%m-%d_%H%M%S`.sql.xz
# restore script:
fname=`ls -w 1 backup/*sql.xz | tail -n 1`
xzcat $fname | pg_restore -U dbuser -d dbname
```
The task is to create similar to that script, that does:
1. backup via ssh for tarantool https://dba.stackexchange.com/questions/298737
and a script to restore to local tarantool
2. backup via ssh for clickhouse https://dba.stackexchange.com/questions/297342
and a script to restore to local clickhouse
you should able to install Tarantool and Clickhouse inside your own VM/server (to backup) and locally (to restore), create a table, and fill with dummy data yourself, then write the backup and restore script.