2ndQuadrant is now part of EDB

Bringing together some of the world's top PostgreSQL experts.

2ndQuadrant | PostgreSQL
Mission Critical Databases
  • Contact us
  • EN
    • FR
    • IT
    • ES
    • DE
    • PT
  • Support & Services
  • Products
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
  • Postgres Learning Center
    • Webinars
      • Upcoming Webinars
      • Webinar Library
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Blog
    • Training
      • Course Catalogue
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Books
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2nd Edition
      • PostgreSQL 9 Administration Cookbook – 3rd Edition
      • PostgreSQL Server Programming Cookbook – 2nd Edition
      • PostgreSQL 9 Cookbook – Chinese Edition
    • Videos
    • Events
    • PostgreSQL
      • PostgreSQL – History
      • Who uses PostgreSQL?
      • PostgreSQL FAQ
      • PostgreSQL vs MySQL
      • The Business Case for PostgreSQL
      • Security Information
      • Documentation
  • About Us
    • About 2ndQuadrant
    • 2ndQuadrant’s Passion for PostgreSQL
    • News
    • Careers
    • Team Profile
  • Blog
  • Menu Menu
You are here: Home1 / Blog2 / Greenplum3 / How to test Greenplum Community Edition 4.2.1 on VirtualBox
Marco Nenciarini

How to test Greenplum Community Edition 4.2.1 on VirtualBox

August 10, 2012/2 Comments/in Greenplum /by Marco Nenciarini

As usual Greenplum Community Edition 4.2.1 is available as a VMWare virtual machine based on CentOS with all the fancy tools and the documentation already installed. This allows you to easily try it.
This article is an updated guide about running the provided image on VirtualBox.

Assuming you already have VirtualBox installed (if not you can install it from your package manager or download it from http://www.virtualbox.org/), you can download the VMWare image for Greenplum from http://www.greenplum.com/community/downloads/database-ce/.

As first step extract the Greenplum Virtual Machine in a convenient place. For this tutorial I’ve chosen the $HOME/gp directory.

First create a new virtual machine, by clicking “New” and then following the wizard for the creation procedure.
Give a name to the machine and choose “Linux” as operating system and Red Hat 64-bit as version.

When you are asked about memory allocation give it at least 3000MB if you can. If you cannot afford it, you can lower this value a bit, but you should give it at least 1024MB.

In the next screen simply deselect the “Start-up Disk” check-box and choose Next.

A warning about the lack of a primary hard disk will be displayed, but the disk will be added manually in the next step. So press the
“Continue” button.

A summary will be displayed and the “Create” button will complete the creation of the virtual machine.

Now open the settings area of your freshly baked virtual machine. Select the “Storage” section and add a new hard disk to the IDE controller, by clicking on the “+” sign.
Click on “Choose disk” button and select the VMWare hard disk image. Select the first file of the series, named “CentOS 64-bit-cl1.vmdk”.

At this point the virtual machine is ready to be started, so start it.

I’ve also prepared a little script that automates the process up to here. To use it, put it in the same directory of the gpdb421ee.tar.gz and start it.
[bash]
#!/bin/bash

set -e
DEST=$PWD
TAR=$PWD/gpdb421ee.tar.gz
VM=”Greenplum 4.2.1.0″
MEM=3000

cd “${DEST}”
tar zxf “${TAR}”

VMX=$(ls “${DEST}”/*/*.vmx)
VMX_DIR=”${VMX%/*}”
DISK_FILE=$(sed -n ‘
/scsi0:0.fileName/{
s/^.*=[[:space:]]*//;
s/”\(.*\)”/\1/;
p;
}’ “${VMX}”)
DISK=”${VMX_DIR}/${DISK_FILE}”

VBoxManage createvm –name “${VM}” –ostype RedHat_64 \
–basefolder “${DEST}” \
–register
VBoxManage modifyvm “${VM}” –memory “$MEM”
VBoxManage storagectl “${VM}” –name “IDE Controller” –add ide
VBoxManage storageattach “${VM}” –storagectl “IDE Controller” \
–port 0 –device 0 –type hdd –medium “${DISK}”
VBoxManage storageattach “${VM}” –storagectl “IDE Controller” \
–port 1 –device 0 –type dvddrive –medium emptydrive
VBoxManage startvm “${VM}”
[/bash]

