gpdb 基础操作
gpdb 基础知识
1.greenplum3.8.1 是基于postgres8.2.5改进的,所以命令语法类的可以参照pg的来。
2.命令操作
gpstart
gpstop
gpstop -M immediate
psql -d postgres
psql -d postgres -h gphostm -p 5432 -U gpadmin
select * from gp_segment_configuration;
select * from pg_filespace_entry;
psql -l
==>
createuser -h 192.168.109.51 -p 5000 -D -A -e testuser
createuser -P -d -a -e testuser 超级用户
dropuser xxx
createdb -p 5432 -e -U gpadmin mydb
==>
\q --退出
\d --列出所有表
==》
===》
锁
select a.locktype, a.database,a.pid,a.mode,a.relation, b.relname from pg_locks a join pg_class b on a.relation = b.oid where upper(b.relname) = 'TEST';
kill 所有
select pg_terminate_backend(PID);
kill 查询
select pg_cancel_backend(PID);
===>odbc安装
1、需要9.2版本的pgodbc库
2、./configure --with-libpg=/opt/greenplum-db/lib --with-unixodbc
如缺少库,设置而环境变量:LD_IBRARY_PATH 和PG_CONFIG
3.odbc配置
vi /etc/odbcinst.ini
[PostgreSQL]
...
Driver = /usr/local/lib/psqlodbcw.so
threading = 0
...
vi /ect/odbc.ini
[gp]
Driver = PostgreSQL
Database = postgres
ServerName = 192.168.109.131
UserName = gpadmin
Password = gpadmin
Port = 5432
ReadOnly = 0
===>性能问题
关注 UseServerSidePrepare = 1