Sunday, January 20, 2013

0 Greenplum VM: Jump start with Greenplum

Greenplum is the highly customize version  of PostgreSQL with many add-in features. EMC has made the VM image available for developer to taste the Greenplum without complicating steps of the installation. 

The VM image is base on Centos  with Greenplum 4.0.

 

Software

 

Import the VM image

Download the VM image and untar, uncompressed it.

File –> Open

image

Select the vm file.

image

I choice the “I copied it”

image

image

The password for various account is in the file “login.info”.

 

Operating System:
------------------
gpadmin / password
root / password
 
 
Greenplum Database:
-------------------
gpadmin / password
 
 
Greenplum Performance Monitor:
-----------------------------
gpmon / password

Fix the sbin not in the PATH

Somehow the sbin is not in the user path. therefore many of the system command can not be used, such as ifconfig. I fix it by edit the /etc/profile.

export PATH="$PATH:/sbin"

The file is only updatable by root. After editing the file, we need to reboot the host.

 

Greenplum database does not start .

use gpstart to start up the greenplum

gpstart

image

image

 

Fix the GP monitor

Reinstall the GP monitor with below command.

 gpperfmon_install --enable --password password --port 5432 --verbose 

 

image

Bounce the greenplum and gpmonitor

gpstop -r
gpperfmon --start postgres

We can then verify whether gpperfmon is started

 psql gpperfmon -c 'SELECT * FROM system_now;'

image

Login into the gpmon website: https://gp-single-host:28080/

image

image

 

Now you are ready to taste the Greenplum

Reference:

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates