1、下载安装包
postgresql10-10.7-2PGDG.rhel7.x86_64.rpm
postgresql10-contrib-10.7-2PGDG.rhel7.x86_64.rpm
postgresql10-libs-10.7-2PGDG.rhel7.x86_64.rpm
postgresql10-server-10.7-2PGDG.rhel7.x86_64.rpm
2、安装:
yum install libicu
yum install libxslt
rpm -ivh postgresql10-libs-10.7-2PGDG.rhel7.x86_64.rpm
rpm -ivh postgresql10-10.7-2PGDG.rhel7.x86_64.rpm
rpm -ivh postgresql10-server-10.7-2PGDG.rhel7.x86_64.rpm
rpm -ivh postgresql10-contrib-10.7-2PGDG.rhel7.x86_64.rpm
3、集群插件:
rpm -ivh citus83_10-8.3.2.citus-1.el7.x86_64.rpm
rpm -ivh citus83_10-debuginfo-8.3.2.citus-1.el7.x86_64.rpm
4、修改数据存储路径:
initdb -D /datadir
pgctl -D /data01/postgresql/pg -l logfile start
修改postgresql.conf:
data_directory='/datadir'
listen='*'
hba_file='/datadir/pg_hba.conf'
shared_preload_libraries = 'citus'
citus.shard_count = 128 # 并发数
5、默认用户名密码设置
# psql
ALTER USER postgres WITH PASSWORD 'postgres';
6、修改pg_hba.conf
设置远程用户名密码登录,添加:
host all all 0.0.0.0/0 md5
在worker上配置
host all all 10.242.4.0/24 trust
7、添加workernode
SELECT * from master_add_node('10.242.4.85', 5433);
查看是否成功:
SELECT * FROM master_get_active_worker_nodes();