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 on Ubuntu 22.04 or 24.04 from the official APT repository.

NOTE

Starting with version 6.31.0, Greengage DB packages are available through the official APT repository. For earlier versions starting from 6.29.2, .deb packages are available on the GitHub Releases page. Corresponding packages with debugging symbols are also provided.

Prerequisites

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

Install Greengage DB

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

  2. Import the Greengage DB repository signing key:

    $ curl -fsSL https://greengagedb.org/repositories/gpg \
  | sudo gpg --dearmor -o /etc/apt/keyrings/greengagedb.gpg

  3. Add the Greengage DB APT repository:

    $ echo 'deb [signed-by=/etc/apt/keyrings/greengagedb.gpg] https://greengagedb.org/repositories/ubuntu/22.04/x86_64 greengagedb main' \
  | sudo tee /etc/apt/sources.list.d/greengagedb.list
    $ echo 'deb [signed-by=/etc/apt/keyrings/greengagedb.gpg] https://greengagedb.org/repositories/ubuntu/24.04/x86_64 greengagedb main' \
  | sudo tee /etc/apt/sources.list.d/greengagedb.list

  4. Update package metadata:

    $ sudo apt update

  5. Install Greengage DB:

    $ sudo apt install greengage6

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

    The following additional packages will be installed:
  libapr1t64 libaprutil1t64 libevent-2.1-7t64 libxerces-c3.2t64 net-tools python-is-python3 sigar unzip zip
The following NEW packages will be installed:
  greengage6 libapr1t64 libaprutil1t64 libevent-2.1-7t64 libxerces-c3.2t64 net-tools python-is-python3 sigar unzip zip
0 upgraded, 10 newly installed, 0 to remove and 14 not upgraded.
Need to get 13.5 MB of archives.
After this operation, 53.8 MB of additional disk space will be used.
Do you want to continue? [Y/n]

Verify the installation

  1. Verify that the package has been installed successfully:

    $ dpkg -l | grep greengage6

    The result should look as follows:

    ii  greengage6       6.31.0        amd64        Greengage MPP database engine

  2. Check the installation paths:

    $ dpkg -L greengage6

    The output lists all files installed by the package:

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

    Some of the key directories:

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

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

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

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

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

Create a symlink to Python 2 (Ubuntu 22.04)

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/greengage6/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