1. Oracle之DBLINK

    1.赋予创建dblink的权限 grant create database link,drop public database link to ayee;

    2016/11/03 Oracle

  2. GPDB之基础笔记

    建表 建普通表 CREATE TABLE demo_tbl ( id integer, name character varying, gao character varying ) DISTRIBUTED BY (id);

    2016/11/03 GPDB

  3. GPDB之安装GPDB

    1. 配置机器的对应关系 192.168.20.65 mdw 192.168.20.66 smdw 192.168.20.67 sdw1 192.168.20.68 sdw2 192.168.20.69 sdw3   2. 将数据盘格式化成xfs文件系统 2.1格式化xfs根 #master节点: rpm -ivh xfsprogs-2.9.4-1.el5.centos.x86_64.rpm mkfs.xfs -f /dev/sdb mount /dev/sdb /data df -vhT

    2016/08/23 GPDB

  4. GPDB之安装GPCC

    1.卸载GPCC 1.1.关闭GPCC $ gpcmdr --stop 1.2.删除所有机器上的安装目录 $ rm -rf /usr/local/greenplum-cc-web-version 1.3.禁用数据收集代理 su - gpadmin Edit $MASTER_DATA_DIRECTORY/postgresql.conf and disable the data collection agents: gp_enable_gpperfmon = off 1.4.删除或注释掉gpmon条目pg_hba.conf #local gpperfmon gpmon md5 #host gpperfmon gpmon 0.0.0.0/0 md5 1.5.重启GP数据库 $ gpstop -r Clean up any uncommitted Command Center data and log files that reside on the master file system: 1.6.清除GPCC的logs和data的信息 $ rm -rf $MASTER_DATA_DIRECTORY/gpperfmon/data/* $ rm -rf $MASTER_DATA_DIRECTORY/gpperfmon/logs/* 1.7.删除gpperfmon数据库(当不想保留历史的gpcc数据) $ dropdb gpperfmon

    2016/08/23 GPDB