This document guides you on how to quickly set up and connect to a single-node Apache Cloudberry in a Docker environment. You can try out Apache Cloudberry by performing some basic operations and running SQL commands.
This guide is intended for testing or development. DO NOT use it for production.
Prerequisites
Make sure that your environment meets the following requirements:
- Platform requirement: Any platform with Docker runtime. For details, refer to Get Started with Docker.
- Other dependencies: Git, SSH, and internet connection
Build the Sandbox
This section introduces how to set up the Docker container in which the source code of Apache Cloudberry v1.5.1 (released in Apache Cloudberry Release Page) will be compiled. In this CentOS 7.9 Docker container, a single-node cluster will be initialized with one coordinator and two segments. Both x86 and ARM CPUs (including Apple chips) are supported.
Build steps:
-
Start Docker Desktop and make sure it is running properly on your host platform.
-
Download this repository (which is apache/cloudberry-bootcamp) to the target machine.
git clone https://github.com/apache/cloudberry-bootcamp.git
-
Enter the repository and run the
run.sh
script to start the Docker container. This will start the automatic installation process.cd bootcamp/000-cbdb-sandbox
chmod +x ./run.sh
sudo ./run.shOnce the script finishes without error, the sandbox is built successfully.
Connect to the database
You can now connect to the database and try some basic operations.
-
Connect to the Docker container from the host machine:
docker exec -it $(docker ps -q) /bin/bash
If it is successful, you will see the following prompt:
[root@mdw /]$
-
Log into Apache Cloudberry in Docker. See the following commands and example outputs:
[root@mdw /] su - gpadmin # Switches to the gpadmin user.
# Last login: Tue Oct 24 10:26:14 CST 2023 on pts/1
[gpadmin@mdw ~]$ psql # Connects to the database with the default database name "gpadmin".
# psql (14.4, server 14.4)
# Type "help" for help.gpadmin=# SELECT VERSION(); -- Checks the database version.
version
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----
PostgreSQL 14.4 (Apache Cloudberry 1.0.0 build dev) on aarch64-unknown-linux-gnu, compiled by gcc (GCC) 10.2.1 20210130 (Red Hat 10.2.1-11), 64-bit compiled on Oct 24 2023 10:24:28
(1 row)
In addition to using the docker exec
command, you can also use the ssh
command. This command will connect to the database with the default database name gpadmin
:
ssh gpadmin@localhost # Password: cbdb@123
Now you have a Apache Cloudberry and can continue with 101 Apache Cloudberry Tutorials! Enjoy!