Build Greengage DB from the source code

Andrey Aksenov

Contents

Prerequisites
Configure an operating system
Create the Greengage DB administrative user
- Enable passwordless SSH
Clone the Greengage DB repository
Install the dependencies
Build and install Greengage DB
Create a demo cluster

This topic describes how to build Greengage DB (based on Greenplum Database) on Linux operating systems and run a demo cluster. The source code for Greengage DB is available in the greengage repository. This repository also includes scripts to help you install the dependencies required to build Greengage DB on the required platform.

To follow the steps described in this document, you need one of the following operating systems:

Ubuntu.
Rocky Linux.

For both operating systems, make sure you have git installed.

First, you need to customize some of the operating system parameters to ensure a demo Greengage DB cluster can operate correctly.

Open the /etc/selinux/config file for editing:
```
$ sudo vi /etc/selinux/config
```
Set the SELINUX parameter to disabled to turn SELinux off:
```
SELINUX=disabled
```
Save and close the file.
Reboot the system to apply the changes.

Open the /etc/sysctl.conf file for editing:
```
$ sudo vi /etc/sysctl.conf
```

Specify the following parameters:

vm.overcommit_memory = 2
vm.overcommit_ratio = 95
net.ipv4.ip_local_port_range = 12000 65535
kernel.sem = 250 2048000 200 8192

Save and close the file.
To apply the changes, run the sysctl command:
```
$ sudo sysctl --system
```

Open the /etc/security/limits.conf file:
```
$ sudo vi /etc/security/limits.conf
```

Specify the following options for the gpadmin user:

gpadmin soft nofile 524288
gpadmin hard nofile 524288
gpadmin soft nproc 150000
gpadmin hard nproc 150000

gpadmin is created in the next section.

Save and close the file.

You need to create a system user account used to run and administer Greengage DB and generate an SSH key pair for this account. To do this, follow the steps in Create the Greengage DB administrative user. Then, you need to enable passwordless SSH for this user, as described below.

Add the content of the generated public key to the authorized_keys file:
```
$ cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
```
Change the permissions of the authorized_keys file as follows:
```
$ chmod 600 ~/.ssh/authorized_keys
```

NOTE

Use the ssh <hostname> command to verify the ability to connect to the current host using SSH without a password.

Ensure you are logged in as gpadmin and in the home directory.

Clone the greengage repository:

$ git clone --recurse-submodules https://github.com/GreengageDB/greengage.git

Change the current directory to greengage:
```
$ cd greengage
```
Check out the required tag, for example:
```
$ git checkout tags/7.4.0
```

Install the dependencies required to build Greengage DB on different operating systems.

Ubuntu

Execute the README.Ubuntu.bash script to install the dependencies:

$ sudo ./README.Ubuntu.bash

Rocky Linux

Execute the README.Rhel-Rocky.bash script to install the dependencies:

$ sudo ./README.Rhel-Rocky.bash

Change the current directory to greengage:
```
$ cd ~/greengage
```

Configure the build environment as follows to build Greengage DB:

$ ./configure \
  --with-perl \
  --with-python \
  --with-libxml \
  --with-uuid=e2fs \
  --with-openssl \
  --with-gssapi \
  --with-ldap \
  --enable-ic-proxy \
  --enable-orafce \
  --prefix=/usr/local/gpdb

NOTE

To see all the available build options, run ./configure --help.

Compile Greengage DB using make:
```
$ make -j$(nproc)
```
If the compilation is finished successfully, the output should contain this information:
```
...
All of Greengage Database successfully made. Ready to install.
```
Install Greengage DB using make install:
```
$ sudo make -j$(nproc) install
```
If the installation is successful, the output should contain this information:
```
...
Greengage Database installation complete.
```

Change the owner and group of the installed files to gpadmin:

$ sudo chown -R gpadmin:gpadmin /usr/local/gpdb*
$ sudo chgrp -R gpadmin /usr/local/gpdb*

Set the Greengage DB path and environment variables as follows:
```
$ source /usr/local/gpdb/greengage_path.sh
```
NOTE

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

This section shows how to run a demo cluster.

Start a demo cluster by executing the command below:
```
$ make create-demo-cluster
```
After the cluster is initialized and started, source the gpAux/gpdemo/gpdemo-env.sh file to set values of the PGPORT and COORDINATOR_DATA_DIRECTORY environment variables:
```
$ source gpAux/gpdemo/gpdemo-env.sh
```
Check the cluster state to make sure all the instances are up and running:
```
$ gpstate
```

List all cluster databases:

$ psql -l

The result can look like this:

                            List of databases
   Name    |  Owner  | Encoding | Collate |  Ctype  |  Access privileges
-----------+---------+----------+---------+---------+---------------------
 postgres  | gpadmin | UTF8     | C.UTF-8 | C.UTF-8 |
 template0 | gpadmin | UTF8     | C.UTF-8 | C.UTF-8 | =c/gpadmin         +
           |         |          |         |         | gpadmin=CTc/gpadmin
 template1 | gpadmin | UTF8     | C.UTF-8 | C.UTF-8 | =c/gpadmin         +
           |         |          |         |         | gpadmin=CTc/gpadmin
(3 rows)

Connect to the default postgres database:
```
$ psql postgres
```
The output should look like this:
```
psql (12.22)
Type "help" for help.
```
Get the version information about the installed Greengage DB:
```
SELECT version();
```
The output might look like this:

Ubuntu

PostgreSQL 12.22 (Greengage Database 7.4.0 build dev) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04.2) 11.4.0, 64-bit compiled on Nov 26 2025 07:33:50 Bhuvnesh C.

Rocky Linux

PostgreSQL 12.22 (Greengage Database 7.4.0 build dev) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-5), 64-bit compiled on Nov 26 2025 08:50:58 Bhuvnesh C.

Quit your psql session:
```
\q
```
Stop the cluster using the gpstop utility:
```
$ gpstop
```

To start the demo cluster again, use gpstart:

$ gpstart

Pre-installation configuration

Build a Docker image

Build Greengage DB from the source code

Prerequisites

Configure an operating system

Deactivate SELinux (Rocky Linux)

Edit sysctl.conf

Edit limits.conf

Create the Greengage DB administrative user

Enable passwordless SSH

Clone the Greengage DB repository

Install the dependencies

Build and install Greengage DB

Create a demo cluster

Start a demo cluster

Verify the cluster

Stop the cluster