postgresql10 rpm安装

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();