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