一、安装
官网链接:https://clickhouse.tech/docs/en/getting-started/install/
离线下载以下rpm包:
然后执行命令:
rpm -ivh ./*.rpm
二、配置
1、修改config.xml配置(可改可不改)
2、修改时区为:Asia/Shanghai
3、对外开放连接:取消<listen_host>::</listen_host> 注释
三、启动
1、出现问题
执行命令:
clickhouse-server --config-file=/etc/clickhouse-server/config.xml
出现以下错误 :
<Error> Application: DB::Exception: Effective user of the process (root) does not match the owner of the data (clickhouse). Run under 'sudo -u clickhouse'.
2、解决方法
2-1、更改目录/etc/clickhouse-server: chown -R clickhouse:clickhouse /etc/clickhouse-server
2-2、更改目录/var/log/clickhouse-server:chown -R clickhouse:clickhouse /var/log/clickhouse-server
3、后台启动:
nohup sudo -u clickhouse clickhouse-server --config-file=/etc/clickhouse-server/config.xml &
然后执行clickhouse-client 检测是否启动成功。