Backup/restore script for Tarantool
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:
backup via ssh for tarantool https://dba.stackexchange.com/questions/298737
and a script to restore to local tarantool
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:
backup via ssh for tarantool https://dba.stackexchange.com/questions/298737
and a script to restore to local tarantool
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.
Related categories:
Database Administration