Open search page
Hello, I’m DocuDroid!
Open Ask AI page
Submitting feedback
Thank you for rating our AI Search!
We would be grateful if you could share your thoughts so we can improve our AI Search for you and other readers.
GitHub

Install Greengage DB from a package

Andrey Aksenov

This guide explains how to install Greengage DB from a .deb package on Ubuntu 22.04.

NOTE

Debian packages are available starting with version 6.29.2 on the GitHub Releases page. Corresponding .ddeb packages with debugging symbols are also provided.

Prerequisites

Before installing Greengage DB, ensure that the host meets all requirements described in Pre-installation configuration.

Download the package

  1. Make sure you are logged in as a user with sudo privileges.

  2. Download the Greengage DB .deb package from the GitHub Releases page:

    $ wget <download_address>

    Example:

    $ wget https://github.com/GreengageDB/greengage/releases/download/6.30.1/greengage6.deb

Install the package

  1. Install the package using apt, which automatically resolves and installs all required dependencies:

    $ sudo apt install ./greengage<version>.deb

    Example:

    $ sudo apt install ./greengage6.deb

  2. Type Y and press Enter when prompted with the following message:

    The following additional packages will be installed:
  libapr1 libevent-2.1-7 libpython2-stdlib libpython2.7 libpython2.7-minimal libpython2.7-stdlib libxerces-c3.2 net-tools python2 python2-minimal python2.7 python2.7-minimal unzip zip
Suggested packages:
  python2-doc python-tk python2.7-doc binfmt-support
The following NEW packages will be installed:
  greengage libapr1 libevent-2.1-7 libpython2-stdlib libpython2.7 libpython2.7-minimal libpython2.7-stdlib libxerces-c3.2 net-tools python2 python2-minimal python2.7 python2.7-minimal unzip zip
0 upgraded, 15 newly installed, 0 to remove and 1 not upgraded.
Need to get 6915 kB/18.4 MB of archives.
After this operation, 72.6 MB of additional disk space will be used.
Do you want to continue? [Y/n]

  3. Verify that the package has been installed successfully:

    $ dpkg -l | grep greengage

    The result should look as follows:

    ii  greengage        6.30.1        amd64        Greengage MPP database engine

  4. Check the installation paths:

    $ dpkg -L greengage

    The output lists all files installed by the package:

    /.
/opt
/opt/greengagedb
/opt/greengagedb/greengage
/opt/greengagedb/greengage/bin
/opt/greengagedb/greengage/bin/analyzedb
/opt/greengagedb/greengage/bin/clusterdb
/opt/greengagedb/greengage/bin/createdb
/opt/greengagedb/greengage/bin/createlang
/opt/greengagedb/greengage/bin/createuser
...

    Some of the key directories:

    • /opt/greengagedb/greengage/bin — executable binaries and command-line tools.

    • /opt/greengagedb/greengage/include — C header files for Greengage DB.

    • /opt/greengagedb/greengage/lib — Greengage DB and PostgreSQL library files.

    • /opt/greengagedb/greengage/sbin — supporting/internal scripts and programs.

    • /opt/greengagedb/greengage/share — shared files.

Create a symlink to Python 2

Create a symbolic link from python2 to /usr/bin/python:

$ sudo ln -s python2 /usr/bin/python

Set the Greengage DB path

  1. Switch to the gpadmin user:

    $ sudo su - gpadmin

  2. Set the Greengage DB path and environment variables as follows:

    $ source /opt/greengagedb/greengage/greengage_path.sh
    NOTE

    Add the above source command to the gpadmin user’s shell startup file (for example, .bashrc). This ensures that the Greengage DB path and environment variables are set each time you log in as gpadmin.

Set up a demo cluster

Once Greengage DB is installed, you can proceed to Set up a Greengage DB demo cluster to create a demo environment for testing and exploring DBMS features.

Previous
Pre-installation configuration
Next
Build from source code