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 from the official APT repository.

NOTE

Starting with version 7.5.0, Greengage DB packages are available through the official APT repository. 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

  4. Update package metadata:

    $ sudo apt update

  5. Install Greengage DB:

    $ sudo apt install greengage7

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

    The following additional packages will be installed:
  libapr1 libevent-2.1-7 libllvm14 libpq5 libxerces-c3.2 net-tools python3-psutil python3-psycopg2 unzip zip
Suggested packages:
  python-psutil-doc python-psycopg2-doc
The following NEW packages will be installed:
  greengage7 libapr1 libevent-2.1-7 libllvm14 libpq5 libxerces-c3.2 net-tools python3-psutil python3-psycopg2 unzip zip
0 upgraded, 11 newly installed, 0 to remove and 44 not upgraded.
Need to get 52.0 MB of archives.
After this operation, 196 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 greengage7

    The result should look as follows:

    ii  greengage7       7.5.0         amd64        Greengage MPP database engine

  2. Check the installation paths:

    $ dpkg -L greengage7

    The output lists all files installed by the package:

    /.
/opt
/opt/greengagedb
/opt/greengagedb/greengage7
/opt/greengagedb/greengage7/bin
/opt/greengagedb/greengage7/bin/analyzedb
/opt/greengagedb/greengage7/bin/clusterdb
/opt/greengagedb/greengage7/bin/createdb
/opt/greengagedb/greengage7/bin/createuser
...

    Some of the key directories:

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

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

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

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

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

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