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

 

posted @ 2021-05-06 16:17  疾风泣影  阅读(315)  评论(0)    收藏  举报