Backup + password

[den-crane]

https://clickhouse.com/docs/en/operations/backup#assign-a-password-to-the-backup

This documentation does not explain whether a password is applicable.

BACKUP TABLE my_table  TO Disk('backups','b') SETTINGS password='qwerty';

DB::Exception: Password is not applicable, backup cannot be encrypted. (BAD_ARGUMENTS)

BACKUP TABLE my_table  TO Disk('backups', '2.zstd') SETTINGS password='qwerty', compression_method='ZSTD';

DB::Exception: Password is not applicable, backup cannot be encrypted. (BAD_ARGUMENTS)

The error is also unclear.

If the password is applicable to zip archives only and uses zip archives passwords (I am not sure), then I would to state it more clearly.

@vitlibar