cn02管理

初始化

  1. [tbase@VM_0_47_centos ~]# initdb --locale=zh_CN.UTF-8 -U tbase -E utf8 -D /data/tbase/data/pgxz/cn02 --nodename=cn02 --nodetype=coordinator --master_gtm_nodename gtm_1 --master_gtm_ip 172.16.0.29 --master_gtm_port 21000

参数配置

  1. [tbase@VM_0_47_centos ~]# vim /data/tbase/data/pgxz/cn02/postgresql.conf
  3. port = 15432
  4. pooler_port=15433
  5. include_if_exists ='/data/tbase/global/postgresql.conf.user'
  7. [tbase@VM_0_47_centos ~]# vim /data/tbase/data/pgxz/cn02/pg_hba.conf
  9. local   all             all                    trust 
  10. host    all             all    127.0.0.1/32    trust
  12. host    replication    all    172.16.0.29/32    trust 
  13. host    all            all    172.16.0.29/32    trust 
  15. host    replication    all    172.16.0.47/32    trust 
  16. host    all            all    172.16.0.47/32    trust
  18. host    all            all       0.0.0.0/0        md5

服务管理

  • 启动服务
  1. [tbase@VM_0_47_centos ~]# pg_ctl -Z coordinator -D /data/tbase/data/pgxz/cn02 start
  • 关闭服务
  1. [tbase@VM_0_47_centos ~]# pg_ctl -Z coordinator -D /data/tbase/data/pgxz/cn02 stop
  2. [tbase@VM_0_47_centos ~]# pg_ctl -Z coordinator -D /data/tbase/data/pgxz/cn02 stop -m f #快速关闭
  3. [tbase@VM_0_47_centos ~]# pg_ctl -Z coordinator -D /data/tbase/data/pgxz/cn02 stop -m i #强制关闭
  • 重载参数
  1. [tbase@VM_0_47_centos ~]# pg_ctl -D /data/tbase/data/pgxz/cn02 reload
  • 查询状态
  1. [tbase@VM_0_47_centos ~]# pg_ctl -D /data/tbase/data/pgxz/cn02 status