1、安装tbase5.21.6.1数据库

目录

• 安装tbase5.21.6.1数据库
  • 1、创建用户：
  • 2、创建目录
  • 3、安装
  • 3、查看安装的目录
  • 4、创建initdb
  • 5、修改配置文件
    • 5.1、修改postgresql.conf
    • 5.2、修改pg_hba.conf
  • 6、启动数据库
  • 7、创建group
  • 8、设置用户的密码

安装tbase5.21.6.1数据库

安装包版本：tbase_pgxz-5.21.6.1-i.x86_64.rpm

1、创建用户：

groupadd -g 54320 postgres
useradd -u 54320 -g postgres tbase
passwd tbase

2、创建目录

mkdir -p /u01/tbase/package/
mkdir -p /u01/tbase/data/
chown -R tbase:postgres /u01
chmod -R 775 /u01

3、安装

上传安装包到/u01/tbase/package/目录下

rpm -ivh /u01/tbase/package/tbase_pgxz-5.21.6.1-i.x86_64.rpm

3、查看安装的目录

ls -l /usr/local/install/tbase_pgxz/

4、创建initdb

查看安装的目录：

find /usr/ -name 'psql'

输出：/usr/local/install/tbase_pgxz/bin/psql

切换tbase用户配置环境变量：

vi ~/.bash_profile

~/.bash_profile:

export PATH=/usr/local/install/tbase_pgxz/bin:$PATH
export LD_LIBRARY_PATH=/usr/local/install/tbase_pgxz/lib:$LD_LIBRARY_PATH

使变量生效：

source ~/.bash_profile

执行创建dn001：

mkdir -p /u01/tbase/data/dn001 
initdb --locale=zh_CN.UTF-8 -U tbase -E utf8 -D /u01/tbase/data/dn001 --nodename=dn001 --nodetype=datanode --master_gtm_nodename gtm_1 --master_gtm_ip 127.0.0.1 --master_gtm_port 21000

5、修改配置文件

新增的数据库：/u01/tbase/data/dn001/

5.1、修改postgresql.conf

vi /u01/tbase/data/dn001/postgresql.conf

新增配置：

V506版本：

set_global_snapshot = off
allow_dml_on_datanode = on 
use_local_sequence = on

V521版本：

allow_dml_on_datanode = on 
is_centralized_mode = on

通用参数：

listen_addresses='*'
port = 5432 
max_connections = 2000
max_pool_size = 65535
superuser_reserved_connections = 20
tcp_keepalives_idle = 60
tcp_keepalives_interval = 10
tcp_keepalives_count = 6
##取物理内存的25%
shared_buffers = 16GB
max_prepared_transactions = 20000
work_mem = 4MB
maintenance_work_mem = 1GB
wal_level = logical
max_wal_senders = 64
max_replication_slots = 64
max_logical_replication_workers = 64
wal_keep_segments = 1000
checkpoint_timeout = 10min
max_wal_size = 10GB
min_wal_size = 2GB
checkpoint_completion_target = 0.93
archive_mode = on
archive_command = '/bin/date'
max_standby_archive_delay = 1800s
max_standby_streaming_delay = 1800s
log_destination = 'csvlog'
logging_collector = on
log_directory = 'log'
log_file_mode = 0600
log_truncate_on_rotation = 'on'
log_rotation_age = 120
log_rotation_size = 1024MB
track_activity_query_size = 4096
log_min_duration_statement = 1000
log_checkpoints = on
log_autovacuum_min_duration = 0
log_statement = 'none'
log_timezone = 'PRC'
log_filename = 'postgresql-%A-%H.log'
track_counts = on
autovacuum = on
autovacuum_max_workers = 3
autovacuum_naptime = 1min
autovacuum_vacuum_scale_factor = 0.002
autovacuum_analyze_scale_factor = 0.001
shared_preload_libraries = 'pg_stat_statements,pg_errcode_stat'
pg_stat_statements.max = 1000
pg_stat_statements.track = all

5.2、修改pg_hba.conf

vi /u01/tbase/data/dn001/pg_hba.conf

pg_hba.conf新增如下配置:

## add
host    all             all             0.0.0.0/0            md5
host    all             all             127.0.0.1/32           trust

6、启动数据库

pg_ctl  -Z datanode -D /u01/tbase/data/dn001/ start

7、创建group

psql -h ipxxxx -p5432 -dpostgres -Utbase
create DEFAULT node group default_group with (dn001);
create sharding group to group default_group;
clean sharding;

8、设置用户的密码

登录：

psql -U tbase -d postgres

登录后执行sql:

ALTER USER tbase WITH PASSWORD 'newPWD';