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
- Greenplum VM image:
- VMWare
Import the VM image
Download the VM image and untar, uncompressed it.
File –> Open
Select the vm file.
I choice the “I copied it”
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
Fix the GP monitor
Reinstall the GP monitor with below command.
gpperfmon_install --enable --password password --port 5432 --verbose
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;'
Login into the gpmon website: https://gp-single-host:28080/
Now you are ready to taste the Greenplum
0 comments:
Post a Comment