WarehousePG (WHPG) is an advanced, fully featured, open source data warehouse, based on Greenplum® Database and PostgreSQL. WarehousePG provides powerful and rapid analytics on petabyte scale data volumes. Uniquely geared toward big data analytics, WarehousePG is powered by the world’s most advanced cost-based query optimizer delivering high analytical query performance on large data volumes.
The Greenplum Database OSS project was released under the Apache 2 license and went closed source in May 2024.
Follow appropriate Linux steps for getting your system ready.
# Configure build environment to install at /usr/local/whpg ./configure --with-perl --with-python --with-libxml --with-gssapi --prefix=/usr/local/whpg # Compile and install make -j8 make -j8 install # Bring in greenplum environment into your running shell source /usr/local/whpg/greenplum_path.sh # Start demo cluster make create-demo-cluster # (gpdemo-env.sh contains __PGPORT__ and __COORDINATOR_DATA_DIRECTORY__ values) source gpAux/gpdemo/gpdemo-env.sh The directory, the TCP ports, the number of segments, and the existence of standbys for segments and coordinator for the demo cluster can be changed on the fly. Instead of make create-demo-cluster, consider:
DATADIRS=/tmp/whpg-cluster PORT_BASE=5555 NUM_PRIMARY_MIRROR_PAIRS=1 WITH_MIRRORS=false make create-demo-cluster The TCP port for the regression test can be changed on the fly:
PGPORT=5555 make installcheck-world To turn GPORCA off and use Postgres planner for query optimization:
set optimizer=off; If you want to clean all generated files
make distclean Greenplum® is a registered trademark of Broadcom Inc.
EDB and EDB Postgres AI are not affiliated with, endorsed by, or sponsored by Broadcom Inc.
Any references to Greenplum are for comparative, educational, and interoperability purposes only.
WarehousePG is maintained by a core team of developers with commit rights to the main WHPG repository on GitHub. At the same time, we are very eager to receive contributions from anybody in the wider WarehousePG community. This section covers all you need to know if you want to see your code or documentation changes be added to WarehousePG and appear in the future releases.
WarehousePG is developed on GitHub, and anybody wishing to contribute to it will have to have a GitHub account and be familiar with Git tools and workflow.
Once you have your GitHub account, fork this repository so that you can have your private copy to start hacking on and to use as source of pull requests.