At first, it won’t work, as X will search the VWMare graphic card. So you will see a blue error screen asking you if you want to display the Xorg log file to diagnose the problem. Select “No”. When asked if you want to reconfigure the X server select “No”.

At the shell login prompt type root as user and password as password.

As the first thing to do we need to remove VMWare from this VM.

If you don’t feel comfortable with the US keyboard layout you can change it with the command “loadkeys COUNTRYCODE” (for example, to load the Italian keyboard layout type “loadkeys it”).

Now it’s time to uninstall the VMWare drivers by running vmware-uninstall-tools.pl utility.

[bash]
vmware-uninstall-tools.pl
[/bash]

We also have to install the VirtualBox drivers, but they will not compile with the current kernel, so we have to update it.

[bash]
yum install kernel kernel-devel
[/bash]

Before reboot with the new kernel I suggest to make another little adjustment.
To greatly shorten the boot time of this VM you have to add ‘localhost.localdomain’ as first value of line referring to 127.0.0.1 in /etc/hosts.
You can do it with your favorite editor or running the the following command:

[bash]
sed -i ‘s/localhost /localhost.localdomain localhost /’ /etc/hosts
[/bash]

Now reboot.

Login once again as root (you might have to answer to the same questions and setup your keyboard again), so that you can now install VirtualBox drivers.
From the VirtualBox window, select “Install Guest Additions” under the “Devices” menu. Then, go back to your root shell and type:

[bash]
mount /dev/cdrom /mnt
sh /mnt/VBoxLinuxAdditions.run
umount /mnt
eject /dev/cdrom
[/bash]

Reboot again.

Your system is now ready for testing and getting started with Greenplum.

We remind you that this article is solely intended for evaluation purposes of the community edition of Greenplum and its main features.
If you want to evaluate performance of Greenplum, we recommend you to install Greenplum on physical servers with good disk I/O performance and CPU power.

I finally would like to thank Giulio Calacoci who wrote a similar guide last year – on which this guide is based.

Tags: greenplum, greenplum ce, virtual machine, virtualbox
Share this entry
  • Share on Facebook
  • Share on Twitter
  • Share on WhatsApp
  • Share on LinkedIn
2 replies
  1. Hans Castorp
    Hans Castorp says:
    November 19, 2012 at 7:33 pm

    I can not find any download for a VMWare image. Only native installers for Unix systems (none for Windows)

    Reply
  2. Manish
    Manish says:
    January 7, 2013 at 12:38 pm

    Thanks a lot Marco. You really saved me a lot of effort.

    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Get in touch with us!

Recent Posts

  • Random Data December 3, 2020
  • Webinar: COMMIT Without Fear – The Beauty of CAMO [Follow Up] November 13, 2020
  • Full-text search since PostgreSQL 8.3 November 5, 2020
  • Random numbers November 3, 2020
  • Webinar: Best Practices for Bulk Data Loading in PostgreSQL [Follow Up] November 2, 2020

Featured External Blogs

Tomas Vondra's Blog

Our Bloggers

  • Simon Riggs
  • Alvaro Herrera
  • Andrew Dunstan
  • Craig Ringer
  • Francesco Canovai
  • Gabriele Bartolini
  • Giulio Calacoci
  • Ian Barwick
  • Marco Nenciarini
  • Mark Wong
  • Pavan Deolasee
  • Petr Jelinek
  • Shaun Thomas
  • Tomas Vondra
  • Umair Shahid

PostgreSQL Cloud

2QLovesPG 2UDA 9.6 backup Barman BDR Business Continuity community conference database DBA development devops disaster recovery greenplum Hot Standby JSON JSONB logical replication monitoring OmniDB open source Orange performance PG12 pgbarman pglogical PG Phriday postgres Postgres-BDR postgres-xl PostgreSQL PostgreSQL 9.6 PostgreSQL10 PostgreSQL11 PostgreSQL 11 PostgreSQL 11 New Features postgresql repmgr Recovery replication security sql wal webinar webinars

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR®

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

© 2ndQuadrant Ltd. All rights reserved. | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Barman is finally out Management of the WAL archive in Barman
Scroll to top
×