OSVersionBuildLink
Redhat 616.18170622deepgreendb.16.18.rh6.x86_64.170622.bin
Ubuntu 1416.18170622deepgreendb.16.18.ubuntu14.x86_64.170622.bin
Redhat 616.17170523deepgreendb.16.17.rh6.x86_64.170523.bin
Ubuntu 1416.17170523deepgreendb.16.17.ubuntu14.x86_64.170523.bin


Install

The file you downloaded is a .bin file that can be executed directly with bash.

Execute the .bin script to install Deepgreen DB:

% bash THE-BIN-FILE-YOU-DOWNLOADED

The installation script will install the Deepgreen DB in the current directory and create a simple symlink deepgreendb to point to it.



Initializing the DB

To verify that the installation was successful, we will create an instance and start the service.

% # Source the env
% source deepgreendb/greenplum_path.sh

% # Create data directories for master and 2 segments
% sudo mkdir /dbfast{0,1,2}
% sudo chown $USER /dbfast{0,1,2}

% # Create the hostfile
% echo localhost > hostfile

% # Create cluster.conf file
% cat > cluster.conf <<<HEREHERE

# Set this to anything you like
ARRAY_NAME="mpp1 cluster"
CLUSTER_NAME="mpp1 cluster"

# This file must exist in the same directory that you execute gpinitsystem in
MACHINE_LIST_FILE=hostfile

# This names the data directories for the Segment Instances and the Entry Postmaster
SEG_PREFIX=dg

# Prefix for script created database
DATABASE_PREFIX=dg

# This is the port at which to contact the resulting Greenplum database, e.g.
#   psql -p $PORT_BASE -d template1
PORT_BASE=25432


# Array of data locations for each hosts Segment Instances, the number of directories in this array will
# set the number of segment instances per host
declare -a DATA_DIRECTORY=(/dbfast1 /dbfast2)

# Name of host on which to setup the QD
MASTER_HOSTNAME=localhost

# Name of directory on that host in which to setup the QD
MASTER_DIRECTORY=/dbfast0
MASTER_PORT=15432

# Hosts to allow to connect to the QD (and Segment Instances)
# By default, allow everyone to connect (0.0.0.0/0)
IP_ALLOW=0.0.0.0/0

# Shell to use to execute commands on all hosts
TRUSTED_SHELL=/usr/bin/ssh

CHECK_POINT_SEGMENTS=8

ENCODING=UNICODE

export MASTER_DATA_DIRECTORY
export TRUSTED_SHELL

# Keep max_connection settings to reasonable values for
# installcheck good execution.

DEFAULT_QD_MAX_CONNECT=25
QE_CONNECT_FACTOR=5

HEREHERE

% # Finally, run gpinitsystem 
% gpinitsystem -c cluster.conf -h hostfile



Run Some Tests

Now we can have some fun!

% # Source the env if this is a new shell
% source deepgreendb/greenplum_path.sh

% # We set up the DB on port 15432
% export PGPORT=15432

% # Create Test DB
% createdb test

% psql test
test=# create table tt as
    select i::bigint as i, i::double precision as f
    from generate_series(1, 1000000) i
    distributed by (i);
SELECT 1000000
test=# show vitesse.version;
                vitesse.version                 
------------------------------------------------
 Deepgreen DB 16.05 [rev 2c302da on 2016-05-08]
(1 row)

test=# \timing on 
Timing is on.
test=# set vitesse.enable=0;
SET
Time: 1.799 ms
test=# select count(*), sum(i), avg(i) from tt;
  count  |     sum      |   avg    
---------+--------------+----------
 1000000 | 500000500000 | 500000.5
(1 row)

Time: 439.994 ms 
test=# set vitesse.enable=1;
SET
Time: 1.814 ms
test=# select count(*), sum(i), avg(i) from tt;
  count  |     sum      |   avg    
---------+--------------+----------
 1000000 | 500000500000 | 500000.5
(1 row)

Time: 16.965 ms
test=# select 439/17;
 ?column? 
----------
       25
(1 row)

Time: 2.577 ms
test=#