一,安装web监控界面

  01,准备

  下载greenplum cc包,>>

  解压缩

  02,安装前配置

vim /greenplum/data/master/gpseg-/pg_hba.conf
local gpperfmon gpmon trust
host all gpmon 127.0.0.1/ trust
host all gpmon ::/ trust 配置 export PGDATA=/greenplum/data/master/gpseg-1/

  03,安装

./gpccinstall-4.1.1

缺少用户,执行以下命令

gpperfmon_install --enable --password 123456 --port 5432

然后继续执行安装命令

[gpadmin@greenplum01 greenplum-cc-web-4.6.-LINUX-x86_64]$ ./gpccinstall-4.6.
*** IMPORTANT INFORMATION - PLEASE READ CAREFULLY *** PIVOTAL GREENPLUM DATABASE END USER LICENSE AGREEMENT IMPORTANT - READ CAREFULLY: This Software contains computer programs and
other proprietary material and information, the use of which is subject to
and expressly conditioned upon acceptance of this End User License
Agreement ("EULA"). .................(慢慢点跳过)
Rev: Pivotal_GPDB_EULA_03182014.txt
I HAVE READ AND AGREE TO THE TERMS OF THE ABOVE PIVOTAL GREENPLUM DATABASE
END USER LICENSE AGREEMENT.
Do you agree to the Pivotal Greenplum Command Center End User License Agreement? Yy/Nn (Default=Y)
Y Where would you like to install Greenplum Command Center? (Default=/usr/local)
/home/gpadmin/greenplum-web Path not exist, create it? Yy/Nn (Default=Y)
y What would you like to name this installation of Greenplum Command Center? (Default=gpcc) What port would you like gpcc webserver to use? (Default=) Would you like to enable kerberos? Yy/Nn (Default=N) Would you like enable SSL? Yy/Nn (Default=N) Please choose a display language (Default=English)
. English
. Chinese // :: GPCC [version 4.6.] may not be fully compatible with GPDB [installed version 5.16].
Please reference the version compatibility in the GPCC documentation (gpcc.docs.pivotal.io/) Installation in progress...
// ::
Successfully installed Greenplum Command Center.
gpscp -h greenplum02 $MASTER_DATA_DIRECTORY/pg_hba.conf =:$MASTER_DATA_DIRECTORY/
gpscp -h greenplum02 ~/.pgpass =:~/

  04,查看

[gpadmin@greenplum01 greenplum-cc-web-4.6.-LINUX-x86_64]$ psql -d 'gpperfmon' -c 'select * from system_now;' ctime | hostname | mem_total | mem_used | mem_actual_used | mem_actual_free | swap_total | swap_used | swap_
page_in | swap_page_out | cpu_user | cpu_sys | cpu_idle | load0 | load1 | load2 | quantum | disk_ro_rate | di
sk_wo_rate | disk_rb_rate | disk_wb_rate | net_rp_rate | net_wp_rate | net_rb_rate | net_wb_rate
-------+----------+-----------+----------+-----------------+-----------------+------------+-----------+------
--------+---------------+----------+---------+----------+-------+-------+-------+---------+--------------+---
-----------+--------------+--------------+-------------+-------------+-------------+-------------
( rows) [gpadmin@greenplum01 greenplum-cc-web-4.6.-LINUX-x86_64]$

二,配置环境变量

  01,所有机器:

.bash_profile里面添加

source /home/gpadmin/greenplum-web/greenplum-cc-web-4.6./gpcc_path.sh
然后
source .bashrc

  02,启动服务

gpcc start

添加允许客户端

host     all         gpmon        192.168.0.221/     md5

  03,访问

账号:gpmon 密码123456

 常用:

 

 gpstart 默认安装完成会自动开启,启动数据库

 gpstate{-f 查看standby状态} 查看数据库状态

 gpstop 关闭数据库

 psql -l 列出所有数据库

 gpstop -M fast 快速关闭

 gpstop –r 重启

 gpstop –u 重新加载配置文件

 createdb -p  -e -U gpadmin dbname 创建数据库

 gpconfig -c 参数名称 -v 参数值(若果master和segment不一样,name在后面指定-m master参数值) 批量修改系统配置文件参数
 alter role gpadmin with password '123456'; --户名创建密码

 select * from gp_segment_configuration; --查看segment配置

 select * from pg_filespace_entry; --查看文件系统

 \d+ <tablename> --查看表结构

 \dt --显示表

 \l --显示数据库

 \q 退出

  

最新文章

  1. ecshop二次开发 商品分类描述编辑框
  2. JAVA 设计模式 桥接模式
  3. UVA-11517 Exact Change(DP)
  4. Android开发-mac上使用三星S3做真机调试
  5. BZOJ 2190: [SDOI2008]仪仗队
  6. HDU4288 Coder(线段树)
  7. [51NOD1024] 矩阵中不重复的元素(数学,精度)
  8. C语言基础:进制转换,变量,常量,表达式,基本数据类型,输出函数,输入函数,运算符. 分类: iOS学习 c语言基础 2015-06-10 21:39 25人阅读 评论(0) 收藏
  9. CentOS配置网卡,重启网络显示:Device does not seem to be present(转载)
  10. .net framework 源码调试 与 问题解决
  11. Java基础知识强化之IO流笔记08:异常的注意事项
  12. Android学习笔记(一)开发环境搭建
  13. 保存数据到sdcard中去
  14. Code Review 程序员的寄望与哀伤【转载】
  15. mysql数据库在Linux下安装与配置
  16. passat product list
  17. Linux下终端录制工具-asciinema
  18. Codeforces Beta Round #94 (Div. 1 Only)B. String sam
  19. c# ref与out用法
  20. .net的架构模式

热门文章

  1. 编写高质量代码改善C#程序的157个建议——建议31:在LINQ查询中避免不必要的迭代
  2. 编写高质量代码改善C#程序的157个建议——建议5: 使用int?来确保值类型也可以为null
  3. vmware10安装Arch
  4. Spring Websocket与sockJS结合实现
  5. 尝鲜.net core2.1 ——编写一个global tool
  6. Header Only Library
  7. Math对象的使用
  8. ASP.Net UpdatePanel控件 局部刷新 &amp;&amp; 弹出提示信息
  9. WinForm中DataGridView的使用(三) - 各种事件
  10. .Net Core .Net Core V1.0 创建MVC项目