环境准备

机器准备

• 服务器数量

2台，IP分别为： 172.16.0.29，172.16.0.47

• 硬件配置

CPU：4核内存：8G系统盘：50G数据盘：200G

• 操作系统要求

centos7.3

创建OS用户

• 创建操作系统运行用户

[root@VM_0_29_centos ~]# adduser -d /data/tbase tbase

• 配置操作系统用户密码

[root@VM_0_29_centos pgxztmp]# passwd tbase

• 创建tbase应用程序运行目录

[root@VM_0_29_centos pgxz]# su tbase  
[tbase@VM_0_29_centos install]$ mkdir -p /data/tbase/install/pgxz

• 创建tbase数据目录

[root@VM_0_29_centos pgxz]# su tbase  
[tbase@VM_0_29_centos install]$ mkdir -p /data/tbase/data/pgxz

• 上传pgxz应用程序到目录/data/tbase/install/pgxz下面，目录的结构为

[tbase@VM_0_29_centos pgxz]$ ll /data/tbase/install/pgxz
total 4
drwxrwxr-x 2 pgxz pgxz 4096 Nov 10 04:33 bin
drwxrwxr-x 4 pgxz pgxz  189 Nov 10 04:33 include
drwxrwxr-x 4 pgxz pgxz  172 Nov 10 04:33 lib
drwxrwxr-x 3 pgxz pgxz   24 Oct  1 14:54 share
[tbase@VM_0_29_centos pgxz]$ 

• 配置pgxz用户的环境变量

[tbase@VM_0_29_centos ~]$ vim /data/tbase/.bashrc 
# .bashrc
# Source global definitions
if [ -f /etc/bashrc ]; then
        . /etc/bashrc
fi
export TBASE_HOME=/data/tbase/install/pgxz
export PATH=$TBASE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$TBASE_HOME/lib:${LD_LIBRARY_PATH}

配置公共参数

[tbase@VM_0_29_centos ~]# mkdir -p /data/tbase/global/
[tbase@VM_0_29_centos ~]#vim /data/tbase/global/postgresql.conf.user
listen_addresses = '0.0.0.0'
max_connections = 500
max_pool_size = 65535
shared_buffers = 1GB                    
max_prepared_transactions = 2000
maintenance_work_mem = 256MB
wal_level = logical
max_wal_senders = 64
max_wal_size = 1GB
min_wal_size = 256MB
log_destination = 'csvlog'
logging_collector = on
log_directory = 'log'
log_filename = 'postgresql-%A-%H.log' 
synchronous_commit = local
synchronous_standby_names = '' 

安装配置拓补结构说明