一名数据库爱好者的专栏

os: ubuntu 16.04db: greenplum 5.13192.168.0.99 mas192.168.0.100 sla192.168.0.101 seg1192.168.0.102 seg2创建用户# groupadd -g 10000 gpadmin# useradd -u 10000 -g gpadmin -s /bin/bash -d /ho...

os: centos 7.4 gp: gpdb-5.7.0greenplum 简称gp，是由postgresql演变而来，感兴趣的哥们可以baidu一下三台机器 node1 为master host node2、node3为segment hostos设置# cat /etc/centos-releaseCentOS Linux release 7.4.1708 (...

greenplum 5.7 configure$ $ ./configure \--prefix=/usr/local/greenplum-db --with-perl --with-python --with-libxml --with-gssapi \--with-pgport=5432 --with-libedit-preferred \--with-openssl --with-...

os: centos 7.4 gp: gpdb-5.7.0三台机器 node1 为 master host node2、node3 为 segment hostpsql 登录 masternode1 上操作# su - gpadmin$ psql -d peiybdbpsql (8.3.23)Type "help" for help.peiybdb=# \l ...

os: centos 7.4db: greeenplum 5.7greeenplum 编译执行 configure 时 报错如下:$ ./configure --prefix=/usr/local/greenplum-db --with-perl --with-python --with-libxml --with-gssapi \--enable-orca --enable-mapred...