comecheer.com

mysql ：mysqladmin -u root password 'root'create user peter identified by 'peter';grant all privileges on *.* to 'peter'@'%' with grant option;flush privileges;export ORACLE_HOME=/usr

# yum install postgresql-server# useradd postgre#passwd postgre#su postgre$mkdir postgreSQL$initdb /home/postgre/postgreSQL/data$pg_ctl -D /home/postgre/postgreSQL/data -l logfile start 启动

greenplum dblinkgreenplum 下面编译postgresql源码中的contrib下面的dblink修改makefile下面的PG_CPPFLAGS 忽略所有warningPG_CPPFLAGS = -I$(libpq_srcdir) -w编译make USE_PGXS=1 installcreatedb test_dbpsql -f dblink.s

create language plpythonu;

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)# /etc/init.d/mysql stop# /usr/bin/mysqld_safe --user=mysql --skip-grant-tables --skip-networking &# mysql -u ro

gpconfig -c max_connections -v 200 -m 50注:生效需要重启GP；

1.安装前准备 (注：本人使用Fedora16)1-在/etc/sysctl.conf 文件中加入有关共享内存与网络参数配置   kernel.shmmax = 500000000 kernel.shmmni = 4096 kernel.shmall = 4000000000 kernel.sem = 250 64000 100 512 net.i