Set interval of backup

[akshayparseja]

How do i set interval of backup rather than doing every 24h i want once in a week backup.
using the operator and a container running how do we set it up

[Slach]

look to
https://github.com/Altinity/clickhouse-backup/blob/master/Examples.md#how-to-use-clickhouse-backup-in-kubernetes

modify kind: CronJob manifest
with different scehdule
which will do only full backup weekly

[akshayparseja]

I am running a container clickhouse-backup , the cron job itself is running clickhouse server for backup.
Can i not use the clickhouse-backup image and schedule it?

[Slach]

cronjob doesn't run clickhouse-server
cronjob executes SQL commands via clickhouse-client and connect to exists clickhouse-server which deployed with clickhouse-operator via kind: ClickHouseInstallation

try to figure out with manifests from link which i shared above