实际可⽤总容量略⼩于节点个数*节点磁盘⼤⼩/2，请根据实际数据⼤⼩选择合适的节点。 3.设置数据仓库信息 必选项有数据仓库名称、DB管理员⽤⼾名、管理员密码。可选项有默认DB,默认DB的名称为dev，你可以选择除了“test”、“postgres”、“template”、“template0”、“template1” 、 “default”之外的其他名称。 DB管理员⽤⼾名不能为“postgres”。端⼝固定为 python-psycopg2 ⽰例1. 连接UDW testconn.py #!/usr/bin/python import psycopg2 conn = psycopg2.connect(database="dev", user="username", password="password", host="hostIP", port="port") print "Opened database successfully" ⽰例2. 创建⼀个表 createTable.py #!/usr/bin/python import psycopg2 conn = psycopg2.connect(database="dev", user="username", password="password", host="hostIP", port="port") print "Opened database successfully"

---------------------------------------- PostgreSQL 8.3.23 (Greenplum Database 5.4.1+dev.56.gcdfadd9 build dev) ... postgres=# SELECT * FROM gp_segment_configuration ; dbid | content | role | preferred_role ​-​b ​1​ ​-​C ​-​1​ ​-​z ​0​ ​-m 2.2.5 启动Segment出错 如果启动 segment 时出错，并且看不到具体错误信息（通常由于错误信息被重定向到 /dev/null 了），则可以尝试手动启动 segment。 手动启动segment的命令参加下面，需要根据自己的环境修改某些路径或者参数： export​ LD_LIBRARY_PATH​ 如上图所示，可以通过 IDE 很直观的看到正在执行的代码片段，以及函数中变量的值。对于学习 和调试Greenplum非常有帮助。 5. 问题讨论 如果遇到问题无法解决，优先建议到 gpdb-dev 邮件列表讨论，或者在github上面报告Issues (​https://github.com/greenplum-db/gpdb/issues​). 欢迎加入 Greenplum 中文社区， https://greenplum

Apache SOLR Text PostGIS GeoSpatial Custom Apps BI / Reporting Machine Learning AI IT Dev Business Analysts Data Scientists On-Premises Public Clouds Private Clouds Fully ● CREATE OR REPLACE FUNCTION r_norm(n integer, mean float8, std_dev float8) RETURNS float8[ ] AS $$ x<-rnorm(n,mean,std_dev) return(x) $$ LANGUAGE 'plr'; ● CREATE TABLE test_norm_var

install -y perl 6. Mount the ISO containing the VMware Tools binary. $ mkdir -p /mnt/cdrom $ mount /dev/cdrom /mnt/cdrom 7. Extract the installation file. $ cd /tmp $ tar -xzvf /mnt/cdrom/VMwareTools* virtual machine data drive: $ mkdir -p /gpdata $ mkfs.xfs /dev/sdb $ mount -t xfs -o rw,noatime,nodev,inode64 /dev/sdb /gpdata/ $ df -kh $ echo /dev/sdb /gpdata/ xfs rw,nodev,noatime,inode64 0 0 >> /etc/fstab Update the file content: # Configure readahead for the `/dev/sdb` to 16384 512-byte sectors, i.e. 8MiB /sbin/blockdev --setra 16384 /dev/sdb # Configure gp-virtual-internal network settings with MTU

install -y perl 6. Mount the ISO containing the VMware Tools binary. $ mkdir -p /mnt/cdrom $ mount /dev/cdrom /mnt/cdrom 7. Extract the installation file. $ cd /tmp $ tar -xzvf /mnt/cdrom/VMwareTools* virtual machine data drive: $ mkdir -p /gpdata $ mkfs.xfs /dev/sdb $ mount -t xfs -o rw,noatime,nodev,inode64 /dev/sdb /gpdata/ $ df -kh $ echo /dev/sdb /gpdata/ xfs rw,nodev,noatime,inode64 0 0 >> /etc/fstab Update the file content: # Configure readahead for the `/dev/sdb` to 16384 512-byte sectors, i.e. 8MiB /sbin/blockdev --setra 16384 /dev/sdb # Configure gp-virtual-internal network settings with MTU

install -y perl 6. Mount the ISO containing the VMware Tools binary. $ mkdir -p /mnt/cdrom $ mount /dev/cdrom /mnt/cdrom 7. Extract the installation file. $ cd /tmp VMware Tanzu Greenplum 6 Documentation virtual machine data drive: $ mkdir -p /gpdata $ mkfs.xfs /dev/sdb $ mount -t xfs -o rw,noatime,nodev,inode64 /dev/sdb /gpdata/ $ df -kh $ echo /dev/sdb /gpdata/ xfs rw,nodev,noatime,inode64 0 0 >> /etc/fstab Update the file content: # Configure readahead for the `/dev/sdb` to 16384 512-byte sectors, i.e. 8MiB /sbin/blockdev --setra 16384 /dev/sdb # Configure gp-virtual-internal network settings with

目前的例子，我们选择用 gpfdist 协议，例如，我们在 192.168.88.66 机器上 启动 gpfdist 服务。 $ nohup gpfdist -p 8080 -d /../ >/dev/null 2>&1 & 此处说明一下，gpfdist 不允许直接在/目录上启动服务，因此可以通过/../的 方式间接的从/上启动服务。 2、 创建一张可写外部表，表结构与需要交换分区的分区表保持一致(使用 如果不需要gpfdist的输出， 可以这样启动gpfdist服务： $ nohup gpfdist -p 8080 -d /../ >/dev/null 2>&1 & $ nohup gpfdist -p 8081 -d /../ >/dev/null 2>&1 & 正如上面的例子，可以在相同的目录上启动多个gpfdist服务，只要监听端口不 同即可。这样就可以为不同的外部表 Raid 1 2 /dev/sda 2048MB /boot 操作系统 剩余尺寸 / Greenplum Database 管理员指南 V6.2.1 版权所有：Esena(陈淼 +86 18616691889) 编写：陈淼 - 271 - 盘 Raid 5 X+1+1 /dev/sdb 内存尺寸 swap SWAP /dev/sdc 剩余尺寸 /data

install -y perl 6. Mount the ISO containing the VMware Tools binary. $ mkdir -p /mnt/cdrom $ mount /dev/cdrom /mnt/cdrom 7. Extract the installation file. $ cd /tmp $ tar -xzvf /mnt/cdrom/VMwareTools* virtual machine data drive: $ mkdir -p /gpdata $ mkfs.xfs /dev/sdb $ mount -t xfs -o rw,noatime,nodev,inode64 /dev/sdb /gpdata/ $ df -kh $ echo /dev/sdb /gpdata/ xfs rw,nodev,noatime,inode64 0 0 >> /etc/fstab Update the file content: # Configure readahead for the `/dev/sdb` to 16384 512-byte sectors, i.e. 8MiB /sbin/blockdev --setra 16384 /dev/sdb # Configure gp-virtual-internal network settings with MTU

be set in the /etc/fstab file. This example entry from an fstab file specifies the XFS options. /dev/data /data xfs nodev,noatime,inode64 0 0 VMware Greenplum v6.18 Documentation VMware, Inc. 245 Disk /sbin/blockdev --getra /dev/sdb To set blockdev (read-ahead) on a device: # sudo /sbin/blockdev --setra For example: # sudo /sbin/blockdev --setra 16384 /dev/sdb See the manual page to the rc.local file to set the read-ahead value for the disk sdb. /sbin/blockdev --setra 16384 /dev/sdb On systems that use systemd, you must also set the execute permissions on the rc.local file to

be set in the /etc/fstab file. This example entry from an fstab file specifies the XFS options. /dev/data /data xfs nodev,noatime,inode64 0 0 VMware Greenplum v6.19 Documentation VMware, Inc. 252 Disk /sbin/blockdev --getra /dev/sdb To set blockdev (read-ahead) on a device: # sudo /sbin/blockdev --setra For example: # sudo /sbin/blockdev --setra 16384 /dev/sdb See the manual page to the rc.local file to set the read-ahead value for the disk sdb. /sbin/blockdev --setra 16384 /dev/sdb On systems that use systemd, you must also set the execute permissions on the rc.local file to