wget https://ftp.postgresql.org/pub/source/v16.2/postgresql-16.2.tar.bz2
tar xvf postgresql-16.2.tar.bz2
cd ~/postgresql-16.2/

=== patch things (or copy cpp files)

./configure --prefix=/usr/local/pgsql/16.2 --without-readline --without-icu
make && sudo make install
echo 'export PATH=/usr/local/pgsql/16.2/bin:$PATH' >> ~/.bashrc
source ~/.bashrc


==== if haven’t clone pghintplan
git clone https://github.com/ossc-db/pg_hint_plan.git -b REL16_1_6_0
cd ~/pg_hint_plan
==== if haven’t modify the Makefile of pghintplan:
==== copy /usr/local/pgsql/16.2/bin/pg_config in Makefile
# Modify Makefile: change line
#   PG_CONFIG = pg_config
# to
#   PG_CONFIG = /usr/local/pgsql/16.2/bin/pg_config

make
sudo make install

rm -rf ~/imdb initdb
pg_ctl -D ~/imdb initdb

==== MAKE SURE YOU USE THE RIGHT .CONF!!
cp ~/postgresql.conf ~/imdb/

pg_ctl -D ~/imdb start -l logfile

==== if haven’t download
wget -c http://homepages.cwi.nl/~boncz/job/imdb.tgz && tar -xvzf imdb.tgz
==== Now, use balsa’s code to load job data
cd ~/balsa
bash load-postgres/load_job_postgres.sh ~/datasets/job
cd ~/robust-vcm