Skip to main content

Compile and Install Cloudberry Database on Linux


The source of this document is from the GitHub repository cloudberrydb/cloudberrydb.

This document shares how to compile and install Cloudberry Database on Linux systems (CentOS 7, RHEL, and Ubuntu). Note that this document is for developers to try out Cloudberry Database in a single-node environments. DO NOT use this document for production environments.

Take the following steps to compile and install Cloudberry Database:

  1. Clone GitHub repo.
  2. Install dependencies.
  3. Perform prerequisite platform tasks.
  4. Build Cloudberry Database.
  5. Verify the cluster.

Step 1. Clone GitHub repo

Clone the GitHub repository cloudberrydb/cloudberrydb to the target machine:

git clone

Step 2. Install dependencies

Enter the repository and install dependencies according to your operating systems:

The following steps work on CentOS 7. For other CentOS versions, these steps might work but are not guaranteed to work.

  1. Run the Bash script README.CentOS.bash in the readmes directory of the cloudberrydb/cloudberrydb repository. To run this script, password is required. Then, some required dependencies will be automatically downloaded.

    cd cloudberrydb/readmes
  2. Install additional packages required for configurations.

    yum -y install R apr apr-devel apr-util automake autoconf bash bison bison-devel bzip2 bzip2-devel centos-release-scl curl flex flex-devel gcc gcc-c++ git gdb iproute krb5-devel less libcurl libcurl-devel libevent libevent-devel libxml2 libxml2-devel libyaml libzstd-devel libzstd make openldap openssh openssh-clients openssh-server openssl openssl-devel openssl-libs perl python3-devel readline readline-devel rsync sed sudo tar vim wget which xerces-c-devel zip zlib && \
    yum -y install epel-release
  3. Update the GNU Compiler Collection (GCC) to version devtoolset-10 to support C++ 14.

    yum install centos-release-scl 
    yum -y install devtoolset-10-gcc devtoolset-10-gcc-c++ devtoolset-10-binutils
    scl enable devtoolset-10 bash
    source /opt/rh/devtoolset-10/enable
    echo "source /opt/rh/devtoolset-10/enable" >> /etc/bashrc
    source /etc/bashrc
    gcc -v
  4. Link cmake3 to cmake:

    sudo ln -sf /usr/bin/cmake3 /usr/local/bin/cmake

Step 3. Perform prerequisite platform tasks

After you have installed all the dependencies for your operating system, it is time to do some prerequisite platform tasks before you go on building Cloudberry Database. These operation include manually running ldconfig on all platforms, creating the gpadmin user, and setting up a password to start the Cloudberry Database and test.

  1. Make sure that you add /usr/local/lib and /usr/local/lib64 to the /etc/ file.

    echo -e "/usr/local/lib \n/usr/local/lib64" >> /etc/
  2. Create the gpadmin user and set up the SSH key. Manually create SSH keys based on different operating systems, so that you can run ssh localhost without a password.

    useradd gpadmin  # Creates gpadmin user
    su - gpadmin # Uses the gpadmin user
    ssh-keygen # Creates SSH key
    cat ~/.ssh/ >> ~/.ssh/authorized_keys
    chmod 600 ~/.ssh/authorized_keys

Step 4. Build Cloudberry Database

After you have installed all the dependencies and performed the prerequisite platform tasks, you can start to build Cloudberry Database. Run the following commands in sequence.

  1. Configure the build environment. Enter the cloudberrydb directory and run the configure script.

    cd cloudberrydb
    ./configure --with-perl --with-python --with-libxml --with-gssapi --prefix=/usr/local/cloudberrydb

    Cloudberry Database is built with GPORCA by default. If you want to build CBDB without GPORCA, add the --disable-orca flag in the ./configure command.

    ./configure --disable-orca --with-perl --with-python --with-libxml --prefix=/usr/local/cloudberrydb
  2. Compile the code and install the database.

    make -j8
    make -j8 install
  3. Bring in the Greenplum environment for your running shell.

    cd ..
    cp -r cloudberrydb/ /home/gpadmin/
    cd /home/gpadmin/
    chown -R gpadmin:gpadmin cloudberrydb/
    su - gpadmin
    cd cloudberrydb/
    source /usr/local/cloudberrydb/
  4. Start the demo cluster.

    scl enable devtoolset-10 bash 
    source /opt/rh/devtoolset-10/enable
    make create-demo-cluster
  5. Prepare the test by running the following command. This command will configure the port and environment variables for the test.

    Environment variables such as PGPORT and COORDINATOR_DATA_DIRECTORY will be configured, which are the default port and the data directory of the coordinator node.

    source gpAux/gpdemo/

Step 5. Verify the cluster

  1. You can verify whether the cluster has started successfully by running the following command. If successful, you might see multiple active postgres processes with ports ranging from 7000 to 7007.

    ps -ef | grep postgres
  2. Connect to the Cloudberry Database and see the active segment information by querying the system table gp_segement_configuration. For detailed description of this table, see the Greenplum document here.

    $ psql -p 7000 postgres
    psql (14.4, server 14.4)
    Type "help" for help.

    postgres=# select version();
    PostgreSQL 14.4 (Cloudberry Database 1.0.0+1c0d6e2224 build dev) on x86_64( GCC 13.2.0) 13.2.0, 64-bit compiled on Sep 22 2023 10:56:01
    (1 row)

    postgres=# select * from gp_segment_configuration;
    dbid | content | role | preferred_role | mode | status | port | hostname | address | datadir | warehouseid
    1 | -1 | p | p | n | u | 7000 | i-6wvpa9wt | i-6wvpa9wt | /home/gpadmin/cloudberrydb/gpAux/gpdemo/datadirs/qddir/demoDataDir-1 | 0
    8 | -1 | m | m | s | u | 7001 | i-6wvpa9wt | i-6wvpa9wt | /home/gpadmin/cloudberrydb/gpAux/gpdemo/datadirs/standby | 0
    3 | 1 | p | p | s | u | 7003 | i-6wvpa9wt | i-6wvpa9wt | /home/gpadmin/cloudberrydb/gpAux/gpdemo/datadirs/dbfast2/demoDataDir1 | 0
    6 | 1 | m | m | s | u | 7006 | i-6wvpa9wt | i-6wvpa9wt | /home/gpadmin/cloudberrydb/gpAux/gpdemo/datadirs/dbfast_mirror2/demoDataDir1 | 0
    2 | 0 | p | p | s | u | 7002 | i-6wvpa9wt | i-6wvpa9wt | /home/gpadmin/cloudberrydb/gpAux/gpdemo/datadirs/dbfast1/demoDataDir0 | 0
    5 | 0 | m | m | s | u | 7005 | i-6wvpa9wt | i-6wvpa9wt | /home/gpadmin/cloudberrydb/gpAux/gpdemo/datadirs/dbfast_mirror1/demoDataDir0 | 0
    4 | 2 | p | p | s | u | 7004 | i-6wvpa9wt | i-6wvpa9wt | /home/gpadmin/cloudberrydb/gpAux/gpdemo/datadirs/dbfast3/demoDataDir2 | 0
    7 | 2 | m | m | s | u | 7007 | i-6wvpa9wt | i-6wvpa9wt | /home/gpadmin/cloudberrydb/gpAux/gpdemo/datadirs/dbfast_mirror3/demoDataDir2 | 0
    (8 rows